I'm having an issue with mysql. I am trying to allow remote access. I found that if I write in my.cnf:
It works remotely, but using a php script that tries to access the database using the same ip doesn't work anymore!
If I remove this line, I can connect locally, but not remotely.
I tried setting it to 0.0.0.0, which has the same effect as if it were not there at all.
I saw that you can't bind to multiple addresses unfortunately. Any way to resolve?
MYSQL User accounts have 2 parts
So you need to create a new user account, you dont want to give access to the
root id externally, and make this new userid allowed to connect from either a specific ip address (more secure) or any ip address
From the command line
mysql.exe processor you woudl do this
CREATE USER 'somone'@'126.96.36.199' IDENTIFIED BY 'mypass';
for a specific ip address
CREATE USER 'somone'@'%' IDENTIFIED BY 'mypass';
To allow access from any ip adddress in the universe, so better make the password a good strong one
Then you allocate privilages to one or more databases to this new account
GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP ON database_name.* TO 'someone'@'%';