I need your inputs guys, i have a MSACCESS Forms as frontend & i am able to connect to the DB in localhost, but if ako siya e install sa lain nga station/PC mo error, ako ge entry sa TCP/IP Server: "ip sa server" pero mao ni mo gawas Host 'clientPCsNAME' is not allowed to connect to this server
opps.. sorry solved dayon mga mods.. palihug na lang kog close. i forgot to configure privileges
Solution:
1.) Create a User in phpMyAdmin with all privileges
-login to phpmyadmin cpanel
-goto Privileges Tab
-put/tick/select /check sa root | localhost
-click edit privileges (icon with a man & a pencil)
-it will bring you to Edit Privileges: User 'root'@'localhost'
-do not change anything yet
-scroll down to the bottom
-you will find a section " Change Login Information / Copy User "
-in the field Host: the default value is Local change it to Any host, maka notice ka nga ang value mahimong % leave it that way, dont worry dili na mausab imong default user nga root@localhost
-supply ur desired password then click go
thats it, your done.. the only thing you have to do now is to point to the Server Ip Address.