MySQL Forums :: MySQL Workbench :: Struglling - where to get help - cannot connect using forward engineering


Advanced Search

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:

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

Options: ReplyQuote


Subject Views Written By Posted
Struglling - where to get help - cannot connect using forward engineering 3231 Dave Smith 02/07/2009 08:50PM
Re: Struglling - where to get help - cannot connect using forward engineering 1763 Edwin DeSouza 02/07/2009 11:51PM
Re: Struglling - where to get help - cannot connect using forward engineering 2246 Mike Lischke 02/09/2009 03:00AM
Re: Struglling - where to get help - cannot connect using forward engineering 2244 Dave Smith 02/11/2009 06:51PM
Re: Struglling - where to get help - cannot connect using forward engineering 2310 Mike Lischke 02/13/2009 03:41AM
Re: Struglling - where to get help - cannot connect using forward engineering 2228 Dave Smith 02/23/2009 08:39PM
Re: Struglling - where to get help - cannot connect using forward engineering 2006 Mike Lischke 02/24/2009 03:43AM
Re: Struglling - where to get help - cannot connect using forward engineering 2411 Dave Smith 02/11/2009 07:16PM


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.