Trying to connect from one host to another with Mariadb

If none of the more specific forums is the right place to ask

Trying to connect from one host to another with Mariadb

Postby lonesoac0 » 2017-12-16 19:14

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?
lonesoac0
 
Posts: 2
Joined: 2017-12-16 19:01

Re: Trying to connect from one host to another with Mariadb

Postby GarryRicketson » 2017-12-16 20:46

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 ?
"What we expect you have already Done"

Before doing anything, read the Debian documentation:
Debian Documentation
How to ask the smart way
Debian Foro Español
======================
For the Birds
User avatar
GarryRicketson
 
Posts: 4590
Joined: 2015-01-20 22:16
Location: Durango, Mexico

Re: Trying to connect from one host to another with Mariadb

Postby lonesoac0 » 2017-12-16 23:28

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.
lonesoac0
 
Posts: 2
Joined: 2017-12-16 19:01

Re: Trying to connect from one host to another with Mariadb

Postby jmgibson1981 » 2017-12-19 12:19

Try
Code: Select all
systemctl status mariadb
Will get you more info.
jmgibson1981
 
Posts: 38
Joined: 2015-06-07 14:38


Return to General Questions

Who is online

Users browsing this forum: No registered users and 10 guests

fashionable