Page 1 of 1

Installing MySQL

Posted: Sat Sep 24, 2005 6:21 pm
by spyderwoman
I am in the process of trying to install MySQL on my computer to run locally for testing with php. I intend to use IIS rather than Apache. I receved a message that my service was sucessfully installed and I can start and stop the service without problems but when I try to run "mysqlshow" from the command line (as instructed in my book to test whether mysql is working), I receive this error:
"mysqlshow: Cannot connect to mySQL server on 'localhost' <10061>"
Is there something else I need to set in IIS for this to work.
I have tried this install before and failed b/c I kept going so I would prefer not to proceed with my php install until I know this is working.
Thanks in advance.
Cori

Posted: Sat Sep 24, 2005 6:58 pm
by spyderwoman
Actually, it looks like i cant telnet to localhost, however I can browse to local websites I have created in the past. How can I find out which port I am using?

Posted: Sat Sep 24, 2005 9:05 pm
by timvw
Are you sure you are running the mysql daemon at that time? In that case you should have a process that is bound to port 3306

Code: Select all

C:\Documents and Settings\timvw>net start mysql
De MySQL-service is gestart.

C:\Documents and Settings\timvw>netstat -a

Actieve verbindingen

  Proto  Lokaal adres           Extern adres           Status
  TCP    thuis:3306             thuis.workgroup:0      Bezig met luisteren

Posted: Sun Sep 25, 2005 10:40 am
by spyderwoman
I tried the first command and it said my service was running then I tried the second command and it brought up my active ports but 3306 wasnt one of them. Do I need to do something else to get that working?
Thanks,
Cori

Posted: Sun Sep 25, 2005 10:55 am
by spyderwoman
What happens if in the mysql server instance configuration i disable TCP/IP networking since I will only be working on the db locally. Why is it that I still cannot telnet to localhost or get a response from mysqlshow?

Posted: Sun Sep 25, 2005 10:59 am
by feyd
TCP/IP is required for those things, last I checked...

Posted: Sun Sep 25, 2005 11:00 am
by timvw
I don't think windows supports unix sockets, so i didn't consider the option where you disable tcp/ip in mysql.

Posted: Sun Sep 25, 2005 11:03 am
by spyderwoman
Okay, so if I run the configuration and use 3306 as the port why is it that I still cannot type mysqlshow and get a response. Sorry for what I am sure seems very simple... i have always been a install delinquent but once I can get to the code I am much better.