Can't access MySQL DB of user using ip $$$ using password yes

Ratemo's profile image Ratemo posted 4 years ago in General Permalink

Hello guys sorry hope you can help me clear this up, I created a first an unnamed access to MySQL DB using Heidi Sql and logged in success, I created another heroku app and created another an unnamed access to it but can't login in saying errors with IP and password yes, yet I can log in to the first but can't login to this new second app.

ansgar's profile image ansgar posted 4 years ago Permalink

That user has to get the right client IP in the mysql.user table, from which it connects. Or you can also set a wildcard, like 192.168.%, or just %:

Description

Afterwards you need to flush privileges:

FLUSH privileges;
Ratemo's profile image Ratemo posted 4 years ago Permalink

I can't connect to the database, I put my host, username, DB and password which is given directly by heroku jawsDB MySQL, The problem is just connecting to DB so I can't flush privileges without connecting with Heidi sql

ansgar's profile image ansgar posted 4 years ago Permalink

Then do it with the session you used to create the account.

Ratemo's profile image Ratemo posted 4 years ago Permalink

I need to upload a local database file to the database. How can I go about it without having to install MySQL...or if it's impossible what's the link to download a MySQL server then because it's really hard to find it on MySQL web

Ratemo's profile image Ratemo posted 4 years ago Permalink

Please contact me on email I send you some credentials you help out... clintonbrucy@gmail.com

ansgar's profile image ansgar posted 4 years ago Permalink

No, please, I don't do support for MySQL itself.

You should instead explain step by step what is going wrong here.

Ratemo's profile image Ratemo posted 4 years ago Permalink

So I deployed to heroku, create a a jawsDB MySQL as a free add-on. I configured the connections to the DB config files in PHP to that provided by heroku. So I want to Acess the DB now using Heidi Sql so that I can upload the local DB sql file. I can't access says Acess denied for user using ip ### using password yes. I can't access DB at all so how can I Acess yet I had earlier last week accessed database of another heroku app but can't access this one.

Please login to leave a reply, or register at first.