Hi,

I have installed MySql on a linux box. I try running the following and get this error.I have entered the root password and nothing.

[root@maauto ~]# /usr/bin/mysql_secure_installation




NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MySQL
SERVERS IN PRODUCTION USE! PLEASE READ EACH STEP CAREFULLY!


In order to log into MySQL to secure it, we'll need the current
password for the root user. If you've just installed MySQL, and
you haven't set the root password yet, the password will be blank,
so you should just press enter here.

Enter current password for root (enter for none):


ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
Enter current password for root (enter for none):
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
Enter current password for root (enter for none):

I try to change the password and get the below.


[root@maauto ~]# /usr/bin/mysqladmin -u root password 'mysql'
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)'
Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists!

Linux maauto.lin.com 2.6.32-71.el6.i686 #1 SMP Fri Nov 12 04:17:17 GMT 2010 i686 i686 i386 GNU/Linux



Any help would be appreciated.

If you want to recover mysql password,

Stop mysql service

#/etc/init.d/mysql stop


These will skip password prompt

#mysqld_safe --skip-grant-tables &

Then you can login mysql without mysql password & after login you can change mysql password

#mysql -uroot

mysql> use mysql;
mysql> update user set password=PASSWORD("password") where User='root';
mysql> flush privileges;
mysql> quit

#service mysqld restart

Login mysql with rechanged password

#mysql -uroot -p

This was great. For some reason I have to use mysqld not mysql but all the steps worked.

1 members found this post helpful.