adspace


  1. Categories >> Software >> Databases >> MySQL
  2. Suggest New Category

write a query to mysql in safe mode and to change the root password

Question Posted / Dileep Kumar Kamal

Answer Posted / Dileep Kumar Kamal

To start MySQL in safe mode, use the command: `mysql -u root --safe-mode`. To change the root password, use the following SQL command after logging in: `ALTER USER 'root'@'localhost' IDENTIFIED BY '[new_password]';`

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is current version of mysql?

1083

What is the current mysql version?

1103

Which statement is used in a select query for partial matching?

1247

How to Change a users password from unix shell.

1222