mysql日常应用语句

2、mysql查看数据库表的数量命令
SELECT count(TABLE_NAME) FROM information_schema.TABLES WHERE TABLE_SCHEMA='dbname';


1、创建数据库添加用户及权限
//创建用户
INSERT INTO mysql.user(HOST,USER,PASSWORD) VALUES("%","user_name",PASSWORD("123456"));


//刷新系统权限表
FLUSH PRIVILEGES;


//以root登陆创建数据库
CREATE DATABASE db1;


//授权用户db1数据库所有权限
GRANT ALL PRIVILEGES ON db1.* TO user_name@'%' IDENTIFIED BY '123456';


//刷新系统权限表
FLUSH PRIVILEGES;


//授权所有权限
GRANT ALL PRIVILEGES ON *.* TO user_name@'%' IDENTIFIED BY '123456';