Drupal Database configuration

ex-para · 11-13-2009, 11:50 AM

I have got to Database configuration basic options in Drupal 5.2. in connection with a server in Ubuntu 8.04.
Database type, Database username and Database password where already entered and a radio button high lighted on mysql. I can't workout what I put in Datarbase name as it says The name of the datarbase your Drupal data will be stored in. It must exist on your server before Drupal can be installed.
I have looked in FAQ but that has confused me more. I have installed all the files for the server and this is the last thing I have to do. I would appreciate any help regarding this.

choogendyk · 11-13-2009, 05:55 PM

Before you do the configuration on the web, you need to set up the database in MySQL.

Login to MySQL as root and execute the following commands (choosing an appropriate database name, user name, and password):

Code:

> create database <databasename>;

> GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES ON <databasename>.* TO '<username>'@'localhost' IDENTIFIED BY '<password>';

> flush privileges;

Then, when you get back to the web setup of drupal, use the <databasename>, <username>, and <password> that you chose.

ex-para · 11-14-2009, 11:47 AM

Thanks, I have forgot how to login into MySQL could you put me right on that?

choogendyk · 11-14-2009, 01:30 PM

Sounds like you are going to need to dive in and learn some basic stuff about MySQL. You can start here http://dev.mysql.com/doc/refman/5.0/en/tutorial.html. Then, presuming you have MySQL running, you connect from the command line with `mysql -uroot -p` and supply the password when asked. The root account and password should have been set up when you installed and configured MySQL.

If you are running a Drupal site, you will then also want to know how to dump or backup your database. Continue with the tutorial linked above, and ask questions when you have them.

ex-para · 11-26-2009, 08:50 AM

I have read extensively regarding Mysql but I still cant get a running server. I go to phpMyaDmin and it has my username and password (I put no password in while installing) I click on go and get error # 1045-Access-denied for user acme@localh phpMyaDmin using password yes. I go back to phpMyaDmin delete the password and the up it comes. I type localhost in the title bar and get it works, I type 127.0.0.1 and get it works. I got to Drupal database configuration and the mysql button in highleted, database name is blank, database username is filled using acme, database password is filled in but I did not enter any password at the install. I just don't know how to do the daterbase name. I have read many how to's but they stop at the database configuration.

choogendyk · 11-26-2009, 09:21 AM

Go back to my original reply - post #2 above, and it gives you the commands for doing it. When you installed MySQL you had to specify the root password for MySQL.