MySql Online
Posted by: DuckCraftPvP (---.ded.execulink.com)
Date: March 22, 2017 08:07PM

Hi, So i am trying to access my mysql database from another ip and it wont let me, I have put
bind-address = 0.0.0.0 in my.ini and i have set firewall up to allow incoming connection to it and i still can't access the mysql database. Any suggestions or ideas?

Any help would be awesome.

Options: ReplyQuote
Re: MySql Online
Posted by: RiggsFolly (Moderator)
Date: March 23, 2017 12:41AM

Hi

By default all the MySQL user accounts are setup to only allow access from the PC running MySQL (localhost) for obvious security reasons.

Are you trying to use phpMyAdmin or something similiar from the other machine or are you trying to use a one of your web sites to access MySQL?

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>

Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

Options: ReplyQuote


Sorry, only registered users may post in this forum.