Steps to Install mysql in slackware 12.0

1. Download mysql package: mysql-5.0.51b-i486-1.tgz for slackware or copy it from your Slackware DVD ( …/source/ap/mysql/mysql-5.0.51b-i486-1.tgz)

2. Install package:

#installpkg mysql-5.0.51b-i486-1.tgz

3. Copy /etc/my-medium.cnf to /etc/my.cnf

#cp /etc/my-medium.cnf /etc/my.cnf

4. Install DB

#mysql_install_db

5. Make mysql user in mysql group (if not existed)

#groupadd mysql

#useradd -g mysql mysql

6. Make mysql is owner of /var/lib/mysql

#chown -R mysql /var/lib/mysql

7. Start your mysql server 

cd /etc/rc.d

#./rc.mysqld start

8. Change root password

#mysqladmin -u root -p ‘yourpassword’

If you want to access your mysql server remotely:

9. Comment line: SKIP=–skip-networking on /ect/rc.d/rc.mysqld  and comment skip-networking in /etc/my.cnf (open port 3306)

10. Configure to mysql database (make mysql server allow you to connect to)

GRANT ALL PRIVILEGES ON *.* to ‘root@yourremotehost’ identified by ‘yourpassword’ 

 

Have a nice installation.