Re: Input data thru Workbench

[Mike Lischke]

Hey William,

seems there's a more general problem than just entering data. If you don't see your schema in the server (not even in the terminal) then it simply isn't there. Ok, there could be a second reason you cannot see it, that is, if the user you used to login with is missing the privilege to view schemas. Do you have a root account you could use as a test? If that still doesn't show you "order" or "sakila" then they are really not there. One frequent reason for such unpleasent surprises is that one has confused connections, opened the wrong one and worked on the wrong schema.

For privileges in MySQL see here: http://dev.mysql.com/doc/refman/5.6/en/grant.html, especially this part http://dev.mysql.com/doc/refman/5.6/en/privileges-provided.html#priv_show-databases is probably interesting.

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/