I'm new to Drupal, and new to MySQL for that matter. I want to setup a Drupal personal blogging site, and downloaded the Drupal software to try it out.
I did a fresh install of CentOS Linux, included MySQL, PHP, and Apache in the program installation options; enabled the mysqld service after the install finished, and made sure Apache was running too.
After downloading and untarring the Drupal software, I moved all files per the Drupal install instructions into /var/www/html.
I ran the next line in the installation instructions:
mysqladmin -u dba_user -p create drupal
It prompted for a password; I entered a password and got the following response:
mysqladmin: CREATE DATABASE failed; error: 'Access denied for user ''@'localhost' to database 'drupal''
MySQL installed a "mysql" user; and I added a "dba_user" user account. I've tried logging in using all three users (mysql, dba_user, and root) and haven't been successful with any of them.
What could I be doing wrong? It's probably a simple thing. I'm very new to both Drupal and MySQL, so I could be missing something very basic.
The version numbers of PHP, Apache, MySQL, and Drupal I'm using are
php 4.3.9-3.2 mysql 4.1.7-4 httpd 2.0.52-9 Drupal 4.6
Paul