Solved

Can't connect to the MySQL server 5.2.22 community edition

Posted on 2012-04-02
9
1,222 Views
Last Modified: 2012-04-03
Installed MySQL Server 5.2.22 on a Windows 2008 server. Using the MySQL workbench 5.2 cummunityt edition, the database is working on the server and I can actually log into it via ODBC on the server computer. I have tried to log on the MySQL server on windows 7 client machine using ODBC and it will not see the My SQL server. I have disabled the windows firewall on both the server and the client and I still can not see the My SQL server on the client machine. Openned port 3306 and nothing.
Any suggestions?

Thanks,
Mike
0
Comment
Question by:miker454
[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
  • 3
  • 2
  • 2
  • +1
9 Comments
 
LVL 6

Assisted Solution

by:Patrick Tallarico
Patrick Tallarico earned 150 total points
ID: 37798662
With the ODBC driver, when you try to set up the connection, there should be a test button that you can use before you finish the setup.  What error does it give?
0
 

Author Comment

by:miker454
ID: 37798720
Thanks for the interest. I try to add the ODBC drive MySQL ODBC 5.1 driver version 5.01.08.00 in the client computer and after I enter the connection parameters Data source name, user, password, I can not see any of the databases in the drop down button, and the test fails. (Connection fails: [HY000][ODBC 5.1 Driver]Can't connect to MySQL sever on 'Localhost' (10061). I do the same thing on the server computer and there the databases come up and test is succesfull.

Thanks,
Mike
0
 
LVL 24

Expert Comment

by:johanntagle
ID: 37798732
You can see from the error message that it is connecting to localhost, not the server.  Can you post your connection parameters?
0
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 
LVL 78

Expert Comment

by:arnold
ID: 37798772
You need to first to configure MySQL to listen for tcp/ip connections.
You the have to use the advanced firewall settings and open the port you configured in the prior to allow access from the private/domain network.

netstat -an | grep 3306
See whether MySQL is using the default port.
Use the MySQL configuration tool to make sure it is configured to listen on tcp/ip.
Then make sure you add the user you want to connect with to allow connections from hosts other than localhost.
0
 
LVL 6

Expert Comment

by:Patrick Tallarico
ID: 37798777
Make sure the host parameter is the name of the server rather than localhost, or the IP address of the server.
In addition, you may need to grant permission to the user to allow that database to be accessed from a remote computer, (not on the server as localhost)
Generally speaking the syntax for that type of command is:
grant all on database.tablename to 'user'@'computer or ipaddress' identified by 'password';
tablename could be '*' to specify all tables, and computer or ipaddress could be '%' to specify a user from anywhere.
0
 

Author Comment

by:miker454
ID: 37799036
Using the MySQL workbench on the server I created a new New Connection with the name of the client computers as the user (instead of root). I then tried to create the OBDC from the client computer

 Data Source Name: Mike7 (it is the name of the connection on the server)
TCP?IP Server : 192.168.1.180 (servers ipv4 address)
Port: 3306
User: MIKEWIN7 (name of the client computer)
Password: ****** (same password as server connection)

When I hit the test button : Connection Failed: [HY000][MySQL][ODBC 5.1 Driver]
 Host 'MIKEWIN7' is not allowed to connect to this MySQL server.

How do I give this computer permission to connect. I figured once I created a connection that would be enough to give it permission to connect. I specifically used the name MIKEWIN7 as name of the username on the server New Connection. Im still not there.

Thanks for all the suggestions,
Mike
0
 
LVL 78

Accepted Solution

by:
arnold earned 200 total points
ID: 37799084
Within workbench use the administrator.
Then add the user at any host %. Note using the same username at times leads to trouble do to conflict especially if the user has separate password
Usename@client
Usename@%

If you prefer using the comman line interface.
http://31bit.com/technology/86-mysql-database/302-how-to-grant-remote-access-to-a-mysql-database
Note that after adding users, you need to flush privileges.
0
 
LVL 24

Assisted Solution

by:johanntagle
johanntagle earned 150 total points
ID: 37799102
In addition to @arnold's comment, @stpmt11 already gave you the GRANT syntax above.  You can also refer to http://dev.mysql.com/doc/refman/5.1/en/grant.html for more details.
0
 

Author Closing Comment

by:miker454
ID: 37801207
Thanks to all 3 of you. I feel kind of silly for having problem right off the starting gun but you guys helped me connect to the server. I went to the workbech and added users and priviledges. I did it right from the interface.Thanks Arnold, johanntangle, and stpmt11.


Appreciate it,
Mike
0

Featured Post

Webinar: Aligning, Automating, Winning

Join Dan Russo, Senior Manager of Operations Intelligence, for an in-depth discussion on how Dealertrack, leading provider of integrated digital solutions for the automotive industry, transformed their DevOps processes to increase collaboration and move with greater velocity.

Question has a verified solution.

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

I use MySQL for many of my development projects in a Windows environment. To manage my databases (and perform queries) for years I used a tool called MySQL administrator.  This tool has since been replaced by MySQL Workbench. So I decided to m…
Foreword This article was written many years ago, in the days when PHP supported the MySQL extension (http://php.net/manual/en/function.mysql-connect.php).  Today (http://php.net/manual/en/migration70.removed-exts-sapis.php) you would not use MySQL…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…
Finding and deleting duplicate (picture) files can be a time consuming task. My wife and I, our three kids and their families all share one dilemma: Managing our pictures. Between desktops, laptops, phones, tablets, and cameras; over the last decade…

739 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