MySql 常用命令

启动mysql服务，运行命令 net start mysql

 

停止mysql服务，运行命令 net stop mysql

 

打开控制台，运行命令 cmd

定位目录：cd /d C:\Program Files\MySQL\MySQL Server 8.0\bin

 

登录mysql：mysql -uroot -p

 

切换mysql系统库：use mysql;

 

查看mysql用户表：select user,host from user;

 

允许root用户远程连接，update user set host='%' where user='root';

 

修改root用户密码 ，ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '******';

 

刷新权限表：flush privileges;