Fedora perfect setup server and MySql

sneaky · 08-27-2008, 07:51 AM

This is in the how to by Falko at howtoforge.com

If I do both of the following commands I run into problems and get locked out of mysql.

Should I be only doing the first one to set a pwd for the root.

mysqladmin -u root password yourrootsqlpassword
mysqladmin -h server1.example.com -u root password yourrootsqlpassword

Thanks

Chris

Micro420 · 08-27-2008, 10:21 AM

you actually need the single quotes (I think?). For example,

Code:

mysqladmin -u root password '1337password'

Then once you do that, you can test

Code:

mysql -u root -p