新建站,想远程连接mysql,一直报错1045。在网上找了好多原因,更改权限之类的,仍旧报错。
突发奇想重启mysql 找到了问题所在
停止mysql
service mysqld stop
报错
>Redirecting to /bin/systemctl stop mysqld.service
>Failed to stop mysqld.service: Unit mysqld.service not loaded.
找到mysql serve文件
find / -name mysql.server
返回路径
>/usr/local/mysql/support-files/mysql.server
用路径启动
/usr/local/mysql/support-files/mysql.server start
启动成功
>Starting MySQL SUCCESS!
重新测试远程连接,连接成功!