MySQL Forums
Forum List  »  MySQL Workbench

Re: Struglling - where to get help - cannot connect using forward engineering
Posted by: Dave Smith
Date: February 11, 2009 07:16PM

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:

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

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.


Options: ReplyQuote

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.