Link to home
Start Free TrialLog in
Avatar of Bob Stone
Bob StoneFlag for United States of America

asked on

Can't create connection or server instance in MySQL on Windows Server 2003

I installed MySQL Server 5.1 and MySQL Workbench 5.2 on Windows Server 2003 running IIS. Install seemed to go fine, but I can't successfully create a connection or a server instance. I get this error.

I don't what to do with that exactly.
MySQL-Error.PNG
Avatar of chapmanjw
chapmanjw
Flag of United States of America image

Try making sure port 3306 is open on your Windows Firewall (or even trying temporarily turning it off).
ASKER CERTIFIED SOLUTION
Avatar of Dave Baldwin
Dave Baldwin
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Bob Stone

ASKER

The Service wasn't running, after I started it I was able to create localhost connection successfully, but when I try to do a new server instance I get;


Checking command 'sc query mysql | wba_filter(RUNNING)'

Server detected as running

x32 on x32

Check if C:\Program Files\MySQL\MySQL Server 5.0\my.ini exists locally

Operation failed: File C:\Program Files\MySQL\MySQL Server 5.0\my.ini doesn't exist

Open in new window

I just checked and I have C:\Program Files\MySQL\MySQL Server 5.1\my.ini but somehow it wants a C:\Program Files\MySQL\MySQL Server 5.0\my.ini
What am I supposed to do with that?
I dunno if this is the right way to fix it or not, but I copied C:\Program Files\MySQL\MySQL Server 5.1 and renamed it C:\Program Files\MySQL\MySQL Server 5.0, it seems to work as far as I can tell, but I haven't got anything to test with it. I am trying to configure WordPress on it but I dunno how to do that either.
Wordpress uses PHP.  Do you have that installed?  You might want to look at Microsoft's PHP installation page: http://www.microsoft.com/web/platform/phponwindows.aspx

You will have to create a database for Wordpress to use before you try to install it.  Part of creating a database is also creating users who have the privileges to use it.
PHP is installed and working, I am trying to work through the initial setup of the DB on WP. This is a new server and I don't have any experience with MySQL, some with  MSSQL, but not a lot with initial setup of DBs.
There are a lot of tutorials for setting up MySQL databases in addition to the documentation on http://www.mysql.com/ .  While MySQL is similar to MSSQL, it requires specific steps to set things up and that discussion is a little bit long to do here.  If you have specific questions in the process, come back and ask them here.
I got it =o)

Thanks.