大家好,我刚学MYSQL ,在Red Hat Enterprise Linux AS release 4 安装了
MYSQL 5.1 ,安装用户是 root , 启动的时候出现以下问题:
1. 用 service mysql start 报错如下:
Starting MySQL..Manager of pid-file quit without updating f[FAILED]
ERROR文件的信息如下:
090513 10:18:00 [ERROR] Can't start server : Bind on unix socket: Permission denied
090513 10:18:00 [ERROR] Do you already have another mysqld server running on socket: /var/lib/mysql/mysql.sock ?
090513 10:18:00 [ERROR] Aborting
090513 10:18:01 mysqld_safe mysqld from pid file /var/lib/mysql/vmrehl4n3.pid ended
关于 Do you already have another mysqld server running on socket: /var/lib/mysql/mysql.sock ?
ps -ef|grep mysql 确认没有mysql进程在跑
2.用 mysqld_safe --user=root & 启动正常,也没有报错
[root@vmrehl4n3 mysql]# mysqld_safe --user=root &
[1] 3369
[root@vmrehl4n3 mysql]# 090513 10:23:07 mysqld_safe Logging to '/var/lib/mysql/vmrehl4n3.err'.
090513 10:23:07 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
[root@vmrehl4n3 mysql]# mysql -u root
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.1.34-community MySQL Community Server (GPL)
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| test |
+--------------------+
3 rows in set (0.00 sec)