Linux下MYSQL无法启动问题

来源：互联网发布：apache ii score 编辑：程序博客网时间：2024/06/04 19:19

当MYSQL出现一下情况无法启动时：

[root@mail falcon]# mysql -uroot -p
Enter password:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

[root@mail falcon]# /usr/sbin/mysqld
080416 8:17:30 [ERROR] Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!

080416 8:17:30 [ERROR] Aborting

080416 8:17:30 [Note] /usr/sbin/mysqld: Shutdown complete

解决方法：

[root@mail falcon]# su mysql
bash-2.05b$ /usr/sbin/mysqld
080416 8:22:22 InnoDB: Started; log sequence number 0 43922
080416 8:22:22 [Warning] mysql.user table is not updated to new password format; Disabling new password usage until mysql_fix_privilege_tables is run
/usr/sbin/mysqld: ready for connections.
Version: '4.1.15-standard' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition - Standard (GPL)

MYSQL启动成功

[root@mail falcon]# mysql -uroot -p123456
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 4.1.15-standard

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>

忘记MYSQL密码解决方法：

#killall mysqld

＃/usr/bin/safe_mysqld --skip-grant-tables

#mysql

mysql>