Install MySQL from the official Slackware discs or using slackpkg. If you performed a full install of Slackware, then you already have MySQL on your computer.
root@darkstar# mysql_install_db --user=mysql
The user specified by –user
will own the database files, so it's important to set the right user here, otherwise MySQL won't be able to write to your databases. By default MySQL in Slackware runs as user “mysql”, so that is the safe choice.
root@darkstar# chmod 755 /etc/rc.d/rc.mysqld
/etc/rc.d/rc.mysqld
: #SKIP="--skip-networking"
root@darkstar# /etc/rc.d/rc.mysqld start
and proceed to the next section “Securing MySQL”.
root@darkstar# /usr/bin/mysql_secure_installation
The initial root password is “” (the empty string), so just hit ENTER when the above command asks for the password
root@darkstar# mysqladmin -u root password 'new-password-here'
If you enabled networking, you should also run this command:
root@darkstar# mysqladmin -u root -h 'your-hostname' password 'new-password'
mysql_install_db
results, these commands are printed, you can copy/paste them. The hostname will already be replaced by yours.
user@darkstar$ mysql -u root -p
mysql> use mysql mysql> SELECT user, host FROM user; mysql> DELETE FROM user WHERE host='localhost' AND user='';
mysql> use mysql mysql> SELECT user, host FROM user; mysql> DELETE FROM user WHERE user='';
/etc/
directory, and select the configuration which you prefer. For a “simple” database service without heavy MySQL load, it is recommended to use “my-large.cnf
” if you have 2 GB of RAM or more. Copy the configuration file you chose and name the copy /etc/my.cnf
./etc/my.cnf
adding these lines in the section “[mysqld]
”: [mysqld] collation-server = utf8_unicode_ci init-connect='SET NAMES utf8' character-set-server = utf8
This gives you full UTF8 support in your MySQL server, after you restarted it.
More on Unicode / UTF8 character set support is described here: http://stackoverflow.com/questions/3513773/change-mysql-default-character-set-to-utf8-in-my-cnf
/var/lib/mysql/<hostname>.err
. Another option is to run the server directly and direct the output to the console (use Ctrl+\ to stop the server). Run: root@darkstar# /usr/bin/mysqld_safe --console
UPDATE mysql.user SET Password=PASSWORD('MyNewPass') WHERE USER='root'; FLUSH PRIVILEGES;
Save this file (any name would do) and start the server with the –init-file argument:
root@darkstar# /usr/bin/mysqld_safe --defaults-file="new_cnf_file.cnf"