(1) Install the mysql :
slackpkg install mysql
notes: This command will install mysql program on the slackware and create "mysql" user and "mysql" group
(2) Creating the needed databases and setting their permissions
mysql_install_db --user=mysql
(3) Change the permission of the /etc/rc.d/rc.mysql file
chmod 755 /etc/rc.d/rc.mysql
(4) The mysqld is running now, you can login with "mysql" as below
mysql -u root -p
notes: -p options is necessary and the "mysql" password default is ""
(5) Delete where user="" localhost="localhost"
USE mysql;
SELECT usr, local from USER;
DELETE FROM USER WHERE host='localhost' AND user='';
(6) Chage "mysql" password as system root
/usr/bin/mysql_secure_installation
Adding the utf8_unicode_ci support
vi /etc/my.cnf
vi /etc/my.cnf
### Adding following lines to the 'mysqld' section
collation-server = utf8_unicode_ci
init-connect = 'SET NAMES utf8'
character-set-server = utf8
If you want using mysql through network, modifying /etc/rc.d/rc.mysql, comments below line
# SKIP = "--skip-networking"
Troubleshooting
Method 1 : Server errors are written into the /var/lib/mysql/[yourhostname].err file
Method 2 : Directly run the server and direct the output to the console
/usr/bin/mysqld_safe --console