Skip to main content

How do I reinitialize MySQL or MariaDB without reinstalling the RPMs?

cPanelAaronH
  • Updated

Question

How do I reinitialize MySQL or MariaDB without reinstalling the RPMs?

 

Answer

Warning: The steps outlined in this guide move the existing data. You will need cPanel backups or SQL dumps in order to restore your account databases through the cPanel interface or the MySQL command-line once MySQL or MariaDB has been initialized. We recommend reading through this guide in its entirety before starting the process.

cPanel support cannot assist you with these steps, and we do recommend consulting with a qualified system administrator before proceeding.

To reinitialize MySQL, perform the following steps:

MySQL

  1. Disable the service monitoring:

    # whmapi1 configureservice service=mysql enabled=1 monitored=0

  2. Stop the service:

    # /scripts/restartsrv_mysql --stop

  3. Check to make sure you have enough disk space to safely process the data restore. It is recommended to have over double the current MySQL data directory usage in free space. 

    du will show the total usage of the MySQL data directory:

    # du -hs /var/lib/mysql

    df will show the total disk usage and free space for the disk the MySQL data directory is located on:

    # df -h /var/lib/mysql

  4. Move the directory containing MySQL. If your home data directory for MySQL is different, adjust the path accordingly:

    # mv /var/lib/mysql{,.cPbak} -v && mkdir -v /var/lib/mysql && chown -v mysql. /var/lib/mysql

  5. Run the initialize option for MySQL:

    # mysqld --initialize --user=mysql

  6. Restart MySQL again:

    # /scripts/restartsrv_mysql --start

  7. Re-enable the monitoring service:

    # whmapi1 configureservice service=mysql enabled=1 monitored=1

  8. Reset the MySQL password:

    # /scripts/mysqlconnectioncheck

  9. Disable the validate_password plugin option. To do this, refer to this article:

    MySQL "Your password does not satisfy the current policy requirements"

  10. Restore the databases:

  11. Restore the grants:

    How to Restore Database Grants

  12. Restore database access:

    How to Restore a User's Database Access

MariaDB

  1. Disable the service monitoring:

    # whmapi1 configureservice service=mysql enabled=1 monitored=0

  2. Stop the service:

    # /scripts/restartsrv_mysql --stop

  3. Check to make sure you have enough disk space to safely process the data restore. It is recommended to have over double the current MariaDB data directory usage in free space. 

    du will show the total usage of the MariaDB data directory:

    # du -hs /var/lib/mysql

    df will show the total disk usage and free space for the disk the MariaDB data directory is located on:

    # df -h /var/lib/mysql

  4. Move the directory containing MariaDB. If your home data directory for MariaDB is different, adjust the path accordingly:

    # mv /var/lib/mysql{,.cPbak} -v && mkdir -v /var/lib/mysql && chown -v mysql. /var/lib/mysql

  5. Run the initialize option for MariaDB:

    # mariadb-install-db --user=mysql

  6. Restart MariaDB again:

    # /scripts/restartsrv_mysql

  7. Re-enable the monitoring service:

    # whmapi1 configureservice service=mysql enabled=1 monitored=1

  8. Reset the MariaDB password:

    # /scripts/mysqlconnectioncheck

  9. Disable the validate_password plugin option. To do this, refer to this article:

    MySQL "Your password does not satisfy the current policy requirements"

  10. Restore the databases:

  11. Restore the grants:

    How to Restore Database Grants

  12. Restore database access:

    How to Restore a User's Database Access

If the system runs CloudLinux, run the following two commands as well:

# cagefsctl -M

# cagefsctl --force-update

 

Additional Resources

System Administration Services

Related articles

Comments

0 comments

Article is closed for comments.