Hi,

Does anyone know which file holds the mysql database? I've got the error
mysql> use mysql;
ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'mysql'

and all the different "fixes" I've tried have failed. I'd like to replace the current file with an original. I just need the filename.


Your help is much appreciated.

Have you tried to give root All Privileges.

thanks for the reply. I tried that and a lot of other things, none of them worked. In the end I removed the /var/lib/mysql/mysql/user.* files and ran /usr/bin/mysql_install_db and now I can get in.

No use if you've already got a bunch of users, but sorted out my problem.

That will get you every time. The first time I have dealt with mysql I couldn't figure out why I was getting the same problem. But mysql_install_db sets up all the initial rights and gives the root account grant permissions on the user table under the mysql database.

One last thing. If you plan to administer you mysql db from a remote connection you might want to run

Mysql installs a manual in /usr/share/doc/packages/mysql. There is a section on securing it. The default config has a couple tables where root has full privileges with no password.

thanks for the help. Every time I've ever had to use mysql something has gone wrong at the setup stage, on whatever platform. You could say it was me but I've been using the mysql manual or other people's instructions... personally, I think the setup is crap. It's insecure by default, and there's enough people out there posting with similar problems to make me think they ought to do something about it.

I'll be using Postgres next time - for all the extra work I at least want a real database - and if anyone says I have to use mysql then they can do it themselves!