Problems with phpMyAdmin Uolhost

Asked

Viewed 492 times

-1

I have a site on Uol host and a database too, the site communicates perfectly with mysql, but I have a desktop software that I need to communicate with mysql as well, Is there any configuration I need to adjust in order for mysql to allow this desktop software to connect with it? for I am not managing to make this communication. If anyone can help I thank you.

mysql phpmyadmin

  • At Hostinger you have to enable the connection outside of localhost, see if your provider also has this setting.

  • How is this done in the Hostinger? in phpMyAdmin itself?

1 answer

1


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

GRANT ALL ON . To meuuser@'SEUIP' IDENTIFIED By 'password';

Freeing for any ip access the bank with password using % (not recommended)

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

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

/etc/mysql/my.cnf

bind-address = 0.0.0.0

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

  • I got it, thank you.

Browser other questions tagged mysql phpmyadmin

You are not signed in. Login or sign up in order to post.