mysql远程授权
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123.com' WITH GRANT OPTION;
flush privileges;
显示所有数据库
show databases
选定数据库
use database_name
查看所有表
show tables
查看表中内容
select * from table_name
mysql远程授权
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123.com' WITH GRANT OPTION;
flush privileges;
显示所有数据库
show databases
选定数据库
use database_name
查看所有表
show tables
查看表中内容
select * from table_name