LinuxQuestions.org
Latest LQ Deal: Latest LQ Deals
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Distributions > Slackware
User Name
Password
Slackware This Forum is for the discussion of Slackware Linux.

Notices


Reply
  Search this Thread
Old 04-12-2021, 02:03 PM   #1
zdolar
Member
 
Registered: Jul 2009
Location: Slovenija
Distribution: Slackware
Posts: 177

Rep: Reputation: 38
mariadb networked slackware-64-current


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-address
in 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 found
How can I enable mariadb network connections and prove it is working?

Last edited by zdolar; 04-12-2021 at 02:11 PM.
 
Old 04-12-2021, 02:26 PM   #2
Martinus2u
Member
 
Registered: Apr 2010
Distribution: Slackware
Posts: 497

Rep: Reputation: 119Reputation: 119
in /etc/rc.d/rc.mysqld, did you modify

Code:
# To allow outside connections to the database comment out the next line.
# If you don't need incoming network connections, then leave the line
# uncommented to improve system security.
#SKIP="--skip-networking"
 
1 members found this post helpful.
Old 04-13-2021, 04:04 AM   #3
zdolar
Member
 
Registered: Jul 2009
Location: Slovenija
Distribution: Slackware
Posts: 177

Original Poster
Rep: Reputation: 38
Quote:
Originally Posted by Martinus2u View Post
in /etc/rc.d/rc.mysqld, did you modify

Code:
# To allow outside connections to the database comment out the next line.
# If you don't need incoming network connections, then leave the line
# uncommented to improve system security.
#SKIP="--skip-networking"
Thank you Martinus2u!

Fast and easy solution.

Mysql/Mariadb specific settings are domain of /etc/my.cnf & /etc/my.cnf.d/* as per the manuals.
So why this setting is in rc.d script? Did not even think about looking there.
Strange for Pat put it there. Must had a huge reason to make it nonstandard.
 
Old 04-13-2021, 10:04 AM   #4
bassmadrigal
LQ Guru
 
Registered: Nov 2003
Location: West Jordan, UT, USA
Distribution: Slackware
Posts: 8,792

Rep: Reputation: 6656Reputation: 6656Reputation: 6656Reputation: 6656Reputation: 6656Reputation: 6656Reputation: 6656Reputation: 6656Reputation: 6656Reputation: 6656Reputation: 6656
Quote:
Originally Posted by zdolar View Post
Mysql/Mariadb specific settings are domain of /etc/my.cnf & /etc/my.cnf.d/* as per the manuals.
So why this setting is in rc.d script? Did not even think about looking there.
Strange for Pat put it there. Must had a huge reason to make it nonstandard.
Not knowing the details but looking at the rc script, it might be that it isn't something that's configurable in a conf file and has to be used as a launch option on the commandline.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
LXer: KDE Participating in Google Summer of Code 2019, MariaDB Releasing New Open-Source MariaDB Enterprise Server, CentOS Celebrates 15th B LXer Syndicated Linux News 0 02-28-2019 06:50 AM
[SOLVED] akonadi mysql mariadb kmail korganizer trouble on current and with kde4 and kde5 mrapathy Slackware 8 10-28-2017 08:43 AM
[SOLVED] MariaDB TokuDB plugin load issue in current. matusz Slackware 1 09-05-2017 12:06 AM
[SOLVED] current, akonadi, mariadb, mysql and kmail pchristy Slackware 4 03-17-2016 06:43 AM
Networked computer can't see page served from other Networked computer Travis86 Linux - Networking 2 12-30-2002 01:38 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Distributions > Slackware

All times are GMT -5. The time now is 03:11 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration