mysql Need help with Mysql Remote User

[Guest]

My Remote user: 192.168.0.112 (windows, PHP with mysqli)

My Mysql Server (ubuntu 20.04 lts) 192.168.0.105\

 

My Commands i have run so far:

 

CREATE DATABASE web_search;

 

USE web_search;

 

CREATE TABLE IF NOT EXISTS `web_info` ( `id` int(11) NOT NULL, `meta_title` varchar(100) NOT NULL, `meta_description` varchar(300) NOT NULL, `site_url` varchar(300) NOT NULL, `platform` varchar(300) NOT NULL ) ENGINE=InnoDB AUTO_INCREMENT=199 DEFAULT CHARSET=latin1;

 

CREATE USER 'remote4'@'192.168.0.112' IDENTIFIED BY 'mypass';

 

GRANT ALL PRIVILEGES ON web_search.* TO 'remote4'@'192.168.0.112';

 

I get the Error "actively refused connection"

 

On my Config.php:

 

<?php  

   $user = 'remote3'; 

   $password = 'mylegitpasswod''; 

   $database = 'web_search'; 

   $db = new mysqli('192.168.0.105',$user,$password,$database,3306); 

 ?>

 

my error 

[jj9987]

MySQL listens by default only on localhost. Have you configured it to listen on all interfaces (or localhost + w/e interface you have)?

Second option is server's firewall. Is there one, is it active, is port 3306/tcp allowed through it?

[Guest]

Just now, jj9987 said:

MySQL listens by default only on localhost. Have you configured it to listen on all interfaces (or localhost + w/e interface you have)?

Second option is server's firewall. Is there one, is it active, is port 3306/tcp allowed through it?

I dont use an Interface (if you mean to put items into mysql)

 

How do i Have mysql Listen on all Interfaces? 

 

3306 is allowed 

[jj9987]

20 minutes ago, Nolanrulesroblox said:

I dont use an Interface (if you mean to put items into mysql)

 

How do i Have mysql Listen on all Interfaces? 

 

3306 is allowed 

Interface as in network interfaces that your server has/is connected to.

 

This guide is for MariaDB, but it's pretty much the same for MySQL - https://mariadb.com/kb/en/configuring-mariadb-for-remote-client-access/

[Guest]

2 hours ago, jj9987 said:

Interface as in network interfaces that your server has/is connected to.

 

This guide is for MariaDB, but it's pretty much the same for MySQL - https://mariadb.com/kb/en/configuring-mariadb-for-remote-client-access/

I have the bind-address already set to 0.0.0.0, still errors.

 

 

Update: I edited the Wrong Config, I was Editing a Dummy file the whole time (f)

Edited July 10, 2020 by Guest
Update...