目录

Win7怎么通过任务管理器查看进程PID标识符

MySQL安装时出现端口异常，提示The specified port already in use

mysql error:Access denied for user 'root'@'localhost' (using password: YES)

Win7怎么通过任务管理器查看进程PID标识符

MySQL安装时出现端口异常，提示The specified port already in use

netstat -aon

任务管理器找到相应的3306的pid 直接杀死；

mysql error:Access denied for user 'root'@'localhost' (using password: YES)

ALTER USER 'root'@'localhost' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER; #修改加密规则

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password'; #更新一下用户的密码

3. 刷新权限并重置密码

FLUSH PRIVILEGES; #刷新权限

再重置下密码：alter user 'root'@'localhost' identified by '111111';

现在再次打开Navicat Premium 12连接MySQL问题数据库就会发现可以连接成功了

Win7怎么通过任务管理器查看进程PID标识符MySQL安装时出现端口异常 提示The specified port already in usemysql error:Access deni