Problem You get the following error when executing scripts ERROR 1820 (HY000) at line 20: You must reset your password
Tag: mysql
MySQL – Root password after new installation
Problem Immediately after installing MySQL you attempt to log in with the system root or admin account but it fails,
MySQL – Start and status in Linux/Unix
To quickly view your status try the following commands sudo /etc/init.d/mysql status To stop or start issue one of the
MySQL – Repair and optimize tables
Repair and optimize all tables After upgrading the MySQL server there are times when weird bugs would be seen with
MySQL- Backup and or Restore your MySQL Database Using phpMyAdmin
How to Backup and or Restore your MySQL Database Using phpMyAdmin Backup your MySQL Database Log into your hosting or
MySQL – Dump all databases
If you ever need to backup all your MySQL databases at the same time use the following command mysqldump -u
MySQL – “unknown” architecture (Windows)
Problem You need to upgrade your MySQL but the state/status is MySQL 5.x has “unknown” architecture Solution Download and run
MySQL – restore databases (command line – Linux)
Methods of restoring MySQL databases To restore a MySQL database you can use one of the following methods after creating
MySQL – Retrieve “lost” MySQL user name and password (Unix/Linux)
Problem You are trying to log into MySQL but you have the wrong credentials and need admin/root access Solution To
WordPress login password reset
Problem You cannot remember your password for your wordpress site, but you do have access to the PHPMySQL admin or