The hostname value can be localhost or the local IP address that is 127.0.0.1 and I am provided the port number as 3306. I provided the Connection Name as TestConnection. Here, you need to give a name to your connection in the Connection Name text box. Once you click on the + symbol, it will open the below Setup new Connection window. In order to create a new connection in MySQL, click on the + symbol which appeared next to the MySQL Connections as shown in the below image. Now close MySQL workbench and try to login again using the new user i.e. Finally, click on the Apply button to save the new user as shown in the below image. Then select the Schema Privileges tab and using this tab, you can also restrict or allow the new users to access certain databases or schemas. ‘Database Administrative’ (DBA) has all the permission. Then select the Administrative Roles tab and in this tab, we can allow or disallow certain privileges to the new user as shown in the below image. Then select the Account Limits tab and using this tab we can limit the users to maximum queries, Maximum updates, Maximum connections, and Concurrent Connections.
#Mysql create user password
Here, I am providing the Login Name as testuser and password as test2123 as shown in the below image. the user name as well as we need to provide the password and confirm the password for the new user. Here, we need to provide the Login Name i.e.
Once you click on the ‘ Add Account’ button to add a new user, it will open the below window to enter the new user details. In order to add a new user, click on the ‘ Add Account’ button as shown in the below image.
On this window, in the center screen, you can see the current users for your MySQL database server. Once you click on the ‘ Users and Privileges’ link it will open the below window. Open the ‘ Users and Privileges’ window by clicking the link as shown in the below image. Once you are logged in to the MySQL Database Server, in the left-hand window, under the ‘ MANAGEMENT’ menu, there is a link for ‘ Users and Privileges’. Create a new user using MySQL Workbenchįirst, log in to the MySQL Server using root user.
#Mysql create user how to
Please read our previous article where we discussed how to connect to the MySQL Database Server using Workbench. In this article, I am going to discuss how to create a new user in the MySQL database server using MySQL Workbench.
0 kommentar(er)
