hey, i installed apache, php and mysql from the redhat cds (under the websever package) it works fine but I want to edit the mysql information. basicly, i don't want to be using root and no password as my log in.

where do i edit the default username and password for mysql?

thanks,

-Nay

From my little sql experience, I do know that the password that sql asks you for is not the root password.

You set this yourself, and it doesn't have to be the same as the root password. I don't know whether or not you also have to be root.

you can add a user to mysql that has mysql root/admin privileges for a specificsdatabase as mysql root ie.

use mysql;

Grant all on unholys_database to unholy@'localhost' identified by 'some_password_or_other';

flush privileges;

It's a good idea to add a password for mysql root though and delete the "blank" user if you haven't already done so


use mysql;

delete from user where user=''; (two apostrophes)

flush privileges;


add a password for root

use mysql;

update user set password=PASSWORD('whatever_password') where user ='root';

flush privileges;