hi really this issue is troubling:
I exported the database structure using the phpmyadmin as harry.sql from my local system.now I went to company server/cpanel /mysql database.created a user with username and password. I would like to import this file and I tried the same way that I used to do in local server but it says Access denied for firstname.lastname@example.org some #1044 blah blah.
I have tried with already existing users and the privileges for all the users I tried as ALL Priveleges.I am able to access the server but not able to create tables and data structure.
Earlier there was a error with 'DEFAULT CHARACTER SET latin1 COLLATE latin1_general_ci' at line which when removed started saying of access denied.
Hope you might be knowing it.