Write a query to MYSQL in safe mode and to change the root password

asked Sep 13, 2013 in MYSQL by rajesh
edited Sep 12, 2013
0 votes

1 Answer

0 votes
To start MySQL in safe mode, mysqld_safe command is used which allow it to run in the safe mode and it also doesn’t allow the reading of tables with the database passwords:
[root@ ]# mysqld_safe --skip-grant-tables --skip-networking &[1] 13007
[root@ ]# Starting mysqld daemon with databases from /var/lib/mysql
[root@ ]#
After running the MySQL in safe mode the password protection gets removed and to use the password protection mechanism a command is used as follows: 
mysql -u root command
[root@bigboy tmp]# mysql -u root
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 4.1.16
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> [ a message is being shown which allow user to take the control of the root]
answered Sep 13, 2013 by rajesh
edited Sep 12, 2013