16.3.1. Administering a MySQL Server

In this section you will see how you can use MySQL Workbench to connect to a server in order to carry out administrative functions, such as starting and stopping the server.

  1. Launch MySQL Workbench. You will be presented with the Home screen:

    Figure 16.2. Getting Started Tutorial - Home Screen

    Getting Started Tutorial - Home
              Screen
  2. In order to administer your MySQL Server you need to first create a Server Instance. This contains information about the target server, including how to connect to it. From the Home screen of MySQL Workbench, click New Server Instance. The Create New Server Instance Profile wizard will be displayed.

  3. In this tutorial we will connect to a locally installed server, so click Next.

    Figure 16.3. Getting Started Tutorial - Specify Host Machine

    Getting Started Tutorial - Specify Host
              Machine
  4. Next you will set up a connection, or select an existing connection to use to connect to the server. Assuming you have not already created a connection, you can use the default values here, although if your MySQL Server has a password set for root, you can set it here by clicking on Store in Vault. This allows you to connect to the server without needing to enter a password each time. It is also possible to use another account to connect to the server by setting the username and password here, if required.

    Figure 16.4. Getting Started Tutorial - Database Connection

    Getting Started Tutorial - Database
              Connection

    You can now click Next.

  5. The connection will now be tested. You should see that the connection was successful. If not click Back and check that you have entered the information required.

    Figure 16.5. Getting Started Tutorial - Connection Test

    Getting Started Tutorial - Connection
              Test

    If everything tested correctly, click Next.

  6. On this screen you will set the operating system and installation type. In this case the installation is Microsoft Windows, and the installation type is MySQL 5.1 x86 Installer Package. Setting these options allows MySQL Workbench to determine location of configuration files, and the correct start up and shut down commands to use for the server.

    Figure 16.6. Getting Started Tutorial - Operating System

    Getting Started Tutorial - Operating
              System

    Once you have set the operating system and installation type, click Next.

  7. The wizard will now check that it is able to access the start up and shut down commands, and access the MySQL Server configuration file.

    Figure 16.7. Getting Started Tutorial - Test Host Settings

    Getting Started Tutorial - Test Host
              Settings

    Check that everything is in order and then click Next.

  8. You now have a chance to review the configuration settings so far. The information displayed varies slightly depending on platform, connection method and installation type:

    Figure 16.8. Getting Started Tutorial - Review Settings

    Getting Started Tutorial - Review
              Settings

    Click Next.

  9. Finally you can give the server instance a suitable name. This will be used to select this particular instance from a list of available instances.

    Figure 16.9. Getting Started Tutorial - Instance Name

    Getting Started Tutorial - Instance
              Name

    Having set the desired name, you can click Finish to complete the server instance creation process.

  10. You will now be returned to the Home screen. You will see the new server instance you created, along with the new connection you created as part of the above procedure.

    Figure 16.10. Getting Started Tutorial - Home Screen Instance

    Getting Started Tutorial - Home Screen
              Instance

    You are now ready to test your new server instance.

  11. From the Home screen, double-click the Server Instance you created. The Administrator will open on the Startup configuration page.

    Figure 16.11. Getting Started Tutorial - Admin Startup

    Getting Started Tutorial - Admin
              Startup
  12. Click the Stop Server button. The message window will show that the server has stopped.

  13. Click the Start Server button to resume the server. The message window will confirm that the server is running.

You have now seen how to create a server instance to allow you to manage a MySQL server.

For further information see Section 16.7, “Server Administration”.

Copyright © 2010-2020 Platon Technologies, s.r.o.           Home | Man pages | tLDP | Documents | Utilities | About
Design by styleshout