MySQL

Top  Previous  Next

About MySQL


MySQL is a relational database management system (RDBMS) developed by Oracle that is based on structured query language (SQL).

MySQL is one of the most recognizable technologies in the modern big data ecosystem.

Many of the world's largest and fastest-growing organizations including Facebook, Twitter, Wikipedia, and Verizon rely on MySQL to save time and money powering their high-volume web sites, business-critical systems and packaged software. MySQL Database is a client/server system.

 

For more information please visit MySQL web site.

 
MySQL in our program


In our program MySQL is an optional database system you can use. Before use, you must have MySQL server installed on your computer.
If you do not have it installed please download and install free MySQL Community Server

Our Databases Maintenance feature will take care about everything else, it can create our databases for you on MySQL server and transfer data from other database systems.
You do not have to do anything else, however there is a tool named MySQL Workbench.
MySQL Workbench is a visual database design tool that integrates SQL development, administration, database design, creation and maintenance into a single integrated development environment for the MySQL database system. You can download and install it if you want to use the server for advanced use.

 
MySQL can be used locally, or MySQL database files may be shared across a network using a network filesystem.

MySQL can be used for all of our software databases.

 

MySQL Configuration


The software is already preconfigured internally to use MySQL database version 8 or later, you can change the following options:

On Network
You can check here if you want to connect to the database on network.

Server
Here you can set database server's name.

The MySQL database server's name typically refers to the hostname or IP address of the server where the MySQL database is hosted.
This server's name is provided to establish a connection to the MySQL database from a client application or another server.
The server's name can vary depending on how the MySQL database is set up in your environment. If you're connecting to a MySQL database hosted on your local machine, the server's name might be "localhost" or "127.0.0.1". If it's hosted on a remote server, you would use the hostname or IP address of that server.
 
For example, if your MySQL database is hosted on a server with the hostname "example.com", then the server's name would be "example.com". If it's hosted on a server with the IP address "192.168.1.100", then the server's name would be "192.168.1.100".
It's important to know the correct server's name and have proper network access permissions to connect to the MySQL database server.

 

Port

The default port number for MySQL database servers is 3306. this port number can be configured during the MySQL installation process or modified later in the MySQL configuration file (my.cnf) or using MySql Workbench.
If you're connecting to a MySQL database, you would typically use port 3306 unless it has been explicitly configured to use a different port. When connecting to a MySQL database from a client application or another server, you need to specify the host (or IP address) along with the port number. If the MySQL server is running on the default port, you don't necessarily need to specify the port number explicitly, as most client libraries assume the default port if none is provided.

It's also essential to ensure that any firewalls or network configurations allow traffic through the specified port to establish connections with the MySQL database server.

 

Username

In MySQL, a  username is a unique identifier used to grant permissions and control access to the MySQL database server. 
When you create a user in MySQL, you assign a  username along with a password and define the host from which the user can connect.
Enter your username here, when you installed the server typically it would be "root", an admin  username. 

Using MySql Workbench you can also create an additional user with access only to specific databases, in that case enter here your  username

Password
Enter your password here, it can be either an admin or another  username password.

Confirm Password
Reenter here your password

Backup Location
Here you can set database backup folder. After you change database backup folder it is advisable to move existing backup files to that new folder or create new backup.
Backup location can be a local folder, network folder or ftp server address.
 
If you want to use ftp server as your backup location then you must configure ftp server in software main options in FTP section
If you have it already configured enter into Backup Location text box a server address.

Notes:
Do not enter or look for any database names, software manages it, you only must set or select folder names.
After changing any settings here please do not forget to click the Save Settings button to save the changes.