Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How do I exit MySQL safe mode?

Tags:

mysql

I stupidly tried MySQL_update as I am having issues granting permissions to remote ips but I went into safe mode with /usr/bin/mysqld_safe --skip-grant-tables

and now I can't get out of it

enter image description here

How do I get out of this safemode

like image 574
TomJackJones23 Avatar asked Jan 03 '15 13:01

TomJackJones23


People also ask

How do you exit a MySQL database?

Type \q to exit the mysql program. Type the user's password, and then press Enter.

What is MySQL safe mode?

If the safe UPDATE mode is enabled, MySQL does not run the UPDATE or DELETE if you try to execute them without a WHERE and LIMIT statement also if there is no condition with the key column.

How do I disable MySQL Workbench in safe mode?

You also can disable safe mode in MySQL Workbench, go to Edit -> Preferences -> SQL Editor, and uncheck "Safe Updates" check box.


1 Answers

Firstly, your last command didn't end, so type ; to end the current command. Then you can continue, including the following to exit mysql altogether.

Simply use the following command/keys.

Hold CTRL and press X or Z

like image 92
wharfdale Avatar answered Oct 31 '22 19:10

wharfdale