Server :: Create New Database From PHP / SQL

Nov 4, 2010

I am now able to create the database using PHP and SQL. But it seems I can only do it as MySQL root user.. $dbuser = 'root'; but is there a way to do that as a regular MySQL user?

View 2 Replies


ADVERTISEMENT

Server :: Cannot Create Database In PostgreSQL

Dec 26, 2010

i installed Fedora 14 on my machine,then i installed postgresql in it i started it and configured it after seeing link [URL] i am able to do su - postgres but when i am trying to create database in it am getting error,It is asking for password then i am giving my root password

createdb company
Password:
createdb: could not connect to database postgres: FATAL: password authentication failed for user "postgres"

View 1 Replies View Related

Server :: Mysql - Cannot Create Database

Jul 28, 2009

I tried creating a database in mysql but couldn't do so...here is the message i got from the shell:

Code:

View 4 Replies View Related

CentOS 5 :: Create A Server For A Database That Has A .db File

Jan 25, 2010

I need to create a server for a database that has a .db file that is over 800Gb. now my first disk is 50Gb and i do the standard

100m ext2 boot
2000m swap
* / ext3

now I have a second 1.2T that i want to be /opt is there a way to set up 4kib block size in ext3 in the os install? or should I do it after the install? Is this block size even big enough?

View 11 Replies View Related

Server :: RedHat - Unable To Create Cluster Luci Database Objects

Dec 22, 2010

I want to create redhat cluster on(vmware) OS Redhat Enterprise Server 5.5
Install Luci on node1
Install ricci on node2
Install ricci on node3

All the computer name records in all system host file. When I try to create new cluster( luci_install init) then showing error...
Status messages:
* Host stationx.example.com is already authenticated
* Host stationy.example.com is already authenticated
[dismiss]

The following errors occurred:
* Unable to create the cluster Luci database objects
***No any cluster.conf file created on any node
I have reinstall the node, but getting same error.

View 1 Replies View Related

Fedora :: Create A Database And Tables?

Jan 13, 2011

I am trying to create a database and tables. Does anyone know a reference website that can help me with this or does anyone know how to do this?

View 3 Replies View Related

Ubuntu Servers :: How To Create New Database

Mar 30, 2010

ubuntu 9.10 64 biti try to install XAMPP and i want to create new database by use phpMyAdmin
at MySQL localhost create new database it show No Privileges how to create new database from terminal

View 4 Replies View Related

Ubuntu Servers :: Create New Database In OpenLDAP?

May 24, 2010

I want to create a new LDAP database.

Part of the new configuration is

Code:
dn: olcDatabase={1}hdb,cn=config
objectClass: olcDatabaseConfig
objectClass: olcHdbConfig
olcDatabase: {1}hdb

[Code].....

View 2 Replies View Related

Ubuntu :: Create An OpenBiblio Database User?

Dec 8, 2010

I'm attempting to install OpenBiblio to give it a test drive. I'm having trouble with one of the first steps within the openbiblio install guide. The step is dealing with MySQL in creating user priveleges to the db created. The step is:

Create an OpenBiblio database user. To do this, login to MySQL under the admin userid and run the following SQL command, substituting obiblio_user and obiblio_password with the userid and password of your choice.

mysql> grant all privileges on OpenBiblio.* to obiblio_user@localhost
-> identified by 'obiblio_password';

When I run the "grant all priveleges" command I receive a syntax error. I've spent some time googleing and it comes up with the same command. There has been a few variations attempted such as 'obiblio_user'@'localhost' but still recieve a syntax error.

View 2 Replies View Related

Server :: Database Stopped Showing Up - Files Still There - Restore The Database From The Files?

Jul 8, 2011

I recently moved into a new place and when I hooked up my webserver, I wasn't able to bring up my page, even from localhost. With some digging, it seems that I can't access the database that housed my posts (wordpress installation). I looked for the datadir in MySQL and that directory shows the wordpress directory that should be holding the database and all the files are still there. 1) why the database no longer shows up 2) how to restore the database from the files?

View 2 Replies View Related

OpenSUSE :: Create A Database With The Mysql That Came With The Suse Installation?

Aug 11, 2011

i'm trying to create a database with the mysql that came with the suse installation, my problem is that i can't get mysqladmin to work it spits out this: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (2)' Check that mysqld is running and that the socket: '/var/run/mysql/mysql.sock' exists! So I'm stuck at square one php info() seems ok with the installation and the installed client connects to my remote DB ok. I checked the server with ps -ef | grep mysqld and I get the following:

2438 2436 0 15:47 ? 00:00:00 /usr/sbin/mysqld --defaults-file=/home/ben/.local/share/akonadi//mysql.conf --datadir=/home/ben/.local/share/akonadi/db_data/ --socket=/home/ben/.local/share/akonadi/socket-linux-ygk7.site/mysql.socket root 6248 6151 0 16:01 pts/0 00:00:00 grep mysqld

Which doesn't really mean a lot to me but looks ok, anyway my question boils down to does anyone have any obvious ideas of what I'm doing wrong or is, as others have hinted, suse's mysql installation is broken?

View 5 Replies View Related

Ubuntu Multimedia :: Create Ratings Database For MPD Dynamic?

Feb 1, 2010

Does anyone know how the ratings database for mpd-dynamic is meant to look and/or if there's a program to create the database automatically?

View 2 Replies View Related

Ubuntu :: ERROR 1006 (HY000): Can't Create Database

Mar 13, 2011

PHP Code:

#mysql -u root -pPassWordmysql> create database whatever;ERROR 1006 (HY000): Can't create database 'whatever (errno: 13)mysql> 

Searching around I found a site that says the following:

PHP Code:

# chown -R root:mysql /usr/local/mysql# chown -R mysql:mysql /usr/local/mysql/data 

/usr/local does not have a mysql folder There is a mysql in /usr/share but no data folder in /usr/share/mysql

what I need to do? I just installed mysql-server on this machine.

I am using: Server version: 5.0.75-0ubuntu10.5 (Ubuntu)

Ubuntu 9.04 Jaunty

View 3 Replies View Related

General :: Makefile - Unable To Create For The Ones That Do Involve Database

Nov 23, 2010

I am new to creating make files. I have been able to create simple makefiles for those applications which do not involve database but am unable to create for the ones that do involve database.

That's how my make file looks

Code:

clean:

tar:

There is no error in the code because when I compile the code through the following command, it gives me no error

Code:

The error msg is:

Code:

Where am I going wrong? Am I not providing the correct mysql path?

View 4 Replies View Related

Software :: Create Mysql Database From Command Line?

Feb 13, 2010

I want to create database from script directly by taking inputs USER, PASSWORD and DBNAME.code...

How to resolve this or any alternate method (other than entering into mysql prompt like mysql -u USER -pPASSWORD)?

View 3 Replies View Related

Software :: Opsview Unable To Create Database Using Mysql)?

Aug 12, 2010

After the Opsview packages have been installed, it is necessary to configure Opsview and its databases.but while running below command get an error,#mysqladmin -u root password {password}mysqladmin: connect to server at 'localhost' failederror: 'Access denied for user 'root'@'localhost' (using pa

View 4 Replies View Related

Ubuntu Servers :: Root Has No Privileges To Create Database In Phpmyadmin?

Apr 11, 2010

I logged in phpmyadmin as root (with password that I just created in terminal), old databases are there but I have no privileges to create a new one.

View 1 Replies View Related

General :: Mysql Error Can't Create Database 'test' When Configure?

Feb 8, 2010

mysql -u root -p but unable to create any database.

if i tried to configure it's giving error ERROR 1006 (HYOOO) : can't create database 'test' (error: 2)

my location for database is /var/lib/mysql and permissions are

drwxrwxrwx mysql root.....

View 1 Replies View Related

CentOS 5 :: Phpmyadmin Unable To Create A New User In Mysql Database

May 13, 2010

I have installed on a remote server phpmyadmin 3.3.1 and mysql 5.1.46 on a centos 5.4 OS.

Any newly created user with phamyadmin is unable to login both from mysql command line (from localhost) and phpmyadmin (localhost and remotely).

No prob when the user is created with mysql command line (from localhost). All of the users created with phpmyadmin, are not "visible" recognized from the show user command via the mysql command line. The setting I used when I create any user was the same as the ones with the mysql command line creation.

The error message I get when accessing from mysql command line (from localhost) is the following: "Access denied for user ... @localhost (using password: yes)"

View 2 Replies View Related

Programming :: Convert The XML Output Files To SQL In Order To Create Or Update An SQL Database?

Dec 7, 2010

I've a program which manages my pdf and references. I wish to put some of the information on my website but that program (Mendeley) does export only in XML (or bibtex). I'd like to simply convert the XML output files to SQL in order to create or update an SQL database.I'm not an expert in either XML or SQL (use only PHPMyadmin). Does someone get help me to figure out?

View 2 Replies View Related

Software :: Create User With Password And Read / Write Privileges For Program Database

Oct 11, 2010

Unless your distro has taken care of it Centos 5.5, you'll need to create a user with a password and read/write privileges for program database. You can do this using the MySQL command line client if you are familiar with it. Well I am not familiar with it, so I wam wondering how to do it. As well when I run

mysql - p program </usr/share/program/mysql.sql>

It asks for a password. how do i find out this password.

View 1 Replies View Related

Server :: MySQL Move Database / Server Doesn't Start

Nov 3, 2010

I'm trying to move a mysql 5.1.50-community InnoDB database from one location to another.When starting the service I get:Starting MySQL.Manager of pid-file quit without updating file [FAILED]I've searched for a way to do this but I can only find people who describe what I've just done.

View 6 Replies View Related

General :: Create A New Mysql User And A Mysql Database At The Shell Prompt?

Aug 7, 2010

How do I create a new mysql user and a mysql database at the shell prompt?

View 1 Replies View Related

Server :: Slow Database Server On Processing / Make It Up?

Apr 15, 2010

I'm having trouble with my database server run with PHP & MYSQL; i just installed this system on a SUSE Linux Enterprise Sever; the Server its self is an HP Proliant ML370G with 4GB RAM
The system was fine for like 3 weeks until recently when it started slowing down. Apparently, eveything is normal when you are accessing the server, for example when you are browsing on the database web interface; but problem is when you start working in the database, when you try submitting into the database, its really slow on processing, i have to first restart the mysql;
Could it be RAM? or the SQL itself?

View 3 Replies View Related

CentOS 5 Server :: Put A MySQL Database In A Server's Memory?

Mar 18, 2010

I'm looking for a way to put a MySQL database in a server's memory. The disks aren't fast enough to keep up with the usage and I don't feel like going for a splitted web&db server yet because of the costs.

Because this involves risks (unless there's a way to read from the memory and write to the memory AND disks?), so I'd prefer that the DB gets copied automatically every hour or so to the local disks.

View 1 Replies View Related

General ::Create Custom Name Server \ Create Own Name Server?

Nov 4, 2009

I bought a web hosting account(cPanel) and I want to create my own name server(ns1 and ns2.mydomain.com). So when I want to host addon domain, I can point them to my name server instead of hosting company name server.

View 10 Replies View Related

Server :: Database Can't Use SSL Certificates?

Apr 19, 2011

I've installed PostgreSQL on Arch Linux & also self generated self signed certificates in /etc/ssl/ directory. My PostgreSQL 'data' directory is /var/lib/postgres/data & I've edited my postgresql.conf file to use SSL however I'm having permission / access problems starting my database using SSL. It can't access the certificates and errors out when I try and start the database engine:

Code:
LOG: autovacuum launcher shutting down
LOG: shutting down
LOG: database system is shut down
FATAL: could not load server certificate file "server.crt": No such file or directory
code....

I don't know what I need to chown or chmod in order to get PostgreSQL to access my self signed certificates.

View 3 Replies View Related

Server :: Sync One Database To Other?

Nov 8, 2010

I have got 2 postgresql databases on separate servers. i want to sync one database to the other. how it can be done ?

View 1 Replies View Related

General :: Monitor Database IO And Available Database Threads?

Mar 7, 2011

am using zabbix open source solution for systems monitoring. I am facing a problem and discussed it on zabbix forum. my post was as "My zabbix server is behaving abnormally, approximately daily from 9 to 12, the server stop accumulating logs. I observed that the server report is RUNNING but it did not accumulate log values and also the machine have no extra load. Its shown in the graph image attached.t the following reply,"database performance?are you monitoring database IO and available database threads? "So any one have any idea that how can I do this as I am using MySQL as backend database on RHEL 3.

View 1 Replies View Related

General :: Importing Database To Server

Apr 19, 2011

I switched from Windows 7 to Linux and when I'm trying to import my database i get error 1044. It used to work when I was using Windows 7. I was able to export the database from my localhost. However, when I try to import it to the other server I get this:#1044 - Access denied for user ' '@'%' to database'.I have been trying for hours to upload my site from the localhost to another server without any luck..I'm using phpmyadmin to import it.

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved