IP Blocked remote access mysql linux debian

0

I have the following error: [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
  • I was already in the file my.cnf I commented the line bind-address = 0.0.0.0, the skip-networking line is already disabled.
  • already enabled iptables firewall for mysql port and ip number
  • I have given all the privileges to the user, the same is like technology%

Someone has some suggestions please, because I do not know what to try anymore.

    
asked by anonymous 05.10.2016 / 12:59

2 answers

1

Log in to MYSQL server via SSH:

ssh root@servidormysql

Log in to your MYSQL server:

mysql -u root -p

Give permissions for user rqtecnologia connect to bank teste1 :

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


flush privileges;

link

    
13.10.2016 / 04:10
0

Do you have root access to this database?

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

You just have to remember to change if ip changes.

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

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

    
05.10.2016 / 14:01