问题表现:
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
问题解决:
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了.