I Need Help Transferring Sql Database?

[jjaenagle 0]

ok so i am trying to transfer mediawiki's but i am having trouble with exporting importing the database.

I am using phpmyadmin on both sides of the hosts. When i do the import i get this.

SQL query:
--
-- Database: `apolopedia`
--
CREATE DATABASE `apolopedia` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;

MySQL said: Documentation
#1044 - Access denied for user 'jaenagle'@'localhost' to database 'apolopedia'

I tried to give my user all rights, but it gave me this also.

SQL query:
GRANT ALL PRIVILEGES ON * . * TO 'jjaenagle'@'%' WITH GRANT OPTION MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;

MySQL said: Documentation
#1045 - Access denied for user 'jjaenagle'@'%' (using password: YES)

Do you guys have any advice?

[sonesay 7]

It appears you do not have the right privileges. If you have no control of setting it i.e your using MYSQL on a remote host you have little or no control over then you cant do much about it.

[jjaenagle 0]

can i contact the admins and see if they can grant me privileges? what do i need to do?im very new to this. i have asked the same question in their forum so hopefully, someone can help me out.

[jlhaslip 4]

The database user name is always prefixed with your cpanel name and an underscore. example: my Cpanel name is jimbo and it causes the db_username to have a prefix of jimbo_ (with the underscore).In the configuration file for the script being installed, or in an SQL command like above, I would use the db user-name of jimbo_username to access the DB where username is the user for that db.. You appear to be missing either the prefix or the username in the above example you quote.