源码安装的MySQL强制关闭后起不来，解决

我强制关掉mysqld进程后，起不来，修改my.cnf文件后就OK了：

安装是按照http://forrest-lv.iteye.com/admin/blogs/2260703 安装的

之前的启动都是ok，/etc/my.cnf配置没影响到，但是强制关闭后，就受到/etc/my.cnf影响了

 

查看/var/log/mysqld.log文件，是说 mysqld.pid 找不到，但是又怀疑是“创建了mysqld.pid，中间出问题，然后删掉mysqld.pid了，再去找mysqld.pid” 。

但是经过下面修改，就ok了。。

[root@centos65 ~]# cat /etc/my.cnf

[mysqld]

datadir=/opt/softwares/mysql_5_7_9/data

socket=/var/lib/mysql.sock

user=laolv

# Disabling symbolic-links is recommended to prevent assorted security risks

symbolic-links=0

 

[mysqld_safe]

datadir=/opt/softwares/mysql_5_7_9/data

socket=/var/lib/mysql.sock

user=laolv

log-error=/var/log/mysqld.log

#pid-file=/var/run/mysqld/mysqld.pid 注意注释掉pid-file很重要

 

[laolv@centos65 mysql_5_7_9]$ pwd

/opt/softwares/mysql_5_7_9

[laolv@centos65 mysql_5_7_9]$ bin/mysqld_safe --user=laolv

160112 16:16:12 mysqld_safe Logging to '/var/log/mysqld.log'.

160112 16:16:12 mysqld_safe Starting mysqld daemon with databases from /opt/softwares/mysql_5_7_9/data

 

[laolv@centos65 mysql_5_7_9]$ lsof -i:3306

COMMAND   PID  USER   FD   TYPE DEVICE SIZE/OFF NODE NAME

mysqld  10432 laolv   16u  IPv6  44725      0t0  TCP *:mysql (LISTEN)

[laolv@centos65 mysql_5_7_9]$ ps -ef | grep -i 10432

laolv    10432 10253  0 16:16 pts/1    00:00:00 /opt/softwares/mysql_5_7_9/bin/mysqld --basedir=/opt/softwares/mysql_5_7_9 --datadir=/opt/softwares/mysql_5_7_9/data --plugin-dir=/opt/softwares/mysql_5_7_9/lib/plugin --user=laolv --log-error=/var/log/mysqld.log --pid-file=/opt/softwares/mysql_5_7_9/data/centos65.pid --socket=/var/lib/mysql.sock

laolv    10704  3259  0 16:18 pts/0    00:00:00 grep -i 10432

 

另外关闭数据库，和登录需要手动指定socket=/var/lib/mysql.sock文件

[laolv@centos65 mysql_5_7_9]$ cat mylogin.sh 

mysql -uroot -p --socket=/var/lib/mysql.sock

[laolv@centos65 mysql_5_7_9]$ cat myshutdown.sh 

bin/mysqladmin -uroot -p shutdown --socket=/var/lib/mysql.sock

 

登录测试

[laolv@centos65 mysql_5_7_9]$ ./mylogin.sh 

mysql: [Warning] Using a password on the command line interface can be insecure.

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 2

Server version: 5.7.9 MySQL Community Server (GPL)

 

Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.

 

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

 

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

 

mysql> show databases;

+--------------------+

| Database           |

+--------------------+

| information_schema |

| db1                |

| hivemeta           |