创建新网站前数据库的操作
创建新网站前必须制作专门用于这个网站的数据库:
1. 用root账号登录:mysql -u root -pPassword
2. create database dbname;
3. grant all privileges on dbname.* to dbuser@localhost identified by 'password';
4. 创建用户:create user 'username'@'localhost' identified by 'password';
删除数据库: drop database xxx;
删除用户: DROP USER 'jack'@'localhost';
查看用户: SELECT User, Host, Password FROM mysql.user;