Otu esi etinye MySQL 8.0 na CentOS 8/RHEL 8


MySQL bụ usoro njikwa nchekwa data kachasị ewu ewu na nke mepere emepe, nke a na-eji kwado ọtụtụ ọdụ data na sava ọ bụla site na ikwe ka ọtụtụ ndị ọrụ nweta nchekwa data ọ bụla.

Ụdị MySQL 8.0 ọhụrụ dị ka ịwụnye site na ndabara AppStream nchekwa site na iji MySQL modul nke enyere na ndabara na CentOS 8 na RHEL 8 usoro.

Enwekwara ụdị nchekwa data MariaDB 10.3 dị maka ịwụnye site na ebe nchekwa AppStream ndabara, nke bụ \dochie ngbanwe maka MySQL 5.7, yana ihe mgbochi ụfọdụ. Ọ bụrụ na akwadoghị ngwa gị na MySQL 8.0, m na-akwado gị ka ịwụnye ya. MariaDB 10.3.

N'ime edemede a, anyị ga-ejegharị site na gị usoro ịwụnye ụdị MySQL 8.0 kachasị ọhụrụ na CentOS 8 na RHEL 8 site na iji ebe nchekwa AppStream ndabara site na ịba uru YUM.

Wụnye MySQL 8.0 na CentOS8 na RHEL 8

Ụdị MySQL 8.0 kachasị ọhụrụ dị ka ịwụnye site na ebe nchekwa Stream Stream ndabara na sistemụ CentOS 8 na RHEL 8 site na iji iwu yum na-esonụ.

# yum -y install @mysql

Modul @mysql ga-etinye ụdị MySQL kachasị ọhụrụ yana ndabere niile.

Ozugbo nrụnye nke MySQL, malite ọrụ MySQL, mee ka ọ malite na-akpaghị aka na buut sistemụ wee nyochaa ọkwa ahụ site na ịme iwu ndị a.

# systemctl start mysqld
# systemctl enable --now mysqld
# systemctl status mysqld

Ugbu a chekwaa nrụnye MySQL site na iji edemede nchekwa nke na-ebu ọtụtụ ọrụ dabere na nchekwa dị ka ịtọlite okwuntughe mgbọrọgwụ, wepụ ndị ọrụ na-amaghị aha, kwe ka nbanye mgbọrọgwụ n'ime ime, wepụ nchekwa data ule na ibugharị ihe ùgwù.

# mysql_secure_installation

Ozugbo echekwabara nrụnye MySQL, ị nwere ike ịbanye na shei MySQL, wee malite ịmepụta ọdụ data ọhụrụ na ndị ọrụ.

# mysql -u root -p
mysql> create database tecmint;
mysql> GRANT ALL ON tecmint.* TO [email  IDENTIFIED BY 'ravi123';
mysql> exit

Ọ gwụla! N'isiokwu a, anyị akọwala otu esi etinye MySQL 8.0 na CentOS 8 na RHEL 8. Ọ bụrụ na ị nwere ajụjụ ọ bụla ma ọ bụ nzaghachi, kesaa ya na anyị na ngalaba nkọwa n'okpuru.