In the step where I need to restore the database.
Does the database which needs to be created on the new server has to have the same name/credentials as the old one being restored?
because I am getting
Error
SQL query:
--
-- Database: `xyz`
--
CREATE DATABASE `xyz` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
MySQL said: Documentation
#1044 - Access denied for user 'abc'@'10.%' to database 'xyz'
The reason why I used slightly different credentials because I was not able to create the database with the same credentials, I was getting
Database logins must be 2-16 characters in length. Database logins must consist of lowercase letters, numbers, and underscores with at least one non-numeric character.
I created a database with the "same" credentials but at importing I am getting
Error
SQL query:
--
-- Database: `xyz`
--
CREATE DATABASE `xyz` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;