1.进入MySQL的bin目录下
C:\Users\Chris> cd "c:\Program Files\MySQL\MySQL Server 5.5\bin"
2.使用mysql.exe命令使用数据库
c:\Program Files\MySQL\MySQL Server 5.5\bin> mysql.exe
3.使用show databases; 命令显示数据库 发现缺少MySQL库
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
+--------------------+
1 row in set (0.00 sec)
4.使用create database new;新增数据库new失败,原因应该是localhost用户权限不够 应该使用root用户
mysql> create database new;
ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'new'
5.退出当前用户
mysql> exit
Bye
c:\Program Files\MySQL\MySQL Server 5.5\bin>
6.切换到root用户
c:\Program Files\MySQL\MySQL Server 5.5\bin> mysql -u root -p
Enter password: sd3500135
7.重复步骤3
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| one |
| performance_schema |
+--------------------+
4 rows in set (0.00 sec)
切换用户成功
至此可以直接使用CMD命令行对MySQL进行操作
C:\Users\Chris> cd "c:\Program Files\MySQL\MySQL Server 5.5\bin"
2.使用mysql.exe命令使用数据库
c:\Program Files\MySQL\MySQL Server 5.5\bin> mysql.exe
3.使用show databases; 命令显示数据库 发现缺少MySQL库
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
+--------------------+
1 row in set (0.00 sec)
4.使用create database new;新增数据库new失败,原因应该是localhost用户权限不够 应该使用root用户
mysql> create database new;
ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'new'
5.退出当前用户
mysql> exit
Bye
c:\Program Files\MySQL\MySQL Server 5.5\bin>
6.切换到root用户
c:\Program Files\MySQL\MySQL Server 5.5\bin> mysql -u root -p
Enter password: sd3500135
7.重复步骤3
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| one |
| performance_schema |
+--------------------+
4 rows in set (0.00 sec)
切换用户成功
至此可以直接使用CMD命令行对MySQL进行操作