MySQL problem...

dspeer

My problem isn't really related to PHP, though I use it to connect to a MySQL database on a Windows box. I am migrating things over to a Red Hat box using MySQL 3.23.49. My problem lies with the new box. I can start the server fine and log in using the generic mysql account plus one I have created, though I do not have administrative rights. My first thought was to run mysqladmin on the user, but it gives me the following error message:
"mysqladmin: unable to change password; error: 'You are using MySQL as an anonymous user and anonymous users are not allowed to change passwords'"
I am doing this all while logged in as the root user. I tried the same logged on as my personal user account and got the exact same problems and messages. I am running tight on a deadline and need some help desperately. Any ideas?

ultraslacker

With mysql running -

mysqladmin -u root password

dspeer

I tried this in all kinds of ways... I still get the errors...
Access denied for user

ultraslacker

By default root has full access privleges - I would take a look at the grant tables. Try mysqladmin reload (or just restart server).

ahundiak

Start here and do some reading.
http://www.mysql.com/doc/en/Privilege_system.html
Even with a deadline, you will still need to take some time and understand how to setup users and permissions. There is no majic one or two sentence solution.

Especially if you have already tried "all kinds of way". You will probably need to reinstall and start clean.

dspeer

Okay, it has been resolved and fixed... It turns out our Network Admin set the password during the initial installation. When I did the purge and reinstalled it, it did not get rid of the user permissions or passwords. We tried the password he used, and voila: ready to go.