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