MySQL

If you aren’t familiar with using the command line interface, using cPanel makes it easy to change MySQL user passwords.

Master phpMyAdmin with our guides. Learn to import/export data, manage users, run queries, and optimize your database with this powerful web interface.

Your hub for MySQL administration. Find tutorials on installation, user management, backups, optimization, and troubleshooting to master your database.

Learn to use MySQL commands as root on a Plesk Linux server, understand /etc/psa/.psa.shadow, and set up passwordless MySQL access via /root/.my.cnf.

Install MySQL Community on new AlmaLinux 8. *NEW SERVERS ONLY* (data loss risk). Steps: prep, repo, install, secure.

Safely upgrade MySQL/MariaDB: Step-by-step guide for Core Managed servers. Includes pre-checks, backups (`rsync`, `mysqldump`), upgrade & follow-up.

Fix InterWorx “replyCode: 500” on MySQL DB/user creation. Issue: empty MySQL user. Guide: diagnose via iworx.log, then remove from `mysql.user`.

MySQL troubleshooting guide: Resolve DB corruption, connection problems, full disks, remote access, & advanced errors.

Move MySQL `datadir`: Step-by-step guide using `rsync`, symlinks, & `my.cnf` updates. Includes CloudLinux notes & critical backup advice.

MySQL Stored Procedures: Check for routines & ensure they’re in `mysqldump` backups using `–routines`. cPanel’s `/scripts/pkgacct` handles this.

MySQL command guide: Data dump/restore, password management, admin tasks (upgrades, root reset, slow log) & datadir/tmpdir setup.

MySQL batch table engine conversion: MyISAM <=> InnoDB. Get CLI scripts, rollback prep, & robust methods. *Always backup data first!*