Thursday, September 1, 2011

MySQL installation and configuration under CentOS 5.6 64-bit

We have to search the name ho the packet to install....
yum search mysql
For my distribution the packet name mysql-server.x86_64
so do:
yum install mysql-server.x86_64
At installation completed, mysql is without password, and is down.
So startup the mysql
service mysqld start
so give the following command to reset password
UPDATE mysql.user SET Password=PASSWORD('NewPassword') WHERE user='root';
and
flush privileges;
to runtime flush up the executed command.
Give exit to logout to the mysql connection and test new root account logging in with the new credentials:
mysql -uroot -p

Bye

No comments:

Post a Comment