当前位置：首页 -> 基础 -> 数据库编程

MySQL root密码重置报错：mysqladmin: connect to server at 'localhost' failed的解决方案(二)

2015-01-25 21:34:06 · 作者: · 浏览: 7
标签: MySQL root 密码 重置 mysqladmin: connect server ' localhost' failed 解决方案
n/mysqld/mysqld.pid' (Errcode: 28)
130830 10:59:02 [ERROR] Can't start server: can't create PID file: No space left on device
130830 10:59:02 mysqld_safe Number of processes running now: 0
130830 10:59:02 mysqld_safe mysqld restarted
130830 10:59:02 ?InnoDB: Initializing buffer pool, size = 1.0G
130830 10:59:02 ?InnoDB: Completed initialization of buffer pool
130830 10:59:02 ?InnoDB: Started; log sequence number 0 2727887496
130830 10:59:02 [ERROR] /usr/libexec/mysqld: Error writing file '/var/run/mysqld/mysqld.pid' (Errcode: 28)
130830 10:59:02 [ERROR] Can't start server: can't create PID file: No space left on device
130830 10:59:03 mysqld_safe Number of processes running now: 0
130830 10:59:03 mysqld_safe mysqld restarted
130830 10:59:03 ?InnoDB: Initializing buffer pool, size = 1.0G
?
[分析]：不能写入默认的pid文件，就 修改 /etc/init.d/mysqld，把pid指向别的路经
?
[root@app60 mysqld]# vi /etc/init.d/mysqld
.....
get_mysql_option mysqld datadir "/var/lib/mysql"
datadir="$result"
get_mysql_option mysqld socket "$datadir/mysql.sock"
socketfile="$result"
get_mysql_option mysqld_safe log-error "/var/log/mysqld.log"
errlogfile="$result"
get_mysql_option mysqld_safe pid-file "/opt/mysqldata/mysqld.pid" ? ?# '/var/run/mysqld/mysqld.pid' 原始值,这里修改成别的路径/opt/mysqldata/mysqld.pid
mypidfile="$result"
.....
然后启动mysqld服务，OK，成功了。
?