Problems with phpMyAdmin UolHost [duplicate]

-2

I have a site in the host uol and a database as well, the site communicates perfectly with mySql, but I have a desktop software that I need to communicate with mySql also, is there any configuration that I need to adjust so that mySql allow this desktop software to connect with it? because I can not make this communication. If anyone can help thank you.

    
asked by anonymous 20.12.2017 / 01:41

1 answer

1

I believe that UOL Host should release remote access (if they allow it) to you on your user, if you have access with necessary privileges, you can set remote access by running the following SQL:

GRANT ALL ON . TO myuser @ 'SEUIP' IDENTIFIED By 'password';

Releasing to any ip access the bank with password using% (not recommended)

GRANT ALL ON . TO myuser @ '%' IDENTIFIED By 'password';

In the mysql config file you should allow access to the "public" ip something like:

/etc/mysql/my.cnf

bind-address = 0.0.0.0

I believe that your hosting is shared should UOL Host release the remote access (if it is allowed), if you are the administrator of the bank, you must make the above settings.

    
20.12.2017 / 02:15