This article contains information about mysql safe mode such as start mysql in safe mode, find mysqld_safe location, changing password.<\/p>\n
Sometime you want to connect to your DB server without password because:<\/p>\n
In this article let assume we forgot our userID password\u00a0and would like to reset it.<\/p>\n
sudo service mysql stop<\/pre>\nFind mysqld_safe location<\/h3>\n
To find the mysqld_safe location run the below command.<\/p>\n
which mysqld_safe<\/pre>\nStart MySQL in Safe Mode<\/h3>\n
To start mysql in safe mode run the below command.<\/p>\n
sudo [\/location_of_mysqld_safe]\/mysqld_safe\u00a0--skip-grant-tables--skip-networking<\/pre>\n–skip-grant-tables: This option causes the server to start without using the privilege system at all, which gives anyone with access to the server\u00a0unrestricted access to all databases<\/em><\/span><\/p>\n
–skip-networking : This option will block TCP\/IP Connection to MySQL except local connection.<\/p>\n
This will be an ongoing command until the process is finished so open another shell\/terminal window, log in without a password:<\/p>\n
mysql\u00a0-u root -p<\/pre>\nYou don\u2019t have to provide a password here, nice isn\u2019t it!!<\/p>\n
update mysql.user set authentication_string=password('myPassword') where user='xxx' and host='xxx';<\/pre>\n(replace xxx with your own userID and password)<\/p>\n
flush privileges;\r\n\r\nquit;<\/pre>\nStart MySQL server<\/span><\/h3>\n
sudo service mysql start<\/pre>\nNow you should be able to connect to root with your new password :<\/span><\/p>\n
mysql\u00a0-u root -p<\/pre>\nGive it a try in your development environment at first. Do not forget trying everything on development first.<\/p>\n
You can find many more article about MySQL and many databases at dbtut. Use our navigation menu to reach every article you need or our search section on the upper right.<\/p>\n\n
<\/div>\n