This HowTo describes simplified instruction for installing Joomla 2.5 content management system in Slackware 14.0. For more complex instructions you may want to read …

• start conditions is freshly installed Slackware 14.0 with option “Full install”.
• In configuring stage you choose to automatically start applications “apache” (rc.httpd) and “MySQL” (rc.mysqld)

1. Copy with rename /etc/mysql/my-large.cnf or another file from that directory, who meet your requirements, to /etc/my.cnf
2. Edit that /etc.my.cnf to add three lines after [mysqld], as there:

   [mysqld]
   collation-server = utf8_unicode_ci
   init-connect='SET NAMES utf8'
   character-set-server = utf8
    

3. After that, restart MySQL server.
4. Do as root

   mysql_install_db --user=mysql 

5. Do as root

    mysql_secure_installation 

   , and set mysql root password ( and write it down or remember), and choose all default answers

6. After that, do

    mysql -u root -p 

   after write user password, be in mysql>. write

    CREATE USER 'joomla_db_username'@'localhost' IDENTIFIED BY 'joomla_db_user_password'; 

   , where joomla_db_user is user, who you make for under who your joomla stores information in mysql. joomla_db_user_paswword is your choosing password for that mysql user.

7. write

    GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP ON yourdatabasename_for_joomla.* to 'joomla_db_username'@'localhost'; 

8. after that do

    FLUSH PRIVILEGES;

   and then

    quit

9. and finally, do from bash

    mysqladmin -u joomla_db_username -p create yourdatabasename_for_joomla 

   it need input of your “joomla_db_username” password, seems as “joomla_db_user_password” in that instruction.

10. That's all, your MySQL will be ready to install and configure Joomla.

that is unfinished howto. i finish it with two days….

* Original source: http://stackoverflow.com/questions/3513773/change-mysql-default-character-set-to-utf8-in-my-cnfMySQL config to UTF8 support.

— John Ciemgals 2013/02/12 06:00