MySQL Forums
Forum List  »  MySQL Workbench

Re: Cannot connect from localhost, but can connect from other machine
Posted by: Mike Lischke
Date: September 12, 2012 02:28AM

Charles,

better you open a new thread when you have a question, instead hijacking an old one.

In order to run queries which refer to db objects without an explicit db name (aka qualified identifiers) a db must be set as default, which is then used to look for such objects. To make a db the default one double click on the db node in the schema tree or issue the query "use <your db>".

Mike

Mike Lischke, MySQL Developer Tools
Oracle Corporation

MySQL Workbench on Github: https://github.com/mysql/mysql-workbench
On Twitter: https://twitter.com/MySQLWorkbench
On Slack: mysqlcommunity.slack.com (#workbench)
Report bugs to http://bugs.mysql.com
MySQL documentation can be found here: http://dev.mysql.com/doc/refman/8.0/en/

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.