Cannot connect to database server in MySQLWorkBench

Question

I login into my VM login MySQL. I run:

mysql -u root -p
CREATE USER 'bheng'@'46.101.59.250' IDENTIFIED BY '**********';
GRANT ALL PRIVILEGES ON * . * TO 'bheng'@'46.101.59.250';
FLUSH PRIVILEGES;

I see this

select User,Host from mysql.user;

+------------------+---------------+
| User             | Host          |
+------------------+---------------+
| bheng            | 46.101.59.250 |
| cas              | localhost     |
| debian-sys-maint | localhost     |
| mysql.session    | localhost     |
| mysql.sys        | localhost     |
| root             | localhost     |
+------------------+---------------+

Then I tried to connect to my database as bheng user. I could not get in.

I kept getting this error:

How can I resolve this?

This question had critical details removed from it in order to hide account details. Unfortunately all of those details were still available in the edit history, so there was not point in doing it. Moreover, the edit invalidated answers given below, and removed critical information, to the degree I would regard the edit as vandalism. Please do not do this. If you are worried about the security of your server, lock the user account named here and create a new one under a different name. — halfer
– halfer, Commented Jul 14, 2019 at 23:56

code-8 · Accepted Answer · 2018-03-10 23:27:02Z

2

When you issue this partial command CREATE USER 'bheng'@'46.101.59.255' you instruct MySQL to allow the named user to log in from the machine at address 46.101.59.255. Is that the machine upon which MySQL runs? If so, you need to give your own machine's address. It seems unlikely this is your own machine's address, because it's registered to Digital Ocean.

Also, many hosting operators put firewalls on port 3306 (the MySQL connection port) to keep databases secure. Is this the case for your situation? If so, you should ask for help, or adjust your firewall. Be careful about opening up unencrypted connections to the public internet for your MySQL server: the public net is crawling with cybercreeps.

edited Mar 10, 2018 at 23:27

code-8

59.5k122 gold badges397 silver badges678 bronze badges

answered Mar 10, 2018 at 19:40

O. Jones

109k17 gold badges134 silver badges187 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

code-8 Over a year ago

How would one go about and access his own database via a remote DBMS client ?

Mike Lischke Over a year ago

Use an SSH connection instead @ihue. This is the common approach to tunnel a connection through an otherwise protected box.

Cava · Accepted Answer · 2018-03-15 23:42:16Z

1

Try execute this (only for test), and try again connect, if it works your IP is not '46.101.59.255', if does not work can be firewall:

UPDATE mysql.user SET host = '%' WHERE host != 'localhost';
FLUSH PRIVILEGES;

To check the ports being listened execute this command netstat -tuplen

Now, I will see my IP, because my problem is the IP adress.

edited Mar 15, 2018 at 23:42

answered Mar 10, 2018 at 19:47

Cava

5,7424 gold badges29 silver badges46 bronze badges

1 Comment

code-8 Over a year ago

I tried that, it still not let me in. but I got diff error, for sure.

Collectives™ on Stack Overflow

Cannot connect to database server in MySQLWorkBench

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related