Any idea how to allow a remote connection? If this option is enable a user cannot create new MySQL users by using the GRANT statement unless the user has the INSERT privilege for the mysql. If you want a user to have the ability to create new users that have those privileges that the user has the right to grant, you should grant the user. I want to connect to mysql server using whatever ip I want.
The server has multiple ip address. The mysqld used by many websites hosted on two other CentOS Linux based servers. I trying to set alternate IP for gain access to MySQL Server (accessing from a PC with IP 196.20) in the file: my.
Based on your example, bind-address could be set to 202. IP addresses) should solve the problem. If the MySQL bind-address line is set to 0. Stack Exchange network consists of 1QA communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers. I am trying to configure my server to allow remote connections. From what I understand I need to uncomment bind-address 127.
Bind Address missing in my. MySQL , the bind-address line is not in the file. I thought would do the trick at the bottom. Some MariaDB packages bind MariaDB to 127.
Before going in to how to configure these.