Forums

I have access to the db from the ' Databases tab' - at least the show tables; command works.

Hi the command I am entering in to the Bash Console is this:

   ~$ mysql -u mwshovel -h mwshovel.mysql.pythonanywhere-services.com 'mwshovel$dirt'  < dirt_this_backup.sql

'That is copy pasted from the console. I am getting this error:

~ $ ERROR 1044 (42000) at line 22: Access denied for user 'mwshovel'@'%' to database 'dirt'

I have read a few old posts on this and it seems I am doing it right. I tried with a password option:

22:46 ~ $ mysql -u mwshovel -h mwshovel.mysql.pythonanywhere-services.com 'mwshovel$dirt' -p  < dirt_this_backup.sql

I get the same message:

ERROR 1044 (42000) at line 22: Access denied for user 'mwshovel'@'%' to database 'dirt'

Tried putting it into a new database:

22:55 ~ $ mysql -u mwshovel -h mwshovel.mysql.pythonanywhere-services.com 'mwshovel$dirtx'  < dirt_this_backup.sql

It just bounces off the current one:

ERROR 1044 (42000) at line 22: Access denied for user 'mwshovel'@'%' to database 'dirt'

Notice the error message is to database ' dirt' but I put ' dirtx' in the command. Verified the passwords in the conf file. Umm what now? This is urgent

Okay who knew it was all in the file name? Solved for now

Cool. Glad you worked it out.