Cannot connect to MySQL server

2000: mysqlnd cannot connect to MySQL 4.1+ using the old insecure authentication. Please use an administration tool to reset your password with the command SET PASSWORD = PASSWORD('your_existing_password'). This will store a new, and more secure, hash value in mysql.user. If this user is used in other scripts executed by PHP 5.2 or earlier you might need to remove the old-passwords flag from your my.cnf file

2002: No such file or directory

Please make sure of the following:
  • The MySQL credentials in the config.php file are correct.
  • Your MySQL server is installed and is up and running properly.
  • If you have recently updated the MySQL credentials in the config.php file, moved your store to another server, or updated the password of your hosting control panel (some control panels update the MySQL password automatically if you change the main password), make sure the MySQL credentials specified in your store's config.php file match the MySQL credentials provided by your hosting.