<?xml version="1.0" encoding="UTF-8" ?>
<rss version="2.0">
<channel>
<title><![CDATA[沧海一粟]]></title> 
<link>http://www.dzhope.com/index.php</link> 
<description><![CDATA[Web系统架构与服务器运维,php开发]]></description> 
<language>zh-cn</language> 
<copyright><![CDATA[沧海一粟]]></copyright>
<item>
<link>http://www.dzhope.com/post//</link>
<title><![CDATA[Linux服务器MySQL数据库无法登陆处理方法]]></title> 
<author>jed &lt;jed521@163.com&gt;</author>
<category><![CDATA[数据库技术]]></category>
<pubDate>Mon, 23 Mar 2009 01:54:39 +0000</pubDate> 
<guid>http://www.dzhope.com/post//</guid> 
<description>
<![CDATA[ 
	&nbsp;&nbsp;&nbsp;&nbsp;您在使用Linux独享服务器时，可能会遇到由于服务器MySQL负载高或调试、误操作而导致的数据库无法登陆问题，那么我们现在简单介绍下MySQL数据库无法登陆的处理方法。<br/><br/>&nbsp;&nbsp;&nbsp;&nbsp;首先使用CRT远程登陆服务器，使用以下两行命令：<br/><br/>例如MySQL进程查询返回信息：<br/><br/>Warning: bad syntax, perhaps a bogus '-'? See /usr/share/doc/procps-3.2.3/FAQ<br/>root&nbsp;&nbsp;&nbsp;&nbsp; 10165&nbsp;&nbsp;0.0&nbsp;&nbsp;0.1&nbsp;&nbsp;4804 1144 ?&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;S&nbsp;&nbsp;&nbsp;&nbsp;17:08&nbsp;&nbsp; 0:00 /bin/sh /usr/local/mysql/bin/mysqld_safe --user=mysql<br/>mysql&nbsp;&nbsp;&nbsp;&nbsp;10196&nbsp;&nbsp;0.0&nbsp;&nbsp;1.0 50948 11308 ?&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; S&nbsp;&nbsp;&nbsp;&nbsp;17:08&nbsp;&nbsp; 0:00 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/var --user=mysql --pid-file=/usr/local/mysql/var/ud.pid --skip-external-locking --port=3306 --socket=/tmp/mysql.sock<br/>root&nbsp;&nbsp;&nbsp;&nbsp; 10197&nbsp;&nbsp;0.0&nbsp;&nbsp;1.0 50948 11308 ?&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; S&nbsp;&nbsp;&nbsp;&nbsp;17:08&nbsp;&nbsp; 0:00 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/var --user=mysql --pid-file=/usr/local/mysql/var/ud.pid --skip-external-locking --port=3306 --socket=/tmp/mysql.sock<br/><br/>1、[root@ud~]# kill -9 `ps ax&#124;grep mysqld &#124;awk '&#123;print $1&#125;'`(杀掉MySQL进程)<br/><br/>2、[root@ud~]# /usr/local/mysql/bin/mysqld_safe --user=mysql &(重新启动MySQL服务)<br/><br/><br/> <br/><br/>Tags - <a href="http://www.dzhope.com/tags/linux/" rel="tag">linux</a> , <a href="http://www.dzhope.com/tags/mysql/" rel="tag">mysql</a> , <a href="http://www.dzhope.com/tags/%25E9%2587%258D%25E5%2590%25AFmysql/" rel="tag">重启mysql</a>
]]>
</description>
</item><item>
<link>http://www.dzhope.com/post//#blogcomment</link>
<title><![CDATA[[评论] Linux服务器MySQL数据库无法登陆处理方法]]></title> 
<author> &lt;user@domain.com&gt;</author>
<category><![CDATA[评论]]></category>
<pubDate>Thu, 01 Jan 1970 00:00:00 +0000</pubDate> 
<guid>http://www.dzhope.com/post//#blogcomment</guid> 
<description>
<![CDATA[ 
	
]]>
</description>
</item>
</channel>
</rss>