Solved

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

Posted on 2010-09-17
9
970 Views
Last Modified: 2012-05-10
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
0
Comment
Question by:Bob Stone
  • 5
  • 3
9 Comments
 
LVL 21

Expert Comment

by:chapmanjw
ID: 33706532
Try making sure port 3306 is open on your Windows Firewall (or even trying temporarily turning it off).
0
 
LVL 83

Accepted Solution

by:
Dave Baldwin earned 500 total points
ID: 33706625
Make sure 'mysqld', the 'MySQL' service is running.
0
 
LVL 9

Author Comment

by:Bob Stone
ID: 33706846
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

0
VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

 
LVL 9

Author Comment

by:Bob Stone
ID: 33706851
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?
0
 
LVL 9

Author Comment

by:Bob Stone
ID: 33706857
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.
0
 
LVL 83

Expert Comment

by:Dave Baldwin
ID: 33706876
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.
0
 
LVL 9

Author Comment

by:Bob Stone
ID: 33706890
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.
0
 
LVL 83

Expert Comment

by:Dave Baldwin
ID: 33706902
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.
0
 
LVL 9

Author Comment

by:Bob Stone
ID: 33706936
I got it =o)

Thanks.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Foreword In the years since this article was written, numerous hacking attacks have targeted password-protected web sites.  The storage of client passwords has become a subject of much discussion, some of it useful and some of it misguided.  Of cou…
Introduction Since I wrote the original article about Handling Date and Time in PHP and MySQL (http://www.experts-exchange.com/articles/201/Handling-Date-and-Time-in-PHP-and-MySQL.html) several years ago, it seemed like now was a good time to updat…
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

785 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question