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.