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 / brajesh kumar


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

Answer / 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

More MySQL Interview Questions

In which language it is written?

1 Answers  

Why to use char instead of varchar in the database?

1 Answers  

how fastest access of data can be done from database ?

3 Answers  

Print 3 highest salary

9 Answers  

How do you backup a database in mysql?

1 Answers  

How many mysql connections can handle?

1 Answers  

What is the difference between mysql and pdo?

1 Answers  

What does "i_am_a_dummy flag" do in mysql?

1 Answers  

How to create triggers in MySQL?

1 Answers  

How we can see all indexes defined for a table in mysql?

1 Answers  

What is a transaction? Describe mysql transaction properties.

1 Answers  

What is blob and text in mysql?

1 Answers  

For more MySQL Interview Questions Click Here
Categories