最近配置服务器用到的
命令行连接数据库:mysql -hlocalhost -uroot -p123456
账户查询:SELECT user,host FROM mysql.user;
账户创建:CREATE USER 'readonly'@'%' IDENTIFIED BY 'Read@2023';
只读权限:GRANT SELECT ON mydb.* TO 'readonly'@'%';
权限刷新: FLUSH PRIVILEGES;
查询权限:SELECT * FROM mysql.user WHERE User='readonly' AND Host='hostname';
从数据库状态: show slave status\G
开启从数据库进程:start slave;
关闭从数据库进程: stop slave;