MySQL Study Case--mysql Client connection failure
System Environment :
Operating system: RedHat EL6
DB Soft:mysql 5.6.4-M7
The system installed the source package MySQL 5.6.4-M7 version, after starting the service, the client connection failed!
[[EMAIL PROTECTED] ~]# CD /USR/LOCAL/MYSQL/[[EMAIL PROTECTED] MYSQL]# CD bin[[email protected] bin]# ./mysql -u root -pEnter password: error 2002 (HY000): can ' T connect to local mysql server through socket '/tmp/mysql.sock ' (13)--Connection server failed [[Email protected] bin]# mysql -u root -pEnter password: Welcome to the MySQL monitor. commands end with ; or \g.your mysql connection id is 2server version: 5.1.66 source distributioncopyright (c) 2000, 2012, Oracle and/or its affiliates. all rights reserved. oracle is a registered trademark of oracle corporation and/or Itsaffiliates. other names may be traDemarks of their respectiveowners. type ' help; ' or ' \h ' for help. Type ' \c ' to clear the current input statement.mysql>
--connected to the 5.1.66 version of the system itself
Workaround:
View the configuration file and modify
[Email protected] bin]# cat/etc/my.cnf[mysqld]datadir=/var/lib/mysqlsocket=/var/lib/mysql/mysql.sockuser=mysql# Disabling symbolic-links is recommended to prevent assorted security riskssymbolic-links=0[mysqld_safe]log-error=/var/ Log/mysqld.logpid-file=/var/run/mysqld/mysqld.pid changing the socket parameter: [[email protected] bin]# Vi/etc/my.cnf[mysqld]datadir =/var/lib/mysqlsocket=/tmp/mysql.sock#socket=/var/lib/mysql/mysql.sockuser=mysql# Disabling Symbolic-links is Recommended to prevent assorted security riskssymbolic-links=0[mysqld_safe]log-error=/var/log/mysqld.logpid-file=/ var/run/mysqld/mysqld.pid~
Verify:
Stop the MYSQLD process:[[email protected] bin]# ps -ef |grep mysqlroot 4482 4456 0 12:27 pts/3 00:00:00 /bin/sh /usr/bin/mysqld_safe --user=mysqlmysql 4553 4482 0 12:27 pts/3 00:00:00 /usr/libexec/mysqld -- basedir=/usr --datadir=/var/lib/mysql --user=mysql --log-error=/var/log/mysqld.log -- pid-file=/var/run/mysqld/mysqld.pid --socket=/var/lib/mysql/mysql.sockroot 4590 4456 1 12:29 pts/3 00:00:00 grep mysql[[email protected] bin]# pkill mysql[[email protected] bin]# ps - ef |grep mysql150206 12:30:03 mysqld_safe mysqld from pid file / Var/run/mysqld/mysqld.pid endedroot 4597 4456 0 12:30 pts/3 00:00:00 grep mysql[1]+ Done mysqld_safe --user=mysql (wd: ~) (Wd now: /usr/local/mysql/bin) [[Email protected] bin]# ps -ef |grep mysqlroot 4599 4456 0 12:30 pts/3 00:00:00 grep mysql restarting the MYSQLD process: [[Email protected] bin] # ./mysqld_safe &[1] 4602[[email protected] bin]# 150206 12:30:17 mysqld_safe logging to '/var/log/mysqld.log ' .150206 12:30:18 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql Client Connection Successful:[[email protected] bin]# ./mYsql -u root -penter password: welcome to the mysql monitor. commands end with ; or \g.your mysql connection id is 1Server version: 5.6.4-m7 Source distributionCopyright (c) 2000, 2011 , oracle and/or its affiliates. all rights reserved. oracle is a registered trademark of oracle corporation and/or Itsaffiliates. other names may be trademarks of their respectiveowners . type ' help; ' or ' \h ' for help. Type ' \c ' to clear the current input statement.mysql>mysql> status--------------./mysql ver 14.14 distrib 5.6.4-m7, for Linux (x86_64) using EditLine wrapperConnection id: 3current database:current user: [email protected]SSL: not in usecurrent pager : stdoutusing outfile: ' using delimiter: ; server version: 5.6.4-m7 source distributionprotocol version: 10connection: localhost via unix socketserver characterset: latin1Db characterset: latin1client charactErset: utf8conn. characterset: utf8unix socket: /tmp/mysql.sockUptime: 26 min 33 secthreads: 1 questions: 6 slow queries: 0 opens: 66 flush tables: 1 open tables: 59 queries per second avg: 0.003--------------mysql>
@ so far, problem solved
This article is from the "Tianya blog," Please make sure to keep this source http://tiany.blog.51cto.com/513694/1612401
MySQL Study Case--mysql Client connection failure