select user, password, host from mysql.user;
GRANT ALL PRIVILEGES ON *.* TO 'root'@'147.114.169.197' IDENTIFIED BY '1' WITH GRANT OPTION;
update mysql.user set password='' where host='147.114.169.197';
flush privileges;
查看数据表的大小:
select concat(round(sum(DATA_LENGTH/1024/1024),2),'MB') as data from information_schema.TABLES;
查看数据库物理文件位置:
show global variables like '%datadir%';
select user, password, host from mysql.user;
GRANT ALL PRIVILEGES ON *.* TO 'root'@'47.104.1.31' IDENTIFIED BY '1' WITH GRANT OPTION;
update mysql.user set password='' where host='47.104.1.31';
flush privileges;