Missing mysql schema

[williey]

I just install MySql 4.10 and I'm missing the mysql schema database.
The "mysql_install_db" command ran fine..

mysql> create database club
    -> ;
ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'club'
mysql> show databases
    -> ;
+----------+
| Database |
+----------+
| test     |
+----------+
1 row in set (0.04 sec)

 

[TonyGroves]

It looks like a permissions issue; maybe anonymous users can't create databases (which would be typical). Try connecting as root instaed.

 

[williey]

Thanks! I got it to work now..

I reran mysql_install_db from the proper location and the necessary db and tables were created.