MySQL重启后无法正常工作 [英] MySQL not working after reboot
问题描述
您好，
我刚刚在Win2K计算机上安装了MySQL 4.0.18。一旦安装完毕，我就用
运行WinMySQLAdmin程序，一切正常。小绿色
指示灯亮起，我可以连接到我的数据库。
但是，一旦我重新启动计算机，绿灯就会变为a / b
红灯，从那时起我就无法连接到我的数据库了。
我打开WinMySQLAdmin，服务器环境页面上的组框是
完全为空（它曾经有很多服务器信息）。
如何解决这种情况？
提前致谢，
Duncan Jones
Hello,
I just installed MySQL 4.0.18 on my Win2K computer. Once it installed, I
ran the WinMySQLAdmin program and everything worked fine. The little green
light was on, and I could connect to my databases.
However, as soon as I restarted my computer, the green light changed to a
red light, and since then I''ve been unable to connect to my databases. When
I open WinMySQLAdmin, the "Server" group box on the Environment page is
completely empty (it used to have lots of server information in it).
How can I remedy this situation??
Thanks in advance,
Duncan Jones
推荐答案
" Aggro" < SP ********** @ yahoo.com>在消息中写道
news：q7 ************** @ read3.inet.fi ...
"Aggro" <sp**********@yahoo.com> wrote in message
news:q7**************@read3.inet.fi...
Duncan Jones写道：
Duncan Jones wrote:
我刚刚在Win2K计算机上安装了MySQL 4.0.18。一旦安装，
我运行WinMySQLAdmin程序，一切正常。小
绿灯亮了，我可以连接到我的数据库。
I just installed MySQL 4.0.18 on my Win2K computer. Once it installed, I ran the WinMySQLAdmin program and everything worked fine. The little green light was on, and I could connect to my databases.
mysql服务器是否正在运行？如果没有，请启动它。
Is the mysql server running? If not, start it.
其中存在的问题是：一旦我启动它，服务器就会自动关闭。
以下是我刚刚启动时尝试的清单：
~~~~~~~~~~~~ ~~~
Windows启动......... WinMySQLAdmin启动并最小化到
托盘......
绿灯.....（3秒）.....红灯:-(
从行政打开服务工具和手动重启
服务器......服务器成功启动......
.....简短的绿灯..... ..再次亮红色。重新打开服务
的东西，MySQL服务不再运行。
尝试运行mysqld-nt .exe文件。没有效果。
然后打开一个命令提示符。输入net start mysql.........service
成功启动.....
....再次点亮绿灯...........红色~3秒后。
作为测试，我输入 ; net stop mysql.......确定.......无法停止
服务，因为它没有运行等等。
~~~~~~~~~~~~~~~~~~
基于该信息的任何想法???
Duncan Jones
Therein lies the problem: the server always shuts itself down as soon as I
start it.
The following is a list of what I attempted just now when I booted up:
~~~~~~~~~~~~~~~
Windows boots up ......... WinMySQLAdmin starts up and minimises to
tray...
Green light..... (3 seconds)..... red light :-(
Open up "Services" from "Administrative Tools" and manual restart the
server...... "Server started succesfully"..
..... brief green light....... light goes red again. Reopen the "services"
thing, and the MySQL service is no longer running.
Try running the mysqld-nt.exe file. No effect.
Then open up a command prompt. Type "net start mysql"......... "service
started successfully".....
.... brief green light again........... red after ~3 seconds.
As a test, I type "net stop mysql"....... sure enough....... "cannot stop
service as it is not running etc."
~~~~~~~~~~~~~~~~~~~
Any ideas based on that information???
Duncan Jones
" Aggro" < SP ********** @ yahoo.com>在消息中写道
news：q7 ************** @ read3.inet.fi ...
"Aggro" <sp**********@yahoo.com> wrote in message
news:q7**************@read3.inet.fi...
Duncan Jones写道：
Duncan Jones wrote:
我刚刚在Win2K计算机上安装了MySQL 4.0.18。一旦安装，
我运行WinMySQLAdmin程序，一切正常。小
绿灯亮了，我可以连接到我的数据库。
I just installed MySQL 4.0.18 on my Win2K computer. Once it installed, I ran the WinMySQLAdmin program and everything worked fine. The little green light was on, and I could connect to my databases.
mysql服务器是否正在运行？如果没有，请启动它。
Is the mysql server running? If not, start it.
其中存在的问题是：一旦我启动它，服务器就会自动关闭。
以下是我刚刚启动时尝试的清单：
~~~~~~~~~~~~ ~~~
Windows启动......... WinMySQLAdmin启动并最小化到
托盘......
绿灯.....（3秒）.....红灯:-(
从行政打开服务工具和手动重启
服务器......服务器成功启动......
.....简短的绿灯..... ..再次亮红色。重新打开服务
的东西，MySQL服务不再运行。
尝试运行mysqld-nt .exe文件。没有效果。
然后打开一个命令提示符。输入net start mysql.........service
成功启动.....
....再次点亮绿灯...........红色~3秒后。
作为测试，我输入 ; net stop mysql.......确定.......无法停止
服务，因为它没有运行等等。
~~~~~~~~~~~~~~~~~~
基于该信息的任何想法???
Duncan Jones
Therein lies the problem: the server always shuts itself down as soon as I
start it.
The following is a list of what I attempted just now when I booted up:
~~~~~~~~~~~~~~~
Windows boots up ......... WinMySQLAdmin starts up and minimises to
tray...
Green light..... (3 seconds)..... red light :-(
Open up "Services" from "Administrative Tools" and manual restart the
server...... "Server started succesfully"..
..... brief green light....... light goes red again. Reopen the "services"
thing, and the MySQL service is no longer running.
Try running the mysqld-nt.exe file. No effect.
Then open up a command prompt. Type "net start mysql"......... "service
started successfully".....
.... brief green light again........... red after ~3 seconds.
As a test, I type "net stop mysql"....... sure enough....... "cannot stop
service as it is not running etc."
~~~~~~~~~~~~~~~~~~~
Any ideas based on that information???
Duncan Jones
Duncan Jones写道：
Duncan Jones wrote:
任何想法基于那些信息???
Any ideas based on that information???
我只使用mysql作为独立的，即我用命令启动它：
c：\ mysql \ bin\mysqld - standalone
所以我不知道服务或你提到的任何其他事情。怎么
你的电脑上应该有error.log，这可能会说明为什么它会这样做。
I have only used mysql as standalone, i.e. I start it with command:
c:\mysql\bin\mysqld --standalone
So I don''t know about services or anything else you mentioned about. How
ever there should be error.log on your computer, which might tell why it
does that.
这篇关于MySQL重启后无法正常工作的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
