常用操作:
show databases; 查看数据库
create database name; 创建数据库
use databasename; 选择数据库
drop database name; 直接删除数据库,不提醒
show tables; 显示表
mysql -u root -p 登录
mysql给用户授权:
1. GRANT ALL PRIVILEGES ON . TO ‘root’@‘localhost’ IDENTIFIED BY ‘mypassword’ WITH GRANT OPTION;
2. FLUSH PRIVILEGES;