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 3254 Dave Smith 02/07/2009 08:50PM
Re: Struglling - where to get help - cannot connect using forward engineering 1768 Edwin DeSouza 02/07/2009 11:51PM
Re: Struglling - where to get help - cannot connect using forward engineering 2254 Mike Lischke 02/09/2009 03:00AM
Re: Struglling - where to get help - cannot connect using forward engineering 2251 Dave Smith 02/11/2009 06:51PM
Re: Struglling - where to get help - cannot connect using forward engineering 2318 Mike Lischke 02/13/2009 03:41AM
Re: Struglling - where to get help - cannot connect using forward engineering 2236 Dave Smith 02/23/2009 08:39PM
Re: Struglling - where to get help - cannot connect using forward engineering 2013 Mike Lischke 02/24/2009 03:43AM
Re: Struglling - where to get help - cannot connect using forward engineering 2424 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.