ssh - Migrate MySql Database To New Server -
I have exported my database in a .sql file.
When I try and upload it comes to my new server because the user is denied access to 'username' @ '%'. The original database is called 'originalUsername_databaseName', as it seems that the new server requires the prefix 'Admin _'
I'm sure this is the name of the database due to which the error is happening Is there a way to change?
Make sure that your SQL file is not built-in database and the statement is not used.
If this happens, remove them.
Create the database manually and import the table for it.
Comments
Post a Comment