mysql-test/suite/auth_sec/t/noacl_imply_nonet.test
raw| 1 | SHOW VARIABLES LIKE 'skip_networking'; |
| 2 | --error ER_OPTION_PREVENTS_STATEMENT |
| 3 | SET PASSWORD = 'foo'; |
| 4 | --echo # Attempting to connect using network. Must fail. |
| 5 | --error 1 |
| 6 | --exec $MYSQL -uroot --host=127.0.0.1 -P $MASTER_MYPORT |
| 7 | --echo # Verify that we can operate the system |
| 8 | CREATE DATABASE db1; |
| 9 | use db1; |
| 10 | CREATE TABLE t1(c1 INT); |
| 11 | INSERT INTO t1 VALUES (1),(2),(3); |
| 12 | SELECT * FROM t1; |
| 13 | UPDATE t1 SET c1=0; |
| 14 | DROP TABLE t1; |
| 15 | use mysql; |
| 16 | DROP DATABASE db1; |
| 17 |