MariaDB

Connexion MarinaDB

Pré configuration

1st Step

add file: my.cnf

/var/packages/MariaDB/etc/my.cnf

[mysqld]
skip-networking=0
skip-bind-address

2nd Step

Enter mariaDB by:

mysql --host=IP-Address -u root -p

Grant localhost access to Server:

GRANT ALL PRIVILEGES ON . TO ‘root’@‘Localhost-IP’ IDENTIFIED BY ‘password’ WITH GRANT OPTION;
FLUSH PRIVILEGES;

3rd Step

//Check user by: 
SELECT User, Host FROM mysql.user WHERE Host <> ‘localhost’;

• DigiKam
• 2021-07-11
• 2021-07-14