Click Save Changes to complete your new user setup. Most modern website software will only require the permissions listed below. Select the appropriate privileges to allow the user access to the selected database. Select the Selected Schema radio option, and choose your database schema from the list. Click the user account from the list of users on the left. To assign privileges for this user to access a specific database, click on the Schema Privileges tab. Click Apply to create the new user account. Enter a login name for the new user, type localhost and a new password as shown. Learn more about Linux through the free Introduction to Linux course from The Linux Foundation and edX. Give this tool a try and see if it doesn’t very quickly become your daily driver. Click on your MySQL server instance under the Server Administrator section of MySQL workbench to create a new database user and assign privileges to your new database.Ĭlick on Users and Privileges. The MySQL Workbench is just one of a few GUI tools that can help make your MySQL database administration significantly more efficient. Your database should now be listed on the left with your other database schemas.Ĭlick the Home icon in the top left corner to return to the Workbench Central screen. Click the Apply button to generate the SQL script.Ĭlick the Apply button again to execute the create database statement, and create your new database. Enter your root or user and password that has been assigned dba server privileges.Ĭlick on the New Schema icon in the menu, and then enter a name for your new database in the field as shown. MySQL workbench may require a login to your MySQL server. NOTE: Databases are called schema's in MySQL Workbench. To download the latest version click here.ĭOUBLE-Click on your MySQL instance under the SQL Development section of Workbench to create a new schema.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |