By pstein on

As far as I understood I have to create a mySQL database prior to install the actual DruPal.

Is there somewhere a guideline/step-by-step tutorial on how to create a MySQL database with phpmyadmin?

This should answer foe example which collations should be used, Which DBname and port is recommended for Drupal.
Which username and password....

Can I change these settings later from within a running DruPal?

Peter

⋅ Categories: Drupal 6.x

Comments

pobster’s picture

pobster commented

Read the INSTALL.txt file (and the INSTALL.mysql.txt file) in your Drupal download.

Pobster

Elteto’s picture

Elteto commented

Generally, the only changes you should want to do to Drupal MySQL settings after installation are host name and database name, in case you migrate to a new host. You do not want to change table prefixes, as you would have to go into the database manually and rename each table.

Once you log in to phpMyAdmin, you will see an option about halfway down the home page to "Create new database". Name it something short and descriptive, such as drupal, or drupal6, or mysitedb. Some hosting services do not allow you to create new databases directly from phpMyAdmin; instead, they have you use their own web control panel. If you do create the database in phpMyAdmin, for collation select "utf8_general_ci". This will future proof your Drupal installation for all sorts of possible character sets.

The Drupal tables are created by Drupal during installation. Even if Drupal has its OWN database on your host, it is good practice to still assign a table prefix, generally "drupal_", in case you will have more applications accessing the same database. This will help you keep all your Drupal tables in one coherent group. If you have multiple sites or multiple Drupal installations, use drupal6_ or mysite1_ as table prefixes.

Remember, if you have multiple web sites running from the same Drupal installation (multisites), each site will need its own set of tables. In that case, definitely use descriptive table prefixes, such as mysite1_ and mysite_2, or drupal1_ and drupal2_.

Port should be left blank, it is automatically 3306 for MySQL. The user name and password are the same as your provider gave you for accessing your MySQL installation.

===================
http://www.elteto.net

Avatar’s picture

Avatar commented

I am trying to test making a site on my local machine. Everything is ok, but what is the password for the database.
I used phpmyadmin and didn't need to insert any passwords, I just created the database

I understand the user name is "root", but what is the password???

Avatar’s picture

Avatar commented

password is nothing, i forgot that. My problem installing was that I forgot to make a copy of the default.settings.php file