使用rpm安装mysql后无法启动问题

丶wandy 发布于 2017/11/14 16:48
阅读 720
收藏 0

在vps上安装mysql5.6:

之前的下载,安装都没问题,在启动mysql服务的时候,报了这个错

 [root@localhost ~]# service mysqld start
Starting MySQL.Logging to '/usr/local/mysql/data/localhost.localdomain.err'.
./usr/local/mysql/bin/mysqld_safe: line 183:  1343 Killed                  

nohup  /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql

--datadir=/usr/local/mysql/data --plugin-dir=/usr/local/mysql/lib/plugin

--user=mysql

--log-error=localhost.localdomain.err

--pid-file=/usr/local/mysql/data/localhost.localdomain.pid --socket=/var/lib/mysql/mysql.sock --port=3306 < /dev/null > /dev/null 2>&1
 ERROR! The server quit without updating PID file (/usr/local/mysql/data/localhost.localdomain.pid).

我的配置my.cnf配置文件如下:

[client]
port = 3306  
socket = /var/lib/mysql/mysql.sock

[mysql]
no-auto-rehash

[mysqld]
user = mysql  
port = 3306  
socket = /var/lib/mysql/mysql.sock  
basedir = /usr
datadir = /data/mysql/db/
innodb_buffer_pool_size = 100M 
character-set-server=utf8
collation-server = utf8_general_ci
default-storage-engine = INNODB

[mysqld_safe]
log-error=/data/mysql/mysqlerror.err  
pid-file=/data/mysql/mysqld.pid

试了各种方法都没成功,有懂的人请指教下。

加载中
返回顶部
顶部