Solved

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

Posted on 2010-09-17
9
974 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 
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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
This article shows the steps required to install WordPress on Azure. Web Apps, Mobile Apps, API Apps, or Functions, in Azure all these run in an App Service plan. WordPress is no exception and requires an App Service Plan and Database to install
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

687 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