[root@myblogserver mysql]# mysql -u root -p
Enter password:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/opt/mysqldata/mysql/mysql.sock' (2)
[root@myblogserver mysql]# ps -a|grep mysql
[root@myblogserver mysql]# ps -ef|grep mysql
root 3679 1 0 09:51 ? 00:00:00 /bin/sh /usr/bin/mysqld_safe --datadir=/opt/mysqldata/mysql --pid-file=/opt/mysqldata/mysql/myblogserver.pid
mysql 3932 3679 0 09:51 ? 00:00:00 /usr/sbin/mysqld --basedir=/usr --datadir=/opt/mysqldata/mysql --plugin-dir=/usr/lib/mysql/plugin --user=mysql --log-error=/opt/mysqldata/mysql/myblogserver.err --pid-file=/opt/mysqldata/mysql/myblogserver.pid --socket=/opt/mysqldata/mysql/mysql.sock --port=3306
root 8550 4822 0 10:32 pts/1 00:00:00 grep mysql
[root@myblogserver mysql]# kill -9 3932
[root@myblogserver mysql]# ps -ef|grep mysql
root 8567 4822 0 10:32 pts/1 00:00:00 grep mysql
[root@myblogserver mysql]#
[root@myblogserver mysql]#
[root@myblogserver mysql]#
[root@myblogserver mysql]#
[root@myblogserver mysql]#
[root@myblogserver mysql]#
[root@myblogserver mysql]#
[root@myblogserver mysql]# /etc/init.d/mysql start
Starting MySQL......[确定]
[root@myblogserver mysql]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.5.8-enterprise-commercial-advanced-log MySQL Enterprise Server - Advanced Edition (Commercial)
Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>
Enter password:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/opt/mysqldata/mysql/mysql.sock' (2)
[root@myblogserver mysql]# ps -a|grep mysql
[root@myblogserver mysql]# ps -ef|grep mysql
root 3679 1 0 09:51 ? 00:00:00 /bin/sh /usr/bin/mysqld_safe --datadir=/opt/mysqldata/mysql --pid-file=/opt/mysqldata/mysql/myblogserver.pid
mysql 3932 3679 0 09:51 ? 00:00:00 /usr/sbin/mysqld --basedir=/usr --datadir=/opt/mysqldata/mysql --plugin-dir=/usr/lib/mysql/plugin --user=mysql --log-error=/opt/mysqldata/mysql/myblogserver.err --pid-file=/opt/mysqldata/mysql/myblogserver.pid --socket=/opt/mysqldata/mysql/mysql.sock --port=3306
root 8550 4822 0 10:32 pts/1 00:00:00 grep mysql
[root@myblogserver mysql]# kill -9 3932
[root@myblogserver mysql]# ps -ef|grep mysql
root 8567 4822 0 10:32 pts/1 00:00:00 grep mysql
[root@myblogserver mysql]#
[root@myblogserver mysql]#
[root@myblogserver mysql]#
[root@myblogserver mysql]#
[root@myblogserver mysql]#
[root@myblogserver mysql]#
[root@myblogserver mysql]#
[root@myblogserver mysql]# /etc/init.d/mysql start
Starting MySQL......[确定]
[root@myblogserver mysql]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.5.8-enterprise-commercial-advanced-log MySQL Enterprise Server - Advanced Edition (Commercial)
Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>
转载于:https://blog.51cto.com/marvelyu/574457