MySQL Forums
Forum List  »  MySQL Workbench

Re: MySql connection using IPAddress
Posted by: Mike Lischke
Date: June 20, 2014 02:14AM

Hi,

users that are allowed to connect to a MySQL server are managed in MySQL itself, not by the OS (not considering future extensions here for simplicity). You can use WB to edit your users by opening a connection to your server, switching to the management pane (left hand side) and selecting "Users and Privileges". Note that MySQL allows to specify from which host a user may connect. To get started quickly use the socalled anyhost entry (%) for your users. You can later change this to restrict user access.

See also this video for troubleshoting: https://www.youtube.com/watch?v=DCgRF4KOYIY&list=PLWx5a9Tn2EvH0q2WXpUBqptxi5640qk9O

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
1066
June 20, 2014 12:05AM
Re: MySql connection using IPAddress
513
June 20, 2014 02:14AM


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.