Move Mysql to new server

[ecja]

Hello again,
am trying to move a database using PhpMyAdmin but getting error:


MySQL said: Documentation
#1044 - Access denied for user 'usr559f752d5d32'@'%' to database 'mysql14470c4f268a94bad321a4096a7'

How do grant Access to the user?


JC

 

[Da Domain Masta]

Check out this: http://dev.mysql.com/doc/refman/5.0/en/grant.html.
it may turn out you have to have mysql admin credentials to do stuff like this

 

[Amin Taheri]

To grant access you must have root/admin permissions to the mysql server

grant ALL on mysql14470c4f268a94bad321a4096a7.* to  'usr559f752d5d32'@'%' identified by 'PASSWORD HERE';
FLUSH PRIVILEGES;