MySQL Forums
Forum List  »  MySQL Workbench

Re: Connect To database error
Posted by: Mike Lischke
Date: October 07, 2013 01:50AM

Yes, I was speaking about mysql.user. But you would of course not directly enter values there but use SQL for this (see "create user" in the documentation). Inspecting the user table however is a quick way to see if a user exists with a specific name that is allowed to connect from a specific host.

Of course MySQL Workbench can give you all this information (and more) too. Just open a connection to your server as a root user, then go to Management -> Users and Privileges.

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


Subject
Views
Written By
Posted
1493
October 01, 2013 08:49PM
639
October 02, 2013 01:40AM
588
October 02, 2013 07:18PM
654
October 03, 2013 01:16AM
609
October 03, 2013 09:45AM
528
October 04, 2013 08:34AM
Re: Connect To database error
636
October 07, 2013 01:50AM
498
October 07, 2013 08:20PM
574
October 08, 2013 02:11AM
597
October 08, 2013 08:10PM
498
October 09, 2013 01:25AM
506
October 09, 2013 08:03PM
586
October 12, 2013 09:29PM
534
October 14, 2013 01:32AM
526
October 14, 2013 07:34PM
549
October 10, 2013 09:11PM


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.