Confirm that it's actually working with the mysql command-line client.
No problem there:
| ~/tools/mysql >./bin/mysql -u root -p | Enter password: | Welcome to the MySQL monitor. Commands end with ; or \g. | Your MySQL connection id is 2035 to server version: 4.0.17 | | Type 'help;' or '\h' for help. Type '\c' to clear the buffer. | | mysql> create database wikidb2; | Query OK, 1 row affected (0.01 sec) | | mysql> drop database wikidb2; | Query OK, 0 rows affected (0.50 sec)
Check for bogus blank root users.
Hm, I'm not too far into DB administration; is one of these suspicious?
mysql> select host,user from user; +---------------------------+----------+ | host | user | +---------------------------+----------+ | % | root | | % | sqluser | | % | wikiuser | | xxxxxx01.de.company.com | root | | localhost | root | | localhost | sqluser | | localhost | wikiuser | | localhost.localdomain | root | | localhost.localdomain | sqluser | | localhost.localdomain | wikiuser | +---------------------------+----------+
(Altered the "xxx"-line for privacy resons)
Try creating the database first.
You mean, manually inside mysql?
| mysql> create database wikidb2; | Query OK, 1 row affected (0.02 sec)
Same result after submitting the config-script after that.
Greetings Philipp