Navigation

Knowledgebase

Basic MySQL Tutorial

Last updated: 06/25/19
written by  Nodecraft Staff

MySQL is a relational database which is optimized for quick CRUD operations (Create, Read, Update, Delete). MySQL servers use SQL (Structured Query Language) to request data and write changes to the database. SQL is the most popular language for adding, accessing and managing content in a database and is most noted for its quick processing, proven reliability, and ease and flexibility of use.

What can I use MySQL for?

Many game servers and subsequently their plugins/mods rely on, or support an external database to store data. Rather than spending the valuable resources on your game server itself to store this data, you can use a database engine such as MySQL to store and retrieve the data with little to no reduction in lookup time.

Does Nodecraft offer MySQL Databases?

Absolutely! With each location, we offer at least one server dedicated to providing our customers with a stable MySQL database for each of their game servers at no additional charge.

How does one setup MySQL? Before you can start setting up the MySQL for your service, you first need to create a database. From our control panel you can find a tab on the left called MySQL. This interface will create a database for you and provide you with the information needed to connect to your database. Be sure not to share this information as this can lead to data loss on your service.

Much like FTP, a MySQL server has 4 parts to any connection. Below is the listed description of each:

Name Description Default
Host The address of the MySQL Server. Check the MySQL server's details
Port The port, where to "dock", on the server 3306
Username Authentication username provided by MySQL server. Check the MySQL server's details
Password Authentication password provided by MySQL server. Check the MySQL server's details

Make sure each section of information is correct before adding it to the configuration of your program or plugin.

Can't find answers to your questions?

Feel free to contact our support team for personal and professional help.

Write Articles, Get FREE Servers!

More information coming soon.

Chat blocked!

Nodecraft is an ad-free website! Disable adblock if you have any questions.