启动mysql时显示：/tmp/mysql.sock 不存在的解决方法
启动mysql时报错的解决(mysql 5.0.45 redhat as43) =========================================================== 启动mysql时报错的解决(mysql 5.0.45 redhat as 43) 作者: lawzjf(http://lawzjf.itpub.net) 发表于: 2008.01.13 01:29 分类: 小企鹅 出处: http://lawzjf.itpub.net/post/417/451262 --------------------------------------------------------------- 启动mysql时报错：
Starting mysqld daemon with databases from/var/lib/mysql STOPPING server from pid file /var/run/mysqld/mysqld.pid 071112 00:22:06 mysqld ended 查看日志： ＃less /var/log/mysqld.log 其中有一段如下：
071112 0:22:06 [ERROR] /usr/local/mysql/bin/mysqld: Can'tcreate/write to file '/var/run/mysqld/mysqld.pid' (Errcode:2) 071112 0:22:06 [ERROR] Can't start server: can't create PIDfile: No such file or directory 071112 00:22:06 mysqld ended #cd /var/run/ #ls
mysqld目录不存在，创建它：
#mkdir /var/run/mysqld #cd /var/run/mysqld
创建文件mysqld.pid：
#touch mysqld.pid #cd.. #chown -R mysql mysqld . #cd /usr/local/mysql/ #bin/mysqld_safe --user=mysql & nohup: ignoring input and redirecting stderr to stdout Starting mysqld daemon with databases from/var/lib/mysql 能正常启动 #bin/mysqladmin -u root password root 又出错 [root@localhost mysql]# bin/mysqladmin -u root passwordroot bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket'/tmp/mysql.sock' (2)' Check that mysqld is running and that the socket:'/tmp/mysql.sock' exists! [root@localhost mysql]# bin/mysql -u root -p Enter password: ERROR 2002 (HY000): Can't connect to local MySQL serverthrough socket '/tmp/mysql.sock' (2) 分析：是/tmp/mysql.sock 不存在
# cd /var/lib/mysql/ 由于mysql 默认的mysql.sock是在/var/lib/mysql/mysql.sock，创建符号连接：
# ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock # bin/mysql -u root Welcome to the MySQL monitor. Commands end with ; or g. Your MySQL connection id is 1 Server version: 5.0.45 MySQL Community Server (GPL) Type 'help;' or 'h' for help. Type 'c' to clear thebuffer. mysql> 修改root 密码
#cd /usr/local/mysql/ #bin/mysqladmin -u root -p password yourpassword 一切ok。