Skip to content

Instantly share code, notes, and snippets.

@samsonasik

samsonasik/gist:3988822

Created October 31, 2012 18:18
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save samsonasik/3988822 to your computer and use it in GitHub Desktop.
Save samsonasik/3988822 to your computer and use it in GitHub Desktop.
Download ZIP
Set Global Read-only false in Mysql
Raw
gistfile1.txt
Directory my mac :
/usr/local/mysql-5.5.21-osx10.5-x86_64/data
grant all on *.* to 'root'@'%'
mysql> set GLOBAL read_only = false;
Query OK, 0 rows affected (0.00 sec)
mysql> FLUSH TABLES WITH READ LOCK;
Query OK, 0 rows affected (0.07 sec)
mysql> UNLOCK TABLES;
Query OK, 0 rows affected (0.00 sec)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment