Menu
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
How do I get out of this safemode
574
Type \q to exit the mysql program. Type the user's password, and then press Enter.
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.
You also can disable safe mode in MySQL Workbench, go to Edit -> Preferences -> SQL Editor, and uncheck "Safe Updates" check box.
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
92
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
