How to install MySQL

From Salix OS
Jump to: navigation, search

Original Source:

In this guide we will discuss how to install MySQL into a 'full' version of Salix and configure it.



MySQL is not installed with the default full installation. To check if it is installed, the following command should return a folder:

ls /var/run/ | grep mysql

If it is not installed:

slapt-get -u
slapt-get -i mysql

Salix - Configure Users and Permissions

A full installation is already configured with the group 'mysql' and the user 'mysql'.

If your installation is not properly configured, refer to the source document for instructions.

MySQL - Configure and Start

You have to create a new mysql configuration file called my.cnf. This can be done easily by copying the example (existing) configuration

files in the /etc directory. You can view all available mysql configuration files in /etc directory using grep command. See the example


ls -l /etc/ | grep my
cp /etc/my-medium.cnf /etc/my.cnf

Create the default mysql databases:

mysql_install_db --user=mysql

Start the mysql server:

/usr/bin/mysqld_safe &

To start mysql daemon at boot time, open Settings > Start-up Services and activate mysql.

MySQL - Create Root User

Create password for mysql root user:

/usr/bin/mysqladmin -u root password '??????????'

Alternatively, there is a tool that configures some basic security for mysql including setting the root password. This tool can be run at

any time.


That's it. The mysql server is ready.

MySQL - Test

You can login and view existing databases to ensure that your MySQL is working.

mysql -u root -p
SHOW databases;