setting up the mysql/mariadb database on slackware!

slackuj · 12-10-2022, 01:36 AM

Can anyone please guide me to setup the mysql/mariadb database server on my slackware?

Few weeks ago,I was practicing qt5 where I needed to access the mysql database.The qt5 documentation
suggested to use XAMPP for accessing mysql.I haven't tried XAMPP yet though.Because I want to run mysql
from scratch.I looked out for the documentation in mariadb and mysql websites,but I couldn't get the
job done.

Once again,I have stumbled into mysql while learning scripting.This was the thing that I always wanted to do.

I want to run mysql using terminal.

Please guide me to setup mysql(slackware uses mariadb if I am not wrong) on my slackware current.
I think I can learn mysql once I get to set it up.

Windu · 12-10-2022, 03:37 AM

Just follow the instructions in the boot script:
https://git.slackware.nl/current/tre...iadb/rc.mysqld

Also, see https://docs.slackware.com/howtos:da...b_on_slackware

keefaz · 12-10-2022, 11:43 AM

Running mysql_secure_installation after mysql_install_db --user=mysql is recommended (set up mysql root password, delete test db...)

Pithium · 12-10-2022, 03:10 PM

I always forget to enable networking in /etc/rc.d/rc.mysqld

Code:

# To start MariaDB automatically at boot, be sure this script is executable:
# chmod 755 /etc/rc.d/rc.mysqld

# Before you can run MariaDB, you must have a database.  To install an initial
# database, do this as root:
#
#   mysql_install_db --user=mysql
#
# Note that the mysql user must exist in /etc/passwd, and the created files
# will be owned by this dedicated user.  This is important, or else mysql
# (which runs as user "mysql") will not be able to write to the database
# later (this can be fixed with 'chown -R mysql.mysql /var/lib/mysql').
#
# To increase system security, consider using "mysql_secure_installation"
# as well.  For more information on this tool, please read:
#   man mysql_secure_installation

# 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"

This isn't mentioned in the wiki page and the amount of time I've spent pulling my hair out over this one is pretty embarassing.

truepatriot76 · 12-10-2022, 10:21 PM

You weren't the only one Pithium... it got me too.