Joomla - Quick Installation (cli)

for development

Requirements

Apache or Nginx, MySQL/MariaDB and PHP-FPM are installed and configured to forward php-files to php-fpm or handle them via Modules.

Installation

Assuming "www" is your Apache Docroot,

1. create a new subdir: 
   mkdir www/joomla
2. Extract the files
   unzip Downloads/Joomla_4.2.5-Stable-Full_Package.zip -d www/joomla/
3. Edit the configuration.php and move it to your server root
    

           public $dbtype = 'mysqli';               // Normally mysqli
           public $host = 'localhost';              // This is normally set to localhost
           public $user = 'root';                       // Database username
           public $password = 'root';                   // Database password
           public $db = 'joomla';                         // Database name

    

4. Edit sql files for prefixing tables correctly.
   sed -i 's/#__/jos_/g' installation/sql/mysql/*.sql
5. Create the Db and import tables:
   cd www/joomla

   mysqladmin -u root -p create joomla
   mysql -u root -p joomla -e 'SOURCE installation/sql/mysql/base.sql;'
   mysql -u root -p joomla -e 'SOURCE installation/sql/mysql/extensions.sql;'
   mysql -u root -p joomla -e 'SOURCE installation/sql/mysql/supports.sql;'

    

6. Create Admin-User

   INSERT INTO `js_users` (`name`, `username`, `password`, `params`, `registerDate`, `lastvisitDate`, `lastResetTime`) VALUES ('Administrator2', 'admin2', 'd2064d358136996bd22421584a7cb33e:trd7TvKHx6dMeoMmBVxYmg0vuXEA4199', '', NOW(), NOW(), NOW());
   
   INSERT INTO `jos_user_usergroup_map` (`user_id`,`group_id`) VALUES (LAST_INSERT_ID(),'8');

   Username: admin2
   Password: secret

7. Access via http://localhost/joomla or create a vhost