MySQL is
a popular open-source database and community version of MySQL database, it is
widely used for database management in LAMP stack like servers.
This article
describes, How to Install MySQL 8.0 Database Server on CentOS
8.
Step 1. Package installation: All MySQL
Database and its dependencies packages are available in CentOS
8 AppStream Repository so just run the following command to install to
install MySQL packages:
[root@linuxcnf
~]# dnf
install mysql-server
CentOS-8
- AppStream
……………………..
Installed:
mysql-server-8.0.17-3.module_el8.0.0+181+899d6349.x86_64
Complete!
[root@linuxcnf
~]#
|
Step 2. Start MySQL Service: Run
the following commands to start the server and enable on startup:
[root@linuxcnf
~]# systemctl
enable --now mysqld
Created
symlink /etc/systemd/system/multi-user.target.wants/mysqld.service →
/usr/lib/systemd/system/mysqld.service.
[root@linuxcnf
~]#
|
Step 3. Verify the installation: Check
the service status and check MySQL Database by access its interactive
interface:
[root@linuxcnf
~]# systemctl
status mysqld
●
mysqld.service - MySQL 8.0 database server
Loaded: loaded
(/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
Active: active (running) since Tue 2020-08-18
10:07:47 EDT; 5s ago
Process: 5126
ExecStartPost=/usr/libexec/mysql-check-upgrade (code=exited, status=0/SUCCESS)
……………………..
[root@linuxcnf
~]#
|
Run the
following command to enter in MySQL interface:
[root@linuxcnf
~]# mysql
Welcome
to the MySQL monitor. Commands end
with ; or \g.
Your
MySQL connection id is 8
Server
version: 8.0.17 Source distribution
Copyright
(c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.
Oracle
is a registered trademark of Oracle Corporation and/or its
affiliates.
Other names may be trademarks of their respective
owners.
Type
'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>
\q
Bye
[root@linuxcnf
~]#
|
Done!!!
MySQL Database is installed successfully. Use \q command to exit from the
interface.
No comments:
Post a Comment