whmeeske Posted November 10, 2003 Share Posted November 10, 2003 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? Quote Link to comment https://forums.phpfreaks.com/topic/1334-problem-running-mysql/ Share on other sites More sharing options...
shivabharat Posted November 10, 2003 Share Posted November 10, 2003 Goto ControlPanel>Administrative Tool>services Click on the Process named mysql. In the Genreal TAB PATH_TO BE EXECUTED c:mysqlbinmysqld-nt enusre that its pointing to the correct path. If its correct enusre that mysql service is running. Quote Link to comment https://forums.phpfreaks.com/topic/1334-problem-running-mysql/#findComment-4422 Share on other sites More sharing options...
whmeeske Posted November 10, 2003 Author Share Posted November 10, 2003 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... Quote Link to comment https://forums.phpfreaks.com/topic/1334-problem-running-mysql/#findComment-4423 Share on other sites More sharing options...
shivabharat Posted November 10, 2003 Share Posted November 10, 2003 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 Quote Link to comment https://forums.phpfreaks.com/topic/1334-problem-running-mysql/#findComment-4424 Share on other sites More sharing options...
whmeeske Posted November 10, 2003 Author Share Posted November 10, 2003 Go to command prompt and try this C:>cd mysqlbinC: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... Quote Link to comment https://forums.phpfreaks.com/topic/1334-problem-running-mysql/#findComment-4425 Share on other sites More sharing options...
shivabharat Posted November 10, 2003 Share Posted November 10, 2003 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 . Quote Link to comment https://forums.phpfreaks.com/topic/1334-problem-running-mysql/#findComment-4426 Share on other sites More sharing options...
whmeeske Posted November 11, 2003 Author Share Posted November 11, 2003 Run these commands in the command promptc: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... Quote Link to comment https://forums.phpfreaks.com/topic/1334-problem-running-mysql/#findComment-4441 Share on other sites More sharing options...
whmeeske Posted November 13, 2003 Author Share Posted November 13, 2003 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: Quote Link to comment https://forums.phpfreaks.com/topic/1334-problem-running-mysql/#findComment-4477 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.