Installing MySQL

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
spyderwoman
Forum Newbie
Posts: 24
Joined: Thu Sep 01, 2005 8:19 pm

Installing MySQL

Post 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
spyderwoman
Forum Newbie
Posts: 24
Joined: Thu Sep 01, 2005 8:19 pm

Post 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?
timvw
DevNet Master
Posts: 4897
Joined: Mon Jan 19, 2004 11:11 pm
Location: Leuven, Belgium

Post 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
spyderwoman
Forum Newbie
Posts: 24
Joined: Thu Sep 01, 2005 8:19 pm

Post 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
spyderwoman
Forum Newbie
Posts: 24
Joined: Thu Sep 01, 2005 8:19 pm

Post 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?
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

TCP/IP is required for those things, last I checked...
timvw
DevNet Master
Posts: 4897
Joined: Mon Jan 19, 2004 11:11 pm
Location: Leuven, Belgium

Post by timvw »

I don't think windows supports unix sockets, so i didn't consider the option where you disable tcp/ip in mysql.
spyderwoman
Forum Newbie
Posts: 24
Joined: Thu Sep 01, 2005 8:19 pm

Post 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.
Post Reply