Trying to connect from one host to another with Mariadb

[lonesoac0]

Hello all,

I am trying to connect to my MariaDB database from one Debian 9.0 machine to another. I have checked and checked the MariaDB configuration files and everything looks good on that end. The file of:

/etc/mysql/mariadb.conf.d/50-server.cnf

does not even have the

# skip-networking

line in it. I also changed the bind-ipaddress to 0.0.0.0. And Finally, I issued the command of:

Code: Select all

GRANT ALL on *.* to 'user_name'@'192.168.1.136' identified by 'password';

I also did a variation of the command in:

Code: Select all

GRANT ALL on *.* to 'user_name@192.168.1.136' identified by 'password';

and then

Code: Select all

Flush privileges

. I am starting to think that it is on the OS layer of things. Can anyone assist?

[GarryRicketson]

Have you tried using the -v (verbose)option, when you start or re-start it, that might show some errors that give you some clues.

Code: Select all

systemctl -v restart mysql 

Something like that,....
also what does

Code: Select all

systemctl status

show.

Use code boxes to show the out put please,... I can't help much because
I have not used mariadb on the newest Debian 9 , but on other older
Debian and Bsd versions, the -v gives a verose out put, when you start
the data base, and "status" shows what is going on , to some extent.

How are you connecting, I assume ssh ?

[lonesoac0]

First than you for your reply/help.

I tried:

Code: Select all

systemctl -v restart mysql

and

Code: Select all

systemctl -V restart mysql

and Debian did not know the -v option.

I performed the command of:

Code: Select all

systemctl status | grep mariadb

and it came back with:

Code: Select all

mariadb.service

so it looks like it is running.

[jmgibson1981]

Try

Code: Select all

systemctl status mariadb

Will get you more info.