mysql服务无法启动:地址已在使用中
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了mysql服务无法启动:地址已在使用中,小编现在分享给大家,供广大互联网技能从业者学习和参考。文章包含5325字,纯文字阅读大概需要8分钟。
内容图文
![mysql服务无法启动:地址已在使用中](/upload/InfoBanner/zyjiaocheng/895/607aaaf6e4eb4e5c8e85f53f24fe059b.jpg)
我尝试在ubuntu上安装mysql-5.5.29源代码.
每次我重新启动或启动服务时,都会告诉我MySQL守护程序无法启动..
shell>>service mysql.server start
Starting MySQL
... * The server quit without updating PID file (/usr/local/mysql/data/ytl-HP-Pavilion- g4-Notebook-PC.pid).
shell>>less /usr/local/mysql/data/ytl-HP-Pavilion-g4-Notebook-PC.err
130106 12:20:27 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data
130106 12:20:27 InnoDB: The InnoDB memory heap is disabled
130106 12:20:27 InnoDB: Mutexes and rw_locks use GCC atomic builtins
130106 12:20:27 InnoDB: Compressed tables use zlib 1.2.7
130106 12:20:27 InnoDB: Using Linux native AIO
130106 12:20:27 InnoDB: Initializing buffer pool, size = 128.0M
130106 12:20:27 InnoDB: Completed initialization of buffer pool
130106 12:20:27 InnoDB: highest supported file format is Barracuda.
130106 12:20:27 InnoDB: Waiting for the background threads to start
130106 12:20:28 InnoDB: 1.1.8 started; log sequence number 1595675
130106 12:20:28 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
130106 12:20:28 [Note] - '0.0.0.0' resolves to '0.0.0.0';
130106 12:20:28 [Note] Server socket created on IP: '0.0.0.0'.
130106 12:20:28 [ERROR] Can't start server : Bind on unix socket: Address already in use
130106 12:20:28 [ERROR] Do you already have another mysqld server running on socket: /var/lib/mysql ?
130106 12:20:28 [ERROR] Aborting
130106 12:20:28 InnoDB: Starting shutdown...
130106 12:20:29 InnoDB: Shutdown completed; log sequence number 1595675
130106 12:20:29 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete
130106 12:20:29 mysqld_safe mysqld from pid file /usr/local/mysql/data/ytl-HP-Pavilion-g4-Notebook-PC.pid ended
shell>>ps aux |grep mysql
root 4884 0.0 0.0 5832 836 pts/1 S+ 12:27 0:00 grep --color=auto mysql
shell>ll /usr/local/mysql
drwxr-xr-x 13 root mysql 4096 1月 5 14:54 ./
drwxr-xr-x 13 root root 4096 1月 5 14:54 ../
drwxr-xr-x 2 root mysql 4096 1月 5 14:54 bin/
-rw-r--r-- 1 root mysql 17987 12月 10 14:16 COPYING
drwxr-xr-x 5 mysql mysql 4096 1月 6 12:23 data/
drwxr-xr-x 2 root mysql 4096 1月 5 14:54 docs/
drwxr-xr-x 3 root mysql 4096 1月 5 14:54 include/
-rw-r--r-- 1 root mysql 7605 12月 10 14:16 INSTALL-BINARY
drwxr-xr-x 3 root mysql 4096 1月 5 14:54 lib/
drwxr-xr-x 4 root mysql 4096 1月 5 14:54 man/
drwxr-xr-x 10 root mysql 4096 1月 5 14:54 mysql-test/
-rw-r--r-- 1 root mysql 2552 12月 10 14:16 README
drwxr-xr-x 2 root mysql 4096 1月 5 14:54 scripts/
drwxr-xr-x 27 root mysql 4096 1月 5 14:54 share/
drwxr-xr-x 4 root mysql 4096 1月 5 14:54 sql-bench/
drwxr-xr-x 2 root mysql 4096 1月 5 14:54 support-files/
在昨天安装mysql的时候,我用的是:
cmake . -DCMAKE_INSTALL_PREFIX="/usr/local/mysql" \
-DMYSQL_UNIX_ADDR=/var/lib/mysql
但是当我使用时,我发现/ var / lib / mysql是空的:
shell>> ll /var/lib/mysql
drwxr-xr-x 2 root root 4096 1月 2 23:38 ./
drwxr-xr-x 65 root root 4096 1月 2 23:38 ../
似乎3306插座没有使用
shell>>netstat -na | grep LISTEN
tcp 0 0 127.0.0.1:631 0.0.0.0:* LISTEN
tcp 0 0 127.0.1.1:53 0.0.0.0:* LISTEN
tcp6 0 0 ::1:631 :::* LISTEN
unix 2 [ ACC ] 流 LISTENING 14474 @/tmp/.ICE-unix/1685
unix 2 [ ACC ] 流 LISTENING 14475 /tmp/.ICE-unix/1685
unix 2 [ ACC ] 流 LISTENING 14449 /tmp/ssh- KTntrIp1gXrU/agent.1685
unix 2 [ ACC ] 流 LISTENING 2030 /tmp/.X11-unix/X0
unix 2 [ ACC ] 流 LISTENING 14142 /tmp/.com.google.Chrome.faNSdW/SingletonSocket
unix 2 [ ACC ] 流 LISTENING 13570 /run/user/ytlreal/keyring-cuLMzX/ssh
unix 2 [ ACC ] 流 LISTENING 14533 /tmp/pulse-dTohrWydajmn/native
unix 2 [ ACC ] 流 LISTENING 13581 /run/user/ytlreal/keyring-cuLMzX/pkcs11
unix 2 [ ACC ] 流 LISTENING 13583 /run/user/ytlreal/keyring-cuLMzX/gpg
unix 2 [ ACC ] 流 LISTENING 18200 /var/run/cups/cups.sock
unix 2 [ ACC ] 流 LISTENING 11828 /run/user/ytlreal/keyring-cuLMzX/control
unix 2 [ ACC ] 流 LISTENING 8408 @/com/ubuntu/upstart
unix 2 [ ACC ] 流 LISTENING 7998 @/org/bluez/audio
unix 2 [ ACC ] 流 LISTENING 2029 @/tmp/.X11-unix/X0
unix 2 [ ACC ] 流 LISTENING 11869 @/tmp/dbus-oZvW58NsSp
unix 2 [ ACC ] 流 LISTENING 8081 /var/run/acpid.socket
unix 2 [ ACC ] 流 LISTENING 9896 /var/run/dbus/system_bus_socket
unix 2 [ ACC ] 流 LISTENING 14913 @/tmp/dbus-2gkvFVNb
unix 2 [ ACC ] 流 LISTENING 9933 /var/run/sdp
unix 2 [ ACC ] 流 LISTENING 14457 @/tmp/dbus-kTBAyCa0aq
unix 2 [ ACC ] 流 LISTENING 9209 /var/run/avahi-daemon/socket
unix 2 [ ACC ] SEQPACKET LISTENING 8445 /run/udev/control
解决方法:
还有另一个软件在端口3306中监听.尝试做
netstat -na | grep LISTEN
然后看看它是否属实. 3306不应该在那里.如果你看到有什么东西正在侦听那个端口,你必须在尝试启动MySQL之前杀死它
内容总结
以上是互联网集市为您收集整理的mysql服务无法启动:地址已在使用中全部内容,希望文章能够帮你解决mysql服务无法启动:地址已在使用中所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错,欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明:本文内容由互联网用户自发贡献,该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容, 请发送邮件至 gblab@vip.qq.com 举报,一经查实,本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。