MySQL: what is it and how to use the system?

MySQL is an open source relational database management system (RDBMS) supported by Oracle and based on structured query language (SQL). The system works on virtually all platforms, including Linux, UNIX and Windows.

The system is an important component of an open source toolset called LAMP, which uses Linux as the operating system, Apache as the web server, MySQL as the relational database management system, and PHP, Perl or Python as the oriented scripting language to objects.

Although it can be used in a wide variety of applications, the database manager is most often associated with web applications and online publishing. Thus, behind many of the world’s leading websites, the tool used is the RDBMS, as well as countless web-based consumer and business applications such as Facebook, Twitter and YouTube.

Originally conceived in 1995 by the Swedish company MySQL AB, the program was acquired by Sun Microsystems in 2008, which, in turn, passed to Oracle in 2010. Developers can use the software for free, but companies must obtain it. a commercial license.

How to use MySQL?

With a simple and easy-to-use setup, the tool works on virtually all platforms, including Linux, UNIX and Windows. Although it is possible to install and use the system via command lines, the easiest way to use the software is through the MySQL Workbench graphical interface, which is available for Windows, Linux and Mac OS.

installing

It is necessary to install the server and the client to run the system. (Source: Oracle/Reproduction)Source:  Oracle/Reproduction

We will focus on installing the database manager for Windows, and the process is similar for other operating systems. The beginning involves two steps:

Setting up a server

After finishing the installations, you need to perform the setup as shown below.

1. The first step is to open the program.

2. On the home screen, click “+” next to MySQL Connections.

3. To get started, you can create a connection to a locally installed server. Click the “Configure Server Management” button in the “Setup New Connection” window to check the server configuration.

4. A new window opens with the name “Configure Local Management”; then click the “Next” button to continue.

5. A popup window will ask for your root password to test your connection to the local mysql server instance. The password is the one you set during the software installation.

6. Next, the wizard will test the database connections. If the test fails, go back and correct the database connection parameters. Otherwise, if all tests are successful, click “Next” to continue.

7. After that, a new wizard will open under “Local Service Management”, which allows switching between multiple database servers installed on one machine. You can ignore this and click “Next” to continue.

8. The wizard will then verify the ability to access the system server configuration file and test start or stop commands.

9. Then you can review the current settings; after reviewing them, click “Finish” for final server setup.

10. The next step is to set up a connection that can be used to connect to the server. If you haven’t created it yet, you can use the default values ​​provided. Click “Test Connection” after entering the connection name.

11. A new dialog will open asking for the password of the root or selected user. If your root user has a password, you can enter it using the “Save Password in Vault” feature. Click “OK”.

12. If the password entered for the user is correct, a screen with login information will appear, and everything will be ready for you to start building a database.

First steps

(Source: Oracle/Reproduction)(Source: Oracle/Reproduction)Source:  Oracle/Reproduction

After completing the server setup, you can begin to effectively use the system. Check out the initial sections to use the program’s graphical interface.

  • SQL Editor: space for creating and editing queries.
  • Help panel: allows you to view the syntax and description of a specific keyword.
  • Navigation Pane: Enables the management of active connections and also shows the schemas on that server for a connection.
  • History Output Window: Provides a summary of the queries performed in the following ways: “Action output”, “Text output” or “History output”.

The most important functions of the program can be summarized as:

  • models, which allows the creation of a new database model, with the addition of tables, columns and their respective values;
  • diagram, which offers a graphical view of the tables and allows the creation of relationships between them, allowing the automatic updating of information;
  • deploy, in this, after the completion of the database, the command allows to start the operation of the information system.

Now that you have the initial knowledge, it’s time to test your knowledge of MySQL in practice.

Leave a Comment