IP Blocked remote access mysql linux debian

Question

I’m making the following mistake: [exec] mysqladmin: connect to server at '179.111.225.163' failed [exec] error: 'Access denied for user 'rqtecnologia'@'177.21.38.34' (using password: YES)'

• I’ve already changed the user password
• already went to the file my.cnf commented the line bind-address = 0.0.0.0, the line Skip-networking is already disabled.
• already enabled iptables firewall for mysql port and ip number
• I have already given all privileges to the user, the same is as rqtecnology %

Does anyone have any suggestions please, because I don’t know what else to try.

Answer 1

Log in to the MYSQL server via SSH:

ssh root@servidormysql

Log in to your MYSQL server:

mysql -u root -p

Give permissions to the user rqtecnologia connect to bank teste1:

GRANT ALL PRIVILEGES ON teste1.* TO 'rqtecnologia'@'177.21.38.34' IDENTIFIED BY 'senhadousuário';


flush privileges;

https://dev.mysql.com/doc/refman/5.5/en/privilege-system.html

Answer 2

You have root access to this database?

If yes install mysql Workbench and connect to your server with root user. In the user area, probably this user will be limited to a host "localhost" or "127.0.0.1", in this field you put "%" to fully release, but I advise you to create a new user with the same permissions and in the host put only the ip "177.21.38.34" which is the ip you are trying to access.

You only have to remember to change in case the ip changes.

If use phpMyAdmin just go to users you will have access to mysql users too.

Remembering in case of phpmyadmin never change the user "root".