1,启动mysql
net start mysql
2,进入mysql>下
mysql -uroot -p
3.停止mysql
net stop mysql
4,修改密码
mysql> set password for 用户名@localhost=password('新密码')
mysql> set password for root@localhost=password('123');
5,显示数据库
mysql>show databases;
6,使用哪个数据库
mysql>use crm
7,查看该数据库里面的所有表
mysql>show tables;
8,输入mysql>mysql -uroot -p显示
mysql' is not recognized as an internal or external command, operable program or batch file.
进入mysql的安装包的bin里面进入命令符号
eg.cd C:\BtSoft\WebSoft\mysql\MySQL5.7\bin
bin>mysql -uroot -p
9,设置密码如果是
输入命令 use mysql
select Host,User from user
将用'%'替换localhost
mysql>set password for 'root'@'%'=password('123456');