Tuesday, March 1, 2011

Using MySql on Fedora Core Linux

Good Links to use MySql on Fedora Core:
http://www.knowledgesutra.com/forums/topic/31717-what-is-mysqls-default-root-password/

The default user is root and the password is, as they say blank for default.

You can set the root password by typing this:
# mysqladmin -u root password 'new-password'


You can then login by typing this:
# mysql -u root –p

Then you'll be prompted to provide the password you specified earlier.

You also might want to delete the anonymous user in the User's table. The default configuration of MySQL allows any user access to the system without
providing a username or password.

Delete the user by typing this:
# mysql -u root –p
mysql> use mysql
mysql> delete from user where User='';
mysql> quit

No comments:

Post a Comment