当我的WordPress服务器开始抛出MySQL错误时,我注意到了这个问题。为了尝试调试WordPress,我尝试手动连接。
我得到了以下信息:
我得到了以下信息:
$ mysql -u root -p -h localhost -P 3306
Enter password:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/opt/bitnami/mysql/tmp/mysql.sock' (2)
我也尝试了不加-h选项和127.0.0.1。
看起来MySQL正在运行。
$ ps -ef | grep mysql
mysql 14743 1 0 15:20 ? 00:00:00 /usr/sbin/mysqld
bitnami 14939 13882 0 15:28 pts/0 00:00:00 grep --color=auto
已安装mysql-server,但是/opt/bitnami/mysql/tmp/mysql.sock
不存在。
看起来MySQL正在监听正确的端口。
$ telnet 127.0.0.1 3306
Trying 127.0.0.1...
Connected to 127.0.0.1.
Escape character is '^]'.
[
5.5.54-0ubuntu0.14.04.1,IIq{;Rh�k>5/)"m"[&J#mysql_native_password
!#08S01Got packets out of orderConnection closed by foreign host.
$ sudo /opt/bitnami/ctlscript.sh status
php-fpm already running
apache already running
mysql not running
$ sudo /opt/bitnami/ctlscript.sh start mysql
2017-02-14T16:53:25.064586Z mysqld_safe Logging to '/opt/bitnami/mysql/data/mysqld.log'.
2017-02-14T16:53:25.233250Z mysqld_safe Starting mysqld.bin daemon with databases from /opt/bitnami/mysql/data
2017-02-14T16:53:28.400598Z mysqld_safe mysqld from pid file /opt/bitnami/mysql/data/mysqld.pid ended
/opt/bitnami/mysql/scripts/ctl.sh : mysql could not be started
Monitored mysql
以下是来自 /opt/bitnami/mysql/data/mysqld.log 的几行精选内容。看起来存在冲突。
2017-02-14T17:03:31.274720Z 0 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
2017-02-14T17:03:31.274778Z 0 [Note] - '127.0.0.1' resolves to '127.0.0.1';
2017-02-14T17:03:31.274835Z 0 [Note] Server socket created on IP: '127.0.0.1'.
2017-02-14T17:03:31.274888Z 0 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use
2017-02-14T17:03:31.274901Z 0 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2017-02-14T17:03:31.274952Z 0 [ERROR] Aborting
sudo find / -name mysql.sock
它在哪里? - aynber/opt/bitnami/mysql/data/mysqld.log
中有没有任何提示? - aynbersudo find / -name mysql.sock
没有结果,日志信息已添加到主帖中。 - Jonessudo service mysql stop
,或杀死进程sudo kill 14743
。然后再次运行脚本。 - aynbersudo service mysql stop
和sudo /opt/bitnami/ctlscript.sh start mysql
让它重新工作了。 - Jones