加载中…mysql创建新用户和赋权限
(2019-01-22 15:42:24)
标签：
itmysql用户权限 |
分类： MYSQL |
mysql> create user nyytest identified by '123' ;
Query OK, 0 rows affected (0.03 sec)
mysql> select * from mysql.user where user='nyy';
（2）grant 普通数据用户，查询、插入、更新、删除 数据库中所有表数据的权利，此处只有table这个级别的权限
mysql> grant select,insert,update,delete on testdb.* to nyytest@'%';
Query OK, 0 rows affected (0.01 sec)
（3）grant
操作 MySQL
存储过程、函数
权限。
mysql> grant create routine on testdb.* to
nyytest@'%';(可以创建procedure)
Query OK, 0 rows affected (0.00 sec)
mysql> grant execute on testdb.* to nyytest@'%'; (可以执行procedure)
Query OK, 0 rows affected (0.00 sec)
（4）创建event的权限
mysql> grant event on testdb.* to nyytest@'%'
创建用户和赋权限之后需要刷新
mysql> flush privileges;
Query OK, 0 rows affected (0.03 sec)
用MySQL Command Line Client打开进去就是验证root用户密码，如果你想用新建用户登录mysql，就必须用dos进入安装mysql的目录下的bin文件下
进入bin目录：cd "..\..\Program Files (x86)\MySQL\MySQL Server 5.1\bin"
登录：C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin>mysql -u wust -p
C:\>cd C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin
C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin>mysql -u nyytest -p
Enter password: ***
Welcome to the MySQL
monitor.
Your MySQL connection id is 6
Server version: 5.1.45-community MySQL Community Server (GPL)
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
查询当前用户
mysql> select user();
+-------------------+
|
user()
+-------------------+
| nyytest@localhost |
+-------------------+
1 row in set (0.00 sec)
mysql> select database();
+------------+
| database() |
+------------+
|
NULL
+------------+
1 row in set (0.00 sec)
mysql> use testdb;
Database changed
mysql> select database();
+------------+
| database() |
+------------+
|
testdb
+------------+
1 row in set (0.00 sec)
喜欢
0
赠金笔