mysql常用命令及方法

创建只读账号(密码貌似需要大写+小写+特殊符号,设置简单了会提示 Your password does not satisfy the current policy requirement)

登陆
mysql -uroot -p
创建qxread账号
mysql> grant select on *.* to 'qxread'@'%' IDENTIFIED BY "Qxrxxxx111.";
Query OK, 0 rows affected, 1 warning (0.00 sec)
刷新
mysql> flush privileges;