Problem of Denied Permissions in connection between PHP and MYSQL

Question

I am trying to connect a CRUD Simple with PHP, connecting a database in MySQL. The problem is that in the mysql_connect function, in the host variable, if I pass the String localhost, it connects and shows me the information of the database. The problem is when I put the IP of the host where the MySQL database is located, it shows me Permission denied. I already send the privileges to the user carlos with the following command:

GRANT ALL PRIVILEGES ON * . * TO 'carlos'@'%';

This is the connection code, the rest of the code does not affect, since this set are the first lines of the program:

$link = mysqli_connect("192.168.0.18:3306", "carlos", "abc123", "distribuidos") or die ('Error. ' . mysqli_connect_error());

With localhost, the connection work:

$link = mysqli_connect("localhost", "carlos", "abc123", "distribuidos") or die ('Error. ' . mysqli_connect_error());

It should be noted that I have also configured the firewall with the ports already open, in this case 3306, and if I connect with the command mysql -u carlos -h 192.168.0.18 -p from another machine connects me without problem.

I am using php 7.3 and CentOS 7.

SOLUTION

My solution is execute the next command on Linux: sudo setsebool -P httpd_can_network_connect 1

snfrox · Accepted Answer · 2019-03-07 07:28:09Z

1

Three things you can check

Please check your port is open or not

or

Remove bind-address 127.0.0.1 in /etc/mysql/my.cnf

or

apache is not configured for external access. try sudo setsebool -P httpd_can_network_connect 1

edited Mar 7, 2019 at 7:28

answered Mar 7, 2019 at 6:04

snfrox

1247 bronze badges

Sign up to request clarification or add additional context in comments.

12 Comments

snfrox Over a year ago

is this your mysql server ip address. if so it's wrong, you can either put 0.0.0.0 to allow any network or the sub net address to specifically give access to a network

snfrox Over a year ago

read this for more details about bind address stackoverflow.com/questions/3552680/…

Garnica1999 Over a year ago

Now change the IP to 0.0.0.0, But still with the same error, I do not know what to do anymore

snfrox Over a year ago

did you restart the service?

Garnica1999 Over a year ago

Yes, i restart the mysqld and httpd services, but the mysql connection not work.

|

Collectives™ on Stack Overflow

Problem of Denied Permissions in connection between PHP and MYSQL

1 Answer 1

12 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

12 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related