MYSQL语句使用记录

1，查询数据库中的非空表
USE information_schema;
SELECT table_schema,table_name,table_rows
FROM TABLES WHERE TABLE_SCHEMA='schemaname'  

AND table_rows != 0 ORDER BY table_rows DESC;

2.  赋予远程登录机器登录名

GRANT ALL PRIVILEGES ON *.* TO root@'remotehost' IDENTIFIED BY 'password' WITH GRANT OPTION;

FLUSH PRIVILEGES;
commit;