Access denied for database when connection externally

Zka

Hello

I have a MariaDB set up which works perfectly from the php webapp and from the Adminer. DB user has GRANT ALL PRIVILEGES.
I used to be able to access this db from my local computer as well - until today. It connects, but then shows access denied sql error 1044 for every possible action. (yes, external access is enabled)

What is going wrong?
Zoltán

johns

I tested this on my account and the feature is working overall. Can you verify which client you are using and which port it is configured to connect on? Have you verified the user ownership? On our platform you must select the read/write users by clicking on the HTML multi select form. We plan on improving this UI in the not so distant future.

Zka

Hello. I'm using HeidiSQL (windows native db client), connecting via 3306 port. User privileges are probably OK, as I said they are working fine through adminer and the web application. Also it used to work with HeidiSQL, but it suddenly stopped a few days ago. I didn't change anything afaik.

johns

Is it possible your ISP/Network provider is blocking the port? Does it work using the mysql command line if you specify the external host on the server directly?

Zka

Yep I can connect from command line just fine. As soon as I issue \use databasename, it says access denied. Even though my user CAN use that DB, it works from adminer and from the web app as well.

johns

Send us a support ticket so we can take a look at the account.