Lucas Liao's Blog

部署node服务遇到的问题

TODO: 待更新

mysql: https://blog.csdn.net/xuezhangjun0121/article/details/103000452

mysql: 无法启动成功,版本过低,更新版本

端口占用处理方法:

killall -9 nginx
service nginx restart

c // 查看端口占用情况
kill -9 xxx // 关闭端口

ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (111)

service mysqld start

o9L4p4yHZTBgCzZcRpiXnwSCKxpw

If your stack ships MySQL v5.7.x or MySQL v8.x, use this content:

ALTER USER ‘root‘@’localhost’ IDENTIFIED BY ‘NEW_PASSWORD’;
If your stack ships MySQL v5.6.x or earlier, use this content:

UPDATE mysql.user SET Password=PASSWORD(‘NEW_PASSWORD’) WHERE User=’root’;
FLUSH PRIVILEGES;