polardbxengine/mysql-test/suite/auth_sec/t/noacl_imply_nonet.test

18 lines
442 B
Plaintext

SHOW VARIABLES LIKE 'skip_networking';
--error ER_OPTION_PREVENTS_STATEMENT
SET PASSWORD = 'foo';
--echo # Attempting to connect using network. Must fail.
--error 1
--exec $MYSQL -uroot --host=127.0.0.1 -P $MASTER_MYPORT
--echo # Verify that we can operate the system
CREATE DATABASE db1;
use db1;
CREATE TABLE t1(c1 INT);
INSERT INTO t1 VALUES (1),(2),(3);
SELECT * FROM t1;
UPDATE t1 SET c1=0;
DROP TABLE t1;
use mysql;
DROP DATABASE db1;