Mysql登录出错
使用 mysql -uroot -p 并输入密码后提示Can’t connect to local MySQL server through socket ‘/tmp/mysql.sockcentos7 ps aux|grep mysql|grep -v grep 看一下mysql是否在运行 # ps aux|grep mysql|grep -v grep
# /etc/init.d/mysql start
Starting MySQL.. ERROR! The server quit without updating PID file (/usr/local/mysql/var/vultr.guest.pid).
# 按反馈必读提供一一下mysql日志看看 # vim vultr.guest.err
2016-04-29 16:58:18 8938 /usr/local/mysql/bin/mysqld: Normal shutdown
2016-04-29 16:58:18 8938 Giving 0 client threads a chance to die gracefully
2016-04-29 16:58:18 8938 Event Scheduler: Purging the queue. 0 events
2016-04-29 16:58:18 8938 Shutting down slave threads
2016-04-29 16:58:18 8938 Forcefully disconnecting 0 remaining clients
2016-04-29 16:58:18 8938 Binlog end
2016-04-29 16:58:18 8938 Shutting down plugin 'partition'
2016-04-29 16:58:18 8938 Shutting down plugin 'INNODB_SYS_DATAFILES'
2016-04-29 16:58:18 8938 Shutting down plugin 'INNODB_SYS_TABLESPACES'
2016-04-29 16:58:18 8938 Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2016-04-29 16:58:18 8938 Shutting down plugin 'INNODB_SYS_FOREIGN'
2016-04-29 16:58:18 8938 Shutting down plugin 'INNODB_SYS_FIELDS'
2016-04-29 16:58:18 8938 Shutting down plugin 'INNODB_SYS_COLUMNS'
2016-04-29 16:58:18 8938 Shutting down plugin 'INNODB_SYS_INDEXES'
2016-04-29 16:58:18 8938 Shutting down plugin 'INNODB_SYS_TABLESTATS'
2016-04-29 16:58:18 8938 Shutting down plugin 'INNODB_SYS_TABLES'
2016-04-29 16:58:18 8938 Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2016-04-29 16:58:18 8938 Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2016-04-29 16:58:18 8938 Shutting down plugin 'INNODB_FT_CONFIG'
2016-04-29 16:58:18 8938 Shutting down plugin 'INNODB_FT_BEING_DELETED'
2016-04-29 16:58:18 8938 Shutting down plugin 'INNODB_FT_DELETED'
2016-04-29 16:58:18 8938 Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2016-04-29 16:58:18 8938 Shutting down plugin 'INNODB_METRICS'
2016-04-29 16:58:18 8938 Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
"vultr.guest.err" 222L, 17793C :sssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssss
2016-04-29 16:58:18 0 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 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 InnoDB: Using atomics to ref count buffer pool pages
2016-04-29 16:58:18 8938 InnoDB: The InnoDB memory heap is disabled
2016-04-29 16:58:18 8938 InnoDB: Mutexes and rw_locks use GCC atomic builtins
2016-04-29 16:58:18 8938 InnoDB: Memory barrier is not used
2016-04-29 16:58:18 8938 InnoDB: Compressed tables use zlib 1.2.7
2016-04-29 16:58:18 8938 InnoDB: Using CPU crc32 instructions
2016-04-29 16:58:18 8938 InnoDB: Initializing buffer pool, size = 16.0M
2016-04-29 16:58:18 8938 InnoDB: Completed initialization of buffer pool
2016-04-29 16:58:18 8938 InnoDB: Highest supported file format is Barracuda.
2016-04-29 16:58:18 8938 InnoDB: 128 rollback segment(s) are active.
2016-04-29 16:58:18 8938 InnoDB: Waiting for purge to start
2016-04-29 16:58:18 8938 InnoDB: 5.6.23 started; log sequence number 1625994
2016-04-29 16:58:18 8938 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 Server hostname (bind-address): '*'; port: 3306
2016-04-29 16:58:18 8938 IPv6 is available.
2016-04-29 16:58:18 8938 - '::' resolves to '::';
2016-04-29 16:58:18 8938 Server socket created on IP: '::'.
2016-04-29 16:58:18 8938 Event Scheduler: Loaded 0 events
2016-04-29 16:58:18 8938 /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.6.23-log'socket: '/tmp/mysql.sock'port: 3306Source distribution 目前你提供的这仅有的日志里没有错误信息
rpm -qa|grep mysql 或 dpkg -l|grep mysql 看一下是否有其他干扰
页:
[1]