Step 1Ĭlick Manage Import / Export under Server Administration on the right of the Workbench window. We strongly recommend that you create regular backups of your database so it can be easily and quickly recovered in the unlikely event that your data is lost or becomes corrupted. Step 4Įnter your database password when prompted.
Username: The username of your database owner as chosen during your MySQL setup.Hostname: The IP address of the MySQL database server you have been allocated.Connection method: Ensure Standard (TCP/IP) is selected.Connection name: Enter a name to allow you to easily identify the database.On this page enter the following details: Select Remote Host, enter the IP address of your database server in the Address text field, and click Next. The Create New Server Instance Profile window will appear. Open MySQL Workbench and click New Server Instance on the right of the window. A Database user How Do I Change the Owner Password for My Database?īefore you begin you need to define a connection to the database server.How do I add a MySQL database to my account?
