title: MySQL create table issue with --read-only error
body: <p>I'd like to create a user who has all privileges with his own database in MySQL.</p>
  
  <p>When I use this user to create a table, MySQL returns that the SQL server is running with read-only option.</p>
  
  <p>However when I changed to an another existing user with all privileges on <code>*.*</code>, I can create table without error.</p>
  
  <p>I'm wondering if the read-only option is global or what?</p>
  
  <p>The following is my MySQL commands using MySQL root:</p>
  
  <pre>
  mysql> create user 'demo'@'localhost' identified by 'demo';
  mysql> create database demo;
  mysql> grant all privileges on demo.* to demo@localhost;
  mysql> show grants for demo@localhost;
  +-------------------------------------------------------------------------------------------------------------------+
  | Grants for demo@localhost                                                                                   |
  +-------------------------------------------------------------------------------------------------------------------+
  | GRANT USAGE ON *.* TO 'demo'@'localhost' IDENTIFIED BY PASSWORD '*demo-hashed*' |
  | GRANT ALL PRIVILEGES ON `demo`.* TO 'demo'@'localhost'                                                |
  +-------------------------------------------------------------------------------------------------------------------+
  2 rows in set (0.00 sec)
  </pre>
  
  <p>Then I switched to user "demo":</p>
  
  <pre>
  mysql> use demo;
  Reading table information for completion of table and column names
  You can turn off this feature to get a quicker startup with -A
  
  Database changed
  mysql> create table t(t1 int);
  ERROR 1290 (HY000): The MySQL server is running with the --read-only option so it cannot execute this statement
  </pre>
  
  <p>So I checked the read-only option, and it seems to be on.</p>
  
  <p>However then I tried using another user with privileges on <code>*.*</code> and I can create tables successfully.</p>
  
  <p>The another user grant setting:</p>
  
  <pre>
  mysql> show grants for demo2@'%';
  +-----------------------------------------------------------------------------------------------------------------+
  | Grants for demo2@%                                                                                            |
  +-----------------------------------------------------------------------------------------------------------------+
  | GRANT ALL PRIVILEGES ON *.* TO 'demo2'@'%' IDENTIFIED BY PASSWORD '*demo2-hased*' |
  +-----------------------------------------------------------------------------------------------------------------+
  1 row in set (0.00 sec)
  </pre>
  
  <p>MySQL version:</p>
  
  <pre>
  mysql> select version();
  +------------------------+
  | version()              |
  +------------------------+
  | 5.1.68.0 |
  +------------------------+
  1 row in set (0.00 sec)
  </pre>
  
  <p>BTW, after I set <code>read_only = 0</code> I can use <code>demo</code> to create table. I just don't know why the <code>demo2</code> can create table while read-only is on.</p>
  
  <p>Thanks!</p>