mysql创建用户、授权使用数据库、删除用户之各两种方法解决
使用root登陆mysql；创建用户并授权使用数据库方法一
mysql> use mysqlDatabase changedmysql> insert into user(Host,User,Password) values("localhost","little_bill",password("1234"));Query OK, 1 row affected, 3 warnings (0.00 sec)mysql> flush privileges;Query OK, 0 rows affected (0.00 sec)mysql> exitByeE:\>mysql -u root -pEnter password: Welcome to the MySQL monitor.Commands end with ; or \g.Your MySQL connection id is 8Server version: 5.1.41-community MySQL Community Server (GPL)Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.mysql> create database little_billDB;Query OK, 1 row affected (0.03 sec)mysql> grant all privileges on little_billDB.* to little_bill@localhost identified by '1234';Query OK, 0 rows affected (0.00 sec)mysql> flush privileges;Query OK, 0 rows affected (0.00 sec)mysql> exitBye
删除用户方法一
mysql> use mysqlDatabase changedmysql> DELETE FROM user WHERE User="little_bill" and Host="%";Query OK, 1 row affected (0.00 sec)mysql> flush privileges;Query OK, 0 rows affected (0.00 sec)mysql> exitBye
创建用户并授权使用数据库方法二
使用root账户登录
mysql> CREATE USER 'little_bill'@'%' IDENTIFIED BY'123456';Query OK, 0 rows affected (0.00 sec)mysql> CREATE DATABASE IF NOT EXISTS`little_billDB`;Query OK, 1 row affected (0.00 sec)mysql> GRANT ALL PRIVILEGES ON`little_billDB` . * TO'little_bill'@'%';Query OK, 0 rows affected (0.00 sec)mysql> flush privileges;Query OK, 0 rows affected (0.00 sec)mysql> exitBye
删除用户方法二
mysql> drop user 'little_bill'@'%';Query OK, 0 rows affected (0.00 sec)mysql> flush privileges;Query OK, 0 rows affected (0.00 sec)
页:
[1]