Shulou(Shulou.com)06/01 Report--

Start the mysql Times with the following error

[root@VM_26_56_centos data] # service mysqld startStarting MySQL.. ERROR! The server quit without updating PID file (/ usr/local/mysql/data/VM_26_56_centos.pid).

View log display

2017-03-14 15:49:28 27467 [Note] Server hostname (bind-address):'*'; port: 33062017-03-14 15:49:28 27467 [Note] IPv6 is not available.2017-03-14 15:49:28 27467 [Note]-'0.0.0.0' resolves to' 0.0.0.0' 2017-03-14 15:49:28 27467 [Note] Server socket created on IP: '0.0.0.0 Server socket created on IP. 2017-03-14 15:49:28 27467 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use2017-03-14 15:49:28 27467 [ERROR] Do you already have another mysqld server running on port: 3306? 2017-03-14 15:49:28 27467 [ERROR] Aborting

View ports and processes

[root@VM_26_56_centos data] # netstat-tulnp | grep 3306tcp 00 0.0.0.0 LISTEN 23115/mysqld [root@VM_26_56_centos data] # ps aux | grep 23115root 17317 0.0 103252 892 pts/0 S + 10:58 grep 23115mysql 23115 0.0 1.6 3337908 540464? Sl Feb22 22:20 / usr/local/mysql/bin/mysqld-- basedir=/usr/local/mysql-- datadir=/usr/local/mysql/data-- plugin-dir=/usr/local/mysql/lib/plugin-- user=mysql-- log-error=/usr/local/mysql/data/VM_26_56_centos.err-- pid-file=/usr/local/mysql/data/VM_26_56_ centos.pid [root @ VM_26_56_centos data] #

Kill drop and start again

[root@VM_26_56_centos local] # ps aux | grep 23115root 17434 0.0 103252 892 pts/0 S+ 11:00 0:00 grep 23115 [root@VM_26_56_centos local] # service mysqld startStarting MySQL. SUCCESS!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.