Re: Struglling - where to get help - cannot connect using forward engineering

[Dave Smith]

Also on the subject, when I try and run an exported script from Workbench on my shared hosting account (logged in via SSH) even then I get the following error:

INPUT:
# mysql -u DB_USERNAME@localhost -pPASSWORD DB_NAME < CreateDB_TablesScriptSQL.sql

OUTPUT:
ERROR 1044 (42000) at line 5: Access denied for user 'DB_USERNAME'@'localhost' to database 'mydb'


Now I notice when I go onto the server via SSH and create a mySQL script using mysldump, it does not contain any refrences to the 'mydb' object.
However my script created in Workbench proceeds each table name with the 'mydb'.

I assume if I can stop that happening at least I could maybe get my script to work by importing via command line.

Any input on this matter appreciated.

Thanks