Author: Steven Neiland
Published:

Warning: This blog entry was written two or more years ago. Therefore, it may contain broken links, out-dated or misleading content, or information that is just plain wrong. Please read on with caution.

The recent release of Slackware 14.1 comes with a few improvements. One of which is that it now uses MariaDB in place of MySQL. MariaDB is basically the same database as MySQL just not tied to Oracle in any way (it even still uses mysqld as its daemon name).

However when you start slackware you will still see an error that mysql could not be started.

mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
mysqld_safe mysqld from pid file /var/run/mysql/mysql.pid ended

Assuming that you selected to install the MySQL service when you setup slackware you are 99% the way to getting it up and running. Most of the configuration we had to do previously in slackware is unnecessary but there are still a few steps.

Step 1: Install system database

MariaDB still needs us to run the install script to setup its own internal database.

mysql_install_db

Step 2: Setup ownership permissions

Obviously will need to give the mysql user ownership of the required mysql files.

chown -R mysql.mysql /var/lib/mysql

Step 3: Start MariaDB

We can now start MariaDB

/etc/rc.d/rc.mysql start

Step 4: Setup Root user password

As a final step set a root user password.

mysqladmin -u root password '[new-password]'

Related Blog Postings

What Do You Think?

Reader Comments

JDelaporte's Gravatar
JDelaporte
Monday, June 16, 2014 at 4:04:38 PM EDT

Thanks for the article! It was helpful to get back to the basics. I was buried in errors trying to set up a MariaDB a few minutes ago. I found an additional hint that helped at digitalocean. I was getting InnoDB errors, and fixed them by adding the following to my.cnf:

# Added these two lines recommended by digitalocean.com
default-storage-engine=myisam
skip_innodb

Also, it worked for me to run the following command to create the database and set up ownership of the data directory simultaneously:
# mysql_install_db --user=mysql

Post a Comment

Comment Etiquette:

  • Please keep comments on-topic.
  • Please do not post unrelated questions or large chunks of code.
  • Please do not engage in flaming/abusive behaviour.
  • Comments that contain or appear to be advertisments, will not be published.
  • Comments that appear to be created for the purpose of linkbuilding to commercial sites will be removed.

We are all adults here so play nice.

*
*



Archives Blog Listing

Tag Listing

Learn CF In A Week

Treehouse

 
Fork me on GitHub