The message itself looks like an authentication issue.
Here is what you should do: If you can connect to the hosting company's mysql database from the mysql client, run this command:
SELECT USER() RequestedUserLogin,CURRENT_USER() AllowedUserLogin;
What will these functions give you ?
- USER() reports how you attempted to authenticate in MySQL
- CURRENT_USER() reports how you were allowed to authenticate in MySQL
It's the second function you need to be concerned with because it says you have the same user permissons as
@Abdul's answer reveals a deeper issue: You created the mysqldump which has the command to create the database. When you mysqldump with the --databases option, the
create database mydb; is inserted before the
use mydb;. You can hide the
create database mydb; by doing
mysqldump -u... -p... --no-data --databases mydb > mydbschema.sql
mysqldump -u... -p... --no-create-info mydb > mydbdata.sql
This will place the database and table creation statements in
mydbschema.sql while the bulk INSERTs are placed in
If you cannot run
mydbschema.sql then have the hosting company create the database for you. You could also use whatever DB tools they have setup for you to create the database yourself.
You could then load the data using
mysql -umyuser -pmypassword -h(IP-of-DBServer) -Dmydb < mydbdata.sql
I also noticed the user mysql was expecting 'myuser'@'10.%' as the user to authenticate. You might need 'myuser'@'IP-of-DBServer' defined on the database mydb with this:
GRANT ALL PRIVILEGES ON mydb.* TO 'myuser'@'IP-of-DBServer';
Give it a Try !!!