MySQL Workbench Add User and Connect to Database
Learn how to add a new user and connect to the database using MySQL workbench. Open MySQL Workbench tool and load MySQL connection window from top menu Database and Connect to Database. Use Hostname, port number, 'root' username, click OK and enter the 'root' username password to connect to database server. Once we are logged in to the database server, in the left hand column window, under 'Management' menu, there is a link for 'Users and Privileges' window. Open the 'Users and Privileges' window. Click the bottom 'Add Account' button to add a new user, which opens a new window to enter new user details. Fill out the details and click 'apply' button to save the new user.
Close the active session by clicking this cross icon, and now connect to the database server again using the new user details. Enter new user information, press OK and enter the new user password. If you successfully logged in to to MySQL database server, you will see MySQL Workbench default window.
Check out the whole playlist of MySQL Workbench Introduction Tutorials or Individual video from the following links,
MySQL Workbench Tutorial: Introduction to MySQL Workbench for Beginners Playlist
• MySQL Workbench: Understand What is M...
MySQL Workbench: Understand What is MySQL Workbench?
• MySQL Workbench: Understand What is M...
MySQL Workbench Add User and Connect to Database
• MySQL Workbench Add User and Connect ...
MySQL Workbench Create, Alter, Drop Database
• MySQL Workbench Create, Alter, Drop D...
MySQL Workbench Create, Alter, Drop Table
• MySQL Workbench Create, Alter, Drop T...
MySQL Workbench Insert, Read, Update, Delete Data Rows
• MySQL Workbench Insert, Read, Update,...
MySQL Workbench Database Export and Import
• MySQL Workbench Database Export and I...
Subscribe to my channel: / @pntutorialsbypradnyankurnikam