mysql中read_only_MySQL里改read_only变量

C:\Documents and Settings\Administrator>mysql -u root

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 2

Server version: 5.6.11 MySQL Community Server (GPL)

Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show variables like 'read_only';

+---------------+-------+

| Variable_name | Value |

+---------------+-------+

| read_only | OFF |

+---------------+-------+

1 row in set (0.02 sec)

mysql> set global read_only=on;

Query OK, 0 rows affected (0.00 sec)

mysql> show variables like 'read_only';

+---------------+-------+

| Variable_name | Value |

+---------------+-------+

| read_only | ON |

+---------------+-------+

1 row in set (0.00 sec)

mysql> use test

Database changed

mysql> show tables;

+----------------+

| Tables_in_test |

+----------------+

| y2k |

+----------------+

1 row in set (0.00 sec)

mysql> select * from y2k;

+------------+---------------------+---------------------+

| date | date_time | time_stamp |

+------------+---------------------+---------------------+

| 1998-12-31 | 1998-12-31 23:59:59 | 1998-12-31 23:59:59 |

| 1999-01-01 | 1999-01-01 00:00:00 | 1999-01-01 00:00:00 |

| 1999-09-09 | 1999-09-09 23:59:59 | 1999-09-09 23:59:59 |

| 2000-01-01 | 2000-01-01 00:00:00 | 2000-01-01 00:00:00 |

| 2000-02-28 | 2000-02-28 00:00:00 | 2000-02-28 00:00:00 |

+------------+---------------------+---------------------+

5 rows in set (0.19 sec)

mysql> insert into y2k values ('2000-02-29','2000-02-29 00:00:00',20000229000000

);

Query OK, 1 row affected (0.22 sec)

mysql> select * from y2k;

+------------+---------------------+---------------------+

| date | date_time | time_stamp |

+------------+---------------------+---------------------+

| 1998-12-31 | 1998-12-31 23:59:59 | 1998-12-31 23:59:59 |

| 1999-01-01 | 1999-01-01 00:00:00 | 1999-01-01 00:00:00 |

| 1999-09-09 | 1999-09-09 23:59:59 | 1999-09-09 23:59:59 |

| 2000-01-01 | 2000-01-01 00:00:00 | 2000-01-01 00:00:00 |

| 2000-02-28 | 2000-02-28 00:00:00 | 2000-02-28 00:00:00 |

| 2000-02-29 | 2000-02-29 00:00:00 | 2000-02-29 00:00:00 |

+------------+---------------------+---------------------+

6 rows in set (0.00 sec)

mysql> show variables like 'read_only';

+---------------+-------+

| Variable_name | Value |

+---------------+-------+

| read_only | ON |

+---------------+-------+

1 row in set (0.00 sec)

mysql> create database new;

Query OK, 1 row affected (0.03 sec)

mysql> use new

Database changed

mysql> create table y2k (date DATE, time TIME);

Query OK, 0 rows affected (0.80 sec)

mysql> select database();

+------------+

| database() |

+------------+

| new |

+------------+

1 row in set (0.00 sec)

mysql> insert into new.y2k values ('2013-5-25', '08:53:00');

Query OK, 1 row affected (0.27 sec)

mysql> select * from new.y2k;

+------------+----------+

| date | time |

+------------+----------+

| 2013-05-25 | 08:53:00 |

+------------+----------+

1 row in set (0.00 sec)

mysql>