本文介绍了如何在MySQL中创建新用户并为其分配权限。首先，通过MySQL Command Line Client以root用户身份验证，然后进入MySQL Server的bin目录登录。接着，使用SQL命令创建新用户并设置密码，最后为新用户指定数据库权限。
用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. Commands end with ; or \g.
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)
1530
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
