Mysql登录出错

konglong

使用 mysql -uroot -p 并输入密码后提示Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock
centos7

licess

ps aux|grep mysql|grep -v grep 看一下mysql是否在运行

konglong

[root@vultr ~]# ps aux|grep mysql|grep -v grep
[root@vultr ~]# /etc/init.d/mysql start
Starting MySQL.. ERROR! The server quit without updating PID file (/usr/local/mysql/var/vultr.guest.pid).
[root@vultr ~]#

licess

按反馈必读提供一一下mysql日志看看

konglong

[root@vultr var]# vim vultr.guest.err
2016-04-29 16:58:18 8938 [Note] /usr/local/mysql/bin/mysqld: Normal shutdown

2016-04-29 16:58:18 8938 [Note] Giving 0 client threads a chance to die gracefully
2016-04-29 16:58:18 8938 [Note] Event Scheduler: Purging the queue. 0 events
2016-04-29 16:58:18 8938 [Note] Shutting down slave threads
2016-04-29 16:58:18 8938 [Note] Forcefully disconnecting 0 remaining clients
2016-04-29 16:58:18 8938 [Note] Binlog end
2016-04-29 16:58:18 8938 [Note] Shutting down plugin 'partition'
2016-04-29 16:58:18 8938 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2016-04-29 16:58:18 8938 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2016-04-29 16:58:18 8938 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2016-04-29 16:58:18 8938 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2016-04-29 16:58:18 8938 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2016-04-29 16:58:18 8938 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2016-04-29 16:58:18 8938 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2016-04-29 16:58:18 8938 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2016-04-29 16:58:18 8938 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2016-04-29 16:58:18 8938 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2016-04-29 16:58:18 8938 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2016-04-29 16:58:18 8938 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2016-04-29 16:58:18 8938 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2016-04-29 16:58:18 8938 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2016-04-29 16:58:18 8938 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2016-04-29 16:58:18 8938 [Note] Shutting down plugin 'INNODB_METRICS'
2016-04-29 16:58:18 8938 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
"vultr.guest.err" 222L, 17793C                :sssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssss
2016-04-29 16:58:18 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2016-04-29 16:58:18 8938 [Note] Plugin 'FEDERATED' is disabled.
2016-04-29 16:58:18 7f550f121780 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2016-04-29 16:58:18 8938 [Note] InnoDB: Using atomics to ref count buffer pool pages
2016-04-29 16:58:18 8938 [Note] InnoDB: The InnoDB memory heap is disabled
2016-04-29 16:58:18 8938 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2016-04-29 16:58:18 8938 [Note] InnoDB: Memory barrier is not used
2016-04-29 16:58:18 8938 [Note] InnoDB: Compressed tables use zlib 1.2.7
2016-04-29 16:58:18 8938 [Note] InnoDB: Using CPU crc32 instructions
2016-04-29 16:58:18 8938 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-04-29 16:58:18 8938 [Note] InnoDB: Completed initialization of buffer pool
2016-04-29 16:58:18 8938 [Note] InnoDB: Highest supported file format is Barracuda.
2016-04-29 16:58:18 8938 [Note] InnoDB: 128 rollback segment(s) are active.
2016-04-29 16:58:18 8938 [Note] InnoDB: Waiting for purge to start
2016-04-29 16:58:18 8938 [Note] InnoDB: 5.6.23 started; log sequence number 1625994
2016-04-29 16:58:18 8938 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 84238ea9-0de8-11e6-ad8d-5600002524a0.
2016-04-29 16:58:18 8938 [Note] Server hostname (bind-address): '*'; port: 3306
2016-04-29 16:58:18 8938 [Note] IPv6 is available.
2016-04-29 16:58:18 8938 [Note]   - '::' resolves to '::';
2016-04-29 16:58:18 8938 [Note] Server socket created on IP: '::'.
2016-04-29 16:58:18 8938 [Note] Event Scheduler: Loaded 0 events
2016-04-29 16:58:18 8938 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.6.23-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution

licess

目前你提供的这仅有的日志里没有错误信息

rpm -qa|grep mysql 或 dpkg -l|grep mysql 看一下是否有其他干扰