Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Help connecting MySql Workbench

Posted on 2011-03-14
4
Medium Priority
?
1,515 Views
Last Modified: 2012-05-11
Hi I am having trouble connecting to my server.

When I try to connect to the server I get the following error.

---------------------------
MySQL Workbench Error
---------------------------
Cannot Connect to Database Server

Your connection attempt failed for user 'root' from your host to server at IP ADDRESS:3306:

  Access denied for user 'root'@'<number>.range86-144.btcentralplus.com' (using password: YES)



Please:

1 Check that mysql is running on server <IP ADDRESS>

2 Check that mysql is running on port 3306 (note: 3306 is the default, but this can be changed)

3 Check the root has rights to connect to <IP ADDRESS> from your address (mysql rights define what clients can connect to the server and from which machines)

4 Make sure you are both providing a password if needed and using the correct password for <IP ADDRESS> connecting from the host address you're connecting from
---------------------------
OK  
---------------------------

Now the windows firewall service is not running on the server, so it can't be that. The IP user, pass are all correct to.

Any Ideas?

Matt.
0
Comment
Question by:flynny
[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
  • 2
4 Comments
 

Expert Comment

by:pakachele
ID: 35133328
there might be 3 situations:
1. network problem, try pinging the ip address seperately
2. confirm that the mysql server is running
3. further there point 3 of the solutions provided might be a cause; often it happens we try to connect from a new machine whose ip address is not in the clients list on the server ...
0
 
LVL 13

Expert Comment

by:dsmile
ID: 35136364
You need to access your server that running mysql and run mysql grant from that to allow your ip to access mysql server.

GRANT ALL ON *.* TO 'root'@'<IP ADDRESS>';

Read more about this here http://dev.mysql.com/doc/refman/5.1/en/grant.html
0
 

Author Comment

by:flynny
ID: 35145179
hi guys,
dsmile, we are not on a static IP address though? I am able to grant access universally?

is this safe?

thanks for the advice guys.
0
 
LVL 13

Accepted Solution

by:
dsmile earned 2000 total points
ID: 35147655
Yes, you can grant access universally

mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'
> IDENTIFIED BY 'password' WITH GRANT OPTION;
mysql> FLUSH PRIVILEGES;
mysql> exit

But, NO, it's NOT safe.

root access should be granted to limited user only (not to say it should be local only).

In my opinion, you should create several accounts with different privileges (less power than root account) and allow them to be accessed universally.
0

Featured Post

Learn Veeam advantages over legacy backup

Every day, more and more legacy backup customers switch to Veeam. Technologies designed for the client-server era cannot restore any IT service running in the hybrid cloud within seconds. Learn top Veeam advantages over legacy backup and get Veeam for the price of your renewal

Question has a verified solution.

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

This post looks at MongoDB and MySQL, and covers high-level MongoDB strengths, weaknesses, features, and uses from the perspective of an SQL user.
In this blog, we’ll look at how improvements to Percona XtraDB Cluster improved IST performance.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses

688 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