MySQL 只在安全模式下启动

Question

看来MySQL实例仅在我发出skip-grant-tables时才启动，当我以正常方式启动它时，service mysql start 我收到无法连接到套接字的消息。

我见过很多解决方案，但没有任何效果。

[client] 
port = 3306 
socket = /var/run/mysqld/mysqld.sock 

[mysqld_safe] 
socket = /var/run/mysqld/mysqld.sock nice = 0

[mysqld] 
user = mysql 
pid-file = /var/run/mysqld/mysqld.pid 
socket = /var/run/mysqld/mysqld.sock 
port = 3306 
basedir = /usr 
datadir = /var/lib/mysql 
tmpdir = /tmp 
lc-messages-dir = /usr/share/mysql 
skip-external-locking 
bind-address = 127.0.0.1 
key_buffer = 16M 
max_allowed_packet = 16M 

<小时/>

/var/run/mysqld# ls -atlr 
total 0 
drwxr-xr-x 22 root root 720 Oct 14 01:05 ..
drwxr-xr-x 2 mysql mysql 40 Oct 14 02:33 .

Answer 1

克服的步骤

1. 转到 MySQL Workbench 下的编辑->首选项菜单。
2. 取消选中“安全更新”。
3. 重新启动 WorkBench。

附截图Screenshot from MySQL Workbench .