mysqld ended问题解决

问题表现：

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了.