Linux中数据库操作

mysql -uroot -p

use mysql;

show databases;

use datebase;

show tables;

select user,host from user;

update user set host = '%' where user = 'root' and host = '127.0.0.1';

flush privileges;

update user set host = '127.0.0.1' where user = 'root' and host = '%';

exit;