Jump to content

Problem running MySQL


whmeeske

Recommended Posts

I\'m running Apache2 and PHP4 on a Windows 2000 PC. This configuration works quite well, I can run php testscripts.

 

So far so good.

 

Now I want to use MySQL on this system and there appears a problem I can\'t solve. I installed MySQL 4.0.16 and that appears to be OK.

But if I give a command in the cmd-shell (for example \'mysqlshow\') or if I try to start phpMyAdmin in IE (http://localhost/phpmyadmin) I get the following error:

#2003 - Can\'t connect to MySQL server on \'localhost\' (10061)

 

When I start winmysqladmin I get a green traffic-light, so it seems that the MySQL-service runs OK. But on the environment-tab there\'s no server-info displayed, neither on the server-tab.

 

I don\'t understand this. I re-installed the whole package again, but that wasn\'t the solution.

 

I get a headache of this matter an it drives me a little crazy.

 

Is there anyone around who has the same experience and has (hopefully) a solution?

Link to comment
Share on other sites

ControlPanel>Administrative Tool>services

Click on the Process named mysql.

In the Genreal TAB

PATH_TO BE EXECUTED

c:mysqlbinmysqld-nt

ensure that its pointing to the correct path.

If its correct ensure that mysql service is running.

 

The path is correct and the service is running without any errors...

Link to comment
Share on other sites

Ok try this

 

Go to command prompt and try this

 

C:>cd mysqlbin

 

C:mysqlbin>mysql -u root

Welcome to the MySQL monitor.  Commands end with ; or g.

Your MySQL connection id is 1 to server version: 4.1.0-alpha-max-nt

 

Type \'help;\' or \'h\' for help. Type \'c\' to clear the buffer.

 

mysql>

 

If you have set a password then you need to use the ysntax like this

 

mysql -u root -p

Link to comment
Share on other sites

Go to command prompt and try this

 

C:>cd mysqlbin

C:mysqlbin>mysql -u root

Welcome to the MySQL monitor.  Commands end with ; or g.

Your MySQL connection id is 1 to server version: 4.1.0-alpha-max-nt

Type \'help;\' or \'h\' for help. Type \'c\' to clear the buffer.

mysql>

 

If you have set a password then you need to use the ysntax like this

mysql -u root -p

 

I also tried this command, but I get the same error:

#2003 - Can\'t connect to MySQL server on \'localhost\' (10061)

 

I really don\'t know how to solve this problem, I\'m almost in a mood to re-install w2k...but I don\'t know if thats a solution...

Link to comment
Share on other sites

Run these commands in the command prompt

c:mysqlbinmysqladmin -u root shutdown

c:mysqlbinmysqld-nt --remove

c:mysqlbinmysqld-nt --install

Once this is done go to the service and check if your mysql service is started and if not start it and try to connect .

I tried all this (and the items above) on another PC with w2k and there it works without any errors.

So it seems that there\'s somewhere a problem on my own w2k PC, but I don\'t know how to find it...

Link to comment
Share on other sites

I reinstalled Windows 2000 on the partition I use for my experiments. Then I reinstalled step-by-step Apache2, PHP4, MySQL4 and phpMyAdmin.

 

I\'ve tested it heavily and now it seems to keep working. Now I have a platform to learn more about PHP and MySQL.

 

Thanx for the help :wink:

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.