mysqld ended问题解决

来源：互联网发布：中国网络销售发展现状编辑：程序博客网时间：2024/05/08 19:26

问题表现：

suse:/home/berniewu # mysqld_safe --user=mysql start

Starting mysqld daemon with databases from /usr/local/mysql/var

STOPPING server from pid file /usr/local/mysql/var/suse.pid

081216 11:06:12 mysqld ended

问题解决：

http://www.java2000.net/p5063

Starting mysqld daemon with databases from /var/lib/mysql STOPPING server from pid file /var/run/mysqld/mysqld.pid mysqld ended

我发现并不存在/var/run/mysqld/mysqld.pid文件,于是就自己去建立一个,即:

mkdir /var/run/mysql
touch /var/run/mysqld/mysqld.pid

然后更改权限
chown -R mysql:mysql /var/run/mysqld/.

再次执行
./bin/mysqld_safe --user=mysql &

出现 [1] 27103 [root@localhost mysql]# Starting mysqld daemon with databases from /var/lib/mysql

然后用jobs查看一下为:
[1]+ Running ./bin/mysqld_safe --user=mysql &

这时mysql已经启动成功.

更改mysql的root密码:

./bin/mysqladmin -u root -p password '要改的密码'

出现PASSWORD:字样,此时直接回车就行.

执行./bin/mysql -u root -p

然后输入密码,就可以进入mysql了.