1044 - Access denied for user 'root'@'%' to database 'test' cleardb

Question

I have an issue that when i try to connect to a database in cleardb it gives me this error:

1044 - Access denied for user 'root'@'%' to database 'test'

when it connect via navicat and try to upload new test.sql file to update my database i get the same error.

is there a way to do it?

Yes, the database exist in the cleardb but my website anable to connect. — Mohammad AL-Raoosh, Jan 19 '16 at 11:35
The database may exist, but are you using the correct user to access it? — Andy Holmes, Jan 19 '16 at 11:37
I'm doing a migration from visual studio and I encounter this error. What I did was Created the database manually then perform my migration. ta-da problem solved :) — Thinker Bell, Apr 26 '21 at 07:49

score 1 · Answer 1 · answered Jan 19 '16 at 11:45

1

Default root user in MySQL does not have permissions to access outside local host, so you should create a user to be able to do this like:

CREATE USER 'someuser'@'%' IDENTIFIED BY "your_password";
GRANT ALL PRIVILEDGES ON test.* TO 'someuser'@'%';

Then try connecting with this user

answered Jan 19 '16 at 11:45

Bolovsky

i can't create a new user in cleardb, and i use what he gives me – Mohammad AL-Raoosh Jan 19 '16 at 11:48
then you need to connect directly with localhost or tunnel into the machine and connect :( – Bolovsky Jan 19 '16 at 11:50
I'm doing a migration from visual studio and I encounter this error. What I did was Created the database manually then perform my migration. ta-da problem solved :) – Thinker Bell Apr 26 '21 at 07:50

1 Answers1