So, I have a bunch of MySQL databases from my previous hosting provider which I need to import.
I exported them to tar.gz files and am trying to follow the instructions on http://wiki.dreamhost.com/Migrate_MySQL
I created a database and a database user in the Panel:
User my_user_name has access to the following MySQL databases:
Database Name sometest
What may my_user_name do to tables in these databases?
From what hosts (computers) may my_user_name connect to these databases?
(One per line, use % as a wildcard.)
Would you like to change my_user_name’s password?
(where the username and password have been changed to protect the innocent)
I have unzipped the sql file(s) in the shell and am trying the command
eros:~> mysql -u my_user_name -pmy_password -h mysql.tobyport.com db_bbps < Database-db_bbps.sql
ERROR 1044 (42000): Access denied for user ‘my_user_name’@‘18.104.22.168/255.255.224.0’ to database ‘db_bbps’
(where my_user_name is the username of of the SQL user I created earlier)