1. sudo mysql_install_db : when “Can’t open and lock privilege tables: Table ‘mysql.servers’ doesn’t exist” occurs.

  2. Install apache, mariadb, phpmyadmin, mysql and everything

  3. Starting apache server:

       sudo systemctl enable httpd.service
   sudo systemctl start httpd.service
    • Also can check status as well.

  4. After installing mariadb: run

       mariadb-install-db --user=mysql --basedir=/usr --datadir=/var/lib/mysql
   sudo systemctl restart mariadb.service

  5. Create wordpress database and user using mysql shell rather than phpmyadmin

       su
   mysql -u root -p

  6. In mysql shell: [ Change strong_password first ]

           CREATE DATABASE wordpress;
       GRANT ALL PRIVILEGES ON wordpress.* TO "wp-user"@"localhost" IDENTIFIED BY "strong_password";
       FLUSH PRIVILEGES;
       exit;

  7. Go to /etc/httpd/conf/httpd.conf

    1. Search for <Ifmodule dir_module> and add index.php along with index.html there.

  8. If size limit errors:

    • Install a size increasing plugin available on wordpress. It works fine. I tried changing it in php.ini file and wp-config.php file but could not so I think you just go to the plugin rather than wasting time here and there.

  9. Note:

    1. If you have backups using All in one wp module , then there is a tool named traktor which can extract .wpress files directly and you can upload it to ftp then.