MySQL Study Case--mysql Client connection failure

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