You can easily view table data, write complex queries, and edit data from this area of MySQL Workbench, as shown in the following figure: The dropdown arrow next to each database will allow you to expand and navigate your databases tables and objects. You will find your databases listed under the SCHEMAS area of the left navigation bar. MySQL Workbench also supports importing and exporting of MySQL dump files so you can quickly back up and restore your database. Once you’ve connected to your database, you can view the details of the MySQL instance, including database status, current connections, and database configuration, as well as users and permissions. Choose Test Connection to ensure your settings are correct.If you do not store the MySQL password in MySQL Workbench, a prompt will request the password each time you attempt to connect to the database. For Password, you can either enter the password or leave it blank.For Username, enter the MySQL username.For MySQL Hostname and MySQL Server Port, use the default values.If you use public keys instead of passwords, select an SSH key for authentication. For SSH Password, enter the password you use for your SSH user.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |