[SOLVED] how to change mysql user administrator

[jorgeSallum]

Hi folks,

I have to deal with a server in which mysql was already installed by someone else, and strangely I have mysql access only by a non-root user. I tried to clean it and emerge it again unsuccessfully. How can I change it in order to have access by root user?

Thanks, J.

[juliuspc]

What did you mean by "clean"? Was it the cleaning or the re-emerging that was unsuccessful? Did you get an error message?

Do you have databases and user prvileges on the system that you need to preserve? Can you take them offline or no?
_________________
--
Julius

living under a rock
JuliusPC consulting
discover fantastic shops

[jorgeSallum]

Thanks Juliuspc,

I take mysql off with "emerge -c mysql" and reemerge it and everything is ok despite the fact that I'm not able to connect with root (mysql -u root), but only with other user (mysql -u jose). The message error is...

[kashani]

It's a bit more complicated than that. First off root is not a priviledged account in Mysql. It's merely what most people designate as the admin account in Mysql. You can also have multiple admin accounts by handing out the proper privileges. In your case it's likely that the admin account is not the root account or that it needs a password you don't have.

Does your non root account have Y,Y,Y,Y privileges across the board in mysql.user? If so it's an admin account.

In order to gain access to Mysql you would need to remove /var/lib/mysql/mysql/ where all the access is stored. I'd stop Mysql, move that dir to some where else, start Mysql, and then run the script it'll tell you to in order to setup the db.

kashani
_________________
Will personally fix your server in exchange for motorcycle related shop tools in good shape.

[juliuspc]

If you don't need the databases and user privileges already on the server, then you can do this:

Stop the MySQL server:

[jorgeSallum]

Thanks Julius, it's running perfect now.