mariadb 삭제
- CentOS 7에서 yum install mysql 을 하는 경우 Maria DB가 설치됨!! (기본적으로 Maria DB가 깔려있기도 함)
-
# yum list installed mariadb*
-
# yum remove -y 패키지명
-
# yum remove -y mariadb.x86_64
-
# yum remove -y mariadb-libs.x86_64
-
…
-
MySQL 8.x 설치 정보
[root@home ~]# rpm -ivh https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm
https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm(을)를 복구합니다
경고: /var/tmp/rpm-tmp.p9Z5Hm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
준비 중... ################################# [100%]
Updating / installing...
1:mysql80-community-release-el7-3 ################################# [100%]
- # yum repolist all | grep mysql | grep enabled
[root@home ~]# yum repolist all | grep mysql | grep enabled
mysql-connectors-community/x86_64 MySQL Connectors Community enabled: 108
mysql-tools-community/x86_64 MySQL Tools Community enabled: 90
mysql80-community/x86_64 MySQL 8.0 Community Server enabled: 113
MySQL 설치
- # yum -y install mysql-community-server
[root@home ~]# yum -y install mysql-community-server
Loaded plugins: fastestmirror, langpacks
Loading mirror speeds from cached hostfile
Resolving Dependencies
--> Running transaction check
---> Package mysql-community-server.x86_64 0:8.0.16-2.el7 will be installed
--> Processing Dependency: mysql-community-common(x86-64) = 8.0.16-2.el7 for package: mysql-community-server-8.0.16-2.el7.x86_64
--> Processing Dependency: mysql-community-client(x86-64) >= 8.0.11 for package: mysql-community-server-8.0.16-2.el7.x86_64
--> Running transaction check
---> Package mysql-community-client.x86_64 0:8.0.16-2.el7 will be installed
--> Processing Dependency: mysql-community-libs(x86-64) >= 8.0.11 for package: mysql-community-client-8.0.16-2.el7.x86_64
---> Package mysql-community-common.x86_64 0:8.0.16-2.el7 will be installed
--> Running transaction check
---> Package mariadb-libs.x86_64 1:5.5.60-1.el7_5 will be obsoleted
--> Processing Dependency: libmysqlclient.so.18()(64bit) for package: 2:postfix-2.10.1-7.el7.x86_64
--> Processing Dependency: libmysqlclient.so.18()(64bit) for package: MySQL-python-1.2.5-1.el7.x86_64
--> Processing Dependency: libmysqlclient.so.18(libmysqlclient_18)(64bit) for package: 2:postfix-2.10.1-7.el7.x86_64
--> Processing Dependency: libmysqlclient.so.18(libmysqlclient_18)(64bit) for package: MySQL-python-1.2.5-1.el7.x86_64
---> Package mysql-community-libs.x86_64 0:8.0.16-2.el7 will be obsoleting
--> Running transaction check
---> Package mysql-community-libs-compat.x86_64 0:8.0.16-2.el7 will be obsoleting
---> Package postfix.x86_64 2:2.10.1-7.el7 will be updated
---> Package postfix.x86_64 2:2.10.1-7.0.1.el7.centos will be an update
--> Finished Dependency Resolution
Dependencies Resolved
=================================================================================================================================================================
Package Arch Version Repository Size
=================================================================================================================================================================
Installing:
mysql-community-libs x86_64 8.0.16-2.el7 mysql80-community 3.0 M
replacing mariadb-libs.x86_64 1:5.5.60-1.el7_5
mysql-community-libs-compat x86_64 8.0.16-2.el7 mysql80-community 2.1 M
replacing mariadb-libs.x86_64 1:5.5.60-1.el7_5
mysql-community-server x86_64 8.0.16-2.el7 mysql80-community 403 M
Installing for dependencies:
mysql-community-client x86_64 8.0.16-2.el7 mysql80-community 32 M
mysql-community-common x86_64 8.0.16-2.el7 mysql80-community 575 k
Updating for dependencies:
postfix x86_64 2:2.10.1-7.0.1.el7.centos centosplus 2.5 M
Transaction Summary
=================================================================================================================================================================
Install 3 Packages (+2 Dependent packages)
Upgrade ( 1 Dependent package)
Total download size: 443 M
Downloading packages:
Delta RPMs disabled because /usr/bin/applydeltarpm not installed.
경고: /var/cache/yum/x86_64/7/mysql80-community/packages/mysql-community-common-8.0.16-2.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Public key for mysql-community-common-8.0.16-2.el7.x86_64.rpm is not installed
(1/6): mysql-community-common-8.0.16-2.el7.x86_64.rpm | 575 kB 00:00:00
(2/6): mysql-community-libs-8.0.16-2.el7.x86_64.rpm | 3.0 MB 00:00:00
(3/6): mysql-community-libs-compat-8.0.16-2.el7.x86_64.rpm | 2.1 MB 00:00:00
(4/6): postfix-2.10.1-7.0.1.el7.centos.x86_64.rpm | 2.5 MB 00:00:00
(5/6): mysql-community-client-8.0.16-2.el7.x86_64.rpm | 32 MB 00:00:00
(6/6): mysql-community-server-8.0.16-2.el7.x86_64.rpm | 403 MB 00:00:04
-----------------------------------------------------------------------------------------------------------------------------------------------------------------
Total 104 MB/s | 443 MB 00:00:04
Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
Importing GPG key 0x5072E1F5:
Userid : "MySQL Release Engineering <mysql-build@oss.oracle.com>"
Fingerprint: a4a9 4068 76fc bd3c 4567 70c8 8c71 8d3b 5072 e1f5
Package : mysql80-community-release-el7-3.noarch (installed)
From : /etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Warning: RPMDB altered outside of yum.
Installing : mysql-community-common-8.0.16-2.el7.x86_64 1/8
Installing : mysql-community-libs-8.0.16-2.el7.x86_64 2/8
Installing : mysql-community-libs-compat-8.0.16-2.el7.x86_64 3/8
Installing : mysql-community-client-8.0.16-2.el7.x86_64 4/8
Installing : mysql-community-server-8.0.16-2.el7.x86_64 5/8
Updating : 2:postfix-2.10.1-7.0.1.el7.centos.x86_64 6/8
Cleanup : 2:postfix-2.10.1-7.el7.x86_64 7/8
Erasing : 1:mariadb-libs-5.5.60-1.el7_5.x86_64 8/8
Verifying : mysql-community-libs-8.0.16-2.el7.x86_64 1/8
Verifying : mysql-community-libs-compat-8.0.16-2.el7.x86_64 2/8
Verifying : mysql-community-client-8.0.16-2.el7.x86_64 3/8
Verifying : mysql-community-common-8.0.16-2.el7.x86_64 4/8
Verifying : mysql-community-server-8.0.16-2.el7.x86_64 5/8
Verifying : 2:postfix-2.10.1-7.0.1.el7.centos.x86_64 6/8
Verifying : 2:postfix-2.10.1-7.el7.x86_64 7/8
Verifying : 1:mariadb-libs-5.5.60-1.el7_5.x86_64 8/8
Installed:
mysql-community-libs.x86_64 0:8.0.16-2.el7 mysql-community-libs-compat.x86_64 0:8.0.16-2.el7 mysql-community-server.x86_64 0:8.0.16-2.el7
Dependency Installed:
mysql-community-client.x86_64 0:8.0.16-2.el7 mysql-community-common.x86_64 0:8.0.16-2.el7
Dependency Updated:
postfix.x86_64 2:2.10.1-7.0.1.el7.centos
Replaced:
mariadb-libs.x86_64 1:5.5.60-1.el7_5
Complete!
- MySQL 시작, 정지, 재시작, 상태확인
- 시작
- systemctl start mysqld
- 정지
- systemctl stop mysqld
- 재시작
- systemctl restart mysqld
- 상태확인
- systemctl status mysqld
- 시작
[root@home ~]# systemctl start mysqld
[root@home ~]# systemctl status mysqld
● mysqld.service - MySQL Server
Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
Active: active (running) since 수 2019-06-26 23:30:38 KST; 2min 49s ago
Docs: man:mysqld(8)
http://dev.mysql.com/doc/refman/en/using-systemd.html
Process: 15917 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)
Main PID: 15941 (mysqld)
Status: "SERVER_OPERATING"
CGroup: /system.slice/mysqld.service
└─15941 /usr/sbin/mysqld
6월 26 23:30:38 home systemd[1]: Starting MySQL Server...
6월 26 23:30:38 home systemd[1]: Started MySQL Server.
[root@home ~]# systemctl stop mysqld
[root@home ~]# systemctl status mysqld
● mysqld.service - MySQL Server
Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
Active: inactive (dead) since 수 2019-06-26 23:33:44 KST; 3s ago
Docs: man:mysqld(8)
http://dev.mysql.com/doc/refman/en/using-systemd.html
Process: 15941 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS (code=exited, status=0/SUCCESS)
Process: 15917 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)
Main PID: 15941 (code=exited, status=0/SUCCESS)
Status: "SERVER_SHUTTING_DOWN"
6월 26 23:30:38 home systemd[1]: Starting MySQL Server...
6월 26 23:30:38 home systemd[1]: Started MySQL Server.
6월 26 23:33:42 home systemd[1]: Stopping MySQL Server...
6월 26 23:33:44 home systemd[1]: Stopped MySQL Server.
'Linux > MySQL' 카테고리의 다른 글
| AWS EC2에 MySQL 설치 및 설정 방법 (Ubuntu 24.04) (0) | 2025.01.16 |
|---|---|
| MySQL 설치 및 설정 (CentOS7) (0) | 2019.07.25 |