修改了一下mariadb的参数，重启mariadb一直不返回

Hmily

修改了一下mariadb的参数，重启mariadb一直不返回，不知道啥原因，其实mariadb已经启动起来了，就是命令里没有返回，看mariadb日志也是正常的，军哥啥原因？

licess

你看看mariadb的日志有什么信息

Hmily

看了日志的，没有任何异常信息


141030 18:55:48 [Note] /usr/local/mariadb/bin/mysqld: Normal shutdown

141030 18:55:48 [Note] Event Scheduler: Purging the queue. 0 events
141030 18:55:48 [Note] /usr/local/mariadb/bin/mysqld: Shutdown complete

141030 18:55:49 mysqld_safe mysqld from pid file /usr/local/mariadb/var/mariadb.pid ended
141030 18:55:51 mysqld_safe Starting mysqld daemon with databases from /usr/local/mariadb/var
141030 18:55:52 [Note] Plugin 'InnoDB' is disabled.
141030 18:55:52 [Note] Server socket created on IP: '0.0.0.0'.
141030 18:55:52 [Note] Event Scheduler: Loaded 0 events
141030 18:55:52 [Note] /usr/local/mariadb/bin/mysqld: ready for connections.
Version: '5.5.40-MariaDB-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
141030 20:15:31 mysqld_safe A mysqld process already exists
141030 20:15:35 mysqld_safe A mysqld process already exists
141030 20:15:40 [Note] /usr/local/mariadb/bin/mysqld: Normal shutdown

141030 20:15:40 [Note] Event Scheduler: Purging the queue. 0 events
141030 20:15:40 [Note] /usr/local/mariadb/bin/mysqld: Shutdown complete

141030 20:15:40 mysqld_safe mysqld from pid file /usr/local/mariadb/var/mariadb.pid ended
141030 20:15:41 mysqld_safe Starting mysqld daemon with databases from /usr/local/mariadb/var
141030 20:15:42 [Note] Plugin 'InnoDB' is disabled.
141030 20:15:42 [Note] Server socket created on IP: '0.0.0.0'.
141030 20:15:42 [Note] Event Scheduler: Loaded 0 events
141030 20:15:42 [Note] /usr/local/mariadb/bin/mysqld: ready for connections.
Version: '5.5.40-MariaDB-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution

licess

可能是个别系统下的兼容问题

Hmily

之前没改参数的时候没问题，调整了下my.ini的参数就出问题了，这个能怎么排查不？

licess

改的什么参数？
什么版本，在什么系统下

Hmily

改了很多也不记得了，我把配置放其他机器也没问题，这机器之前没问题，我改动了一些参数就不行了。

Hmily

系统是centos，mariadb版本号是5.5.40

Hmily

看起来不是配置文件的问题，升级到5.5.41后默认配置也不行，@licess 难道是其他什么地方文件被我改了导致的？我设置mariadb只能127.0.0.1链接，这个有关系不？

licess

可以看一下/etc/hosts 里是否有127.0.0.1   localhost

Hmily

hosts里是有的，还有可能和什么有关系了，太奇怪了。

licess

1、mysql里权限设置问题，可以登陆phpmyadmin里权限看你使用的用户是否有localhost
2、php.ini里几个
mysql.default_socket = /tmp/mysql.sock
mysqli.default_socket = /tmp/mysql.sock
pdo_mysql.default_socket = /tmp/mysql.sock

Hmily

1、登陆phpmyadmin里几个用户权限都有localhost。




2、php.ini里的那几个地址都是空，我没写。

[ 本帖最后由 Hmily 于 2014-12-24 14:35 编辑 ]

licess

2是让你写上试试

Hmily

恩，写上了重启php和mariadb还是不行，没有返回，这个能知道是哪条命令没返回不？