Ferikgong 13, 2026Dikaelo

Jang go Beakanya MySQL Database mo Linux Server

Kaelo e e tletseng ka ga go tsenya, go sireletsa, le go laola MySQL database server mo Ubuntu le CentOS.

MySQL ke nngwe ya di-system tsa botsamaisi ba relational database tsa open-source tse di tumileng thata. Kaelo e e tla go thusa go tsenya, go sireletsa, le go beakanya MySQL mo Hiddence Linux server ya gago.

Go Tsenya MySQL

MySQL 8.0 ke mofuta o o nitameng wa ga jaana go tloga ka 2026. Tirego ya tsenyo e farologana go sekae magareng ga Ubuntu/Debian le di-distribution tse di ikaegileng ka RHEL. Re tla akaretsa mekgwa yombedi fa tlase.

Go Tsenya MySQL mo Ubuntu/Debian

Ya Ubuntu 22.04 LTS le tse di ntšha, MySQL 8.0 e teng mo di-repository tsa default. E tsenye o dirisa apt:

bash

sudo apt update
sudo apt install mysql-server -y
sudo systemctl start mysql
sudo systemctl enable mysql

# Netefatsa tsenyo
sudo systemctl status mysql
mysql --version

Go Tsenya MySQL mo RHEL / CentOS / AlmaLinux / Rocky Linux

Ya di-distribution tse di ikaegileng ka RHEL, o tlhoka go tsenya MySQL repository pele. MySQL 8.0 e a kgothalediwa go dirisiwa mo production:

bash

# Lada MySQL repository package
sudo wget https://dev.mysql.com/get/mysql80-community-release-el9-1.noarch.rpm

# Tsenya repository
sudo rpm -ivh mysql80-community-release-el9-1.noarch.rpm

# Ya CentOS 8/Rocky Linux 8/AlmaLinux 8, dirisa:
# sudo wget https://dev.mysql.com/get/mysql80-community-release-el8-7.noarch.rpm

# Tsenya MySQL
sudo yum install mysql-server -y

# Simolola le go letlelela MySQL
sudo systemctl start mysqld
sudo systemctl enable mysqld

# Netefatsa tsenyo
sudo systemctl status mysqld
mysql --version

Go Netefatsa Tsenyo

Morago ga tsenyo, netefatsa gore MySQL e bereka sentle:

bash

# Tlhola seemo sa tirelo
sudo systemctl status mysql  # Ubuntu/Debian
sudo systemctl status mysqld  # RHEL / CentOS

# Tlhola mofuta wa MySQL
mysql --version

# Testa kgolagano (e tla kopa root password)
sudo mysql -u root -p

Go Sireletsa Tsenyo ya MySQL

Tsamaisa script sa tsenyo e e sireletsegileng ya MySQL:

bash

sudo mysql_secure_installation
# Latela ditaelo go seta root password, go tlosa badirisi ba ba sa itsiweng, go thibela remote root login, jalo jalo.

Go Tlhama Database le Modirisi

bash

sudo mysql -u root -p
CREATE DATABASE myapp_db;
CREATE USER 'app_user'@'localhost' IDENTIFIED BY 'strong_password';
GRANT ALL PRIVILEGES ON myapp_db.* TO 'app_user'@'localhost';
FLUSH PRIVILEGES;
EXIT;

Go Laola Badirisi

bash

sudo mysql -u root -p
# Tlhama modirisi
CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';

# Neela ditshwanelo
GRANT ALL PRIVILEGES ON database_name.* TO 'newuser'@'localhost';

# Tsaya ditshwanelo
REVOKE ALL PRIVILEGES ON database_name.* FROM 'newuser'@'localhost';

# Tlosa modirisi
DROP USER 'newuser'@'localhost';

Go Letlelela Remote Access (Ka boikgethelo)

Go letlelela dikgolagano tsa remote, fetola bind-address:

bash

sudo nano /etc/mysql/mysql.conf.d/mysqld.cnf
# Fetola bind-address = 127.0.0.1 go nna bind-address = 0.0.0.0
sudo systemctl restart mysql
# Beakanya gape firewall go letlelela port 3306

Database Backup le Restoration

Tlhama backup le go restore:

bash

# Backup
mysqldump -u root -p database_name > backup.sql

# Restore
mysql -u root -p database_name < backup.sql

Mekgwa e e Molemo

Dirisa di-password tse di thata tsa badirisi ba database
Neela fela ditshwanelo tse di tlhokegang go badirisi
Dira di-backup tsa di-database tsa gago ka gale
Boloka MySQL e ntšhwafaditswe go bona di-patch tsa tshireletso
Tlhokomela tiragatso ya database mme o optimise di-query