mariadb networked slackware-64-current
by zdolar from LinuxQuestions.org on (#5GG7B)
Hi.
Slackware64-current updated regulary.
Mariadb works excellent locally.
I wish to access it over network and Mariadb manual failed to work.
Mariadb after following the above manual do not work over network.
I've created a mariadb user with network access - 'user'@'%' with correct grants.
Putting:
Code:[mysqld]
skip-networking=0
skip-bind-addressin any of:
/etc/my.cnf
/etc/my.cnf.d/server.cnf
do not enable network - port 3306 is not open.
And a naming mess - mariadb or mysqldb?
There are two services mysqld_safe and mariadb.
and all /usr/bin/mysql* are linked to mariadb* equivalents.
and rc.mysqld - instead rc.mariadb
Why?
After a long time mariadb existence mysql should vanish by now.
Mariadb manual mentioned above states:
Code:mysqld --print-defaults should return status:
Code:./sql/mysqld would have been started with the following arguments:
--bind-address=127.0.0.1 --innodb_file_per_table=ON --server-id=1 --skip-bind-address ...But on Slackware64-current there is no mysqld service, instead maridbd service:
Code:root@ProBook ps -ae| grep mari
1181 ? 00:00:00 mariadbd
root@ProBook mariadbd --print-default
bash: mariadbd: command not foundHow can I enable mariadb network connections and prove it is working?
Slackware64-current updated regulary.
Mariadb works excellent locally.
I wish to access it over network and Mariadb manual failed to work.
Mariadb after following the above manual do not work over network.
I've created a mariadb user with network access - 'user'@'%' with correct grants.
Putting:
Code:[mysqld]
skip-networking=0
skip-bind-addressin any of:
/etc/my.cnf
/etc/my.cnf.d/server.cnf
do not enable network - port 3306 is not open.
And a naming mess - mariadb or mysqldb?
There are two services mysqld_safe and mariadb.
and all /usr/bin/mysql* are linked to mariadb* equivalents.
and rc.mysqld - instead rc.mariadb
Why?
After a long time mariadb existence mysql should vanish by now.
Mariadb manual mentioned above states:
Code:mysqld --print-defaults should return status:
Code:./sql/mysqld would have been started with the following arguments:
--bind-address=127.0.0.1 --innodb_file_per_table=ON --server-id=1 --skip-bind-address ...But on Slackware64-current there is no mysqld service, instead maridbd service:
Code:root@ProBook ps -ae| grep mari
1181 ? 00:00:00 mariadbd
root@ProBook mariadbd --print-default
bash: mariadbd: command not foundHow can I enable mariadb network connections and prove it is working?