install mysql 8.0 commercial on centos
install mysql 8.0 commercial on centos
#install the MySQL Server
[root@localhost ~]# mysql-commercial-libs-compat-8.0.17-1.1.el7.x86_64.rpm
bash: mysql-commercial-libs-compat-8.0.17-1.1.el7.x86_64.rpm: 명령을 찾을 수 없습니다...
[root@localhost ~]# yum install mysql-commercial-server-8.0.17-1.1.el7.x86_64.rpm mysql-commercial-client-8.0.17-1.1.el7.x86_64.rpm mysql-commercial-libs-8.0.17-1.1.el7.x86_64.rpm mysql-commercial-common-8.0.17-1.1.el7.x86_64.rpm mysql-commercial-libs-compat-8.0.17-1.1.el7.x86_64.rpm
Loaded plugins: fastestmirror, langpacks
Examining mysql-commercial-server-8.0.17-1.1.el7.x86_64.rpm: mysql-commercial-server-8.0.17-1.1.el7.x86_64
Marking mysql-commercial-server-8.0.17-1.1.el7.x86_64.rpm to be installed
Examining mysql-commercial-client-8.0.17-1.1.el7.x86_64.rpm: mysql-commercial-client-8.0.17-1.1.el7.x86_64
Marking mysql-commercial-client-8.0.17-1.1.el7.x86_64.rpm to be installed
Examining mysql-commercial-libs-8.0.17-1.1.el7.x86_64.rpm: mysql-commercial-libs-8.0.17-1.1.el7.x86_64
Marking mysql-commercial-libs-8.0.17-1.1.el7.x86_64.rpm to be installed
Examining mysql-commercial-common-8.0.17-1.1.el7.x86_64.rpm: mysql-commercial-common-8.0.17-1.1.el7.x86_64
Marking mysql-commercial-common-8.0.17-1.1.el7.x86_64.rpm to be installed
Examining mysql-commercial-libs-compat-8.0.17-1.1.el7.x86_64.rpm: mysql-commercial-libs-compat-8.0.17-1.1.el7.x86_64
Marking mysql-commercial-libs-compat-8.0.17-1.1.el7.x86_64.rpm to be installed
Resolving Dependencies
--> Running transaction check
---> Package mariadb-libs.x86_64 1:5.5.60-1.el7_5 will be obsoleted
---> Package mysql-commercial-client.x86_64 0:8.0.17-1.1.el7 will be installed
---> Package mysql-commercial-common.x86_64 0:8.0.17-1.1.el7 will be installed
---> Package mysql-commercial-libs.x86_64 0:8.0.17-1.1.el7 will be obsoleting
---> Package mysql-commercial-libs-compat.x86_64 0:8.0.17-1.1.el7 will be obsoleting
---> Package mysql-commercial-server.x86_64 0:8.0.17-1.1.el7 will be installed
--> Finished Dependency Resolution
Dependencies Resolved
===================================================================================================================================================
Package Arch Version Repository Size
===================================================================================================================================================
Installing:
mysql-commercial-client x86_64 8.0.17-1.1.el7 /mysql-commercial-client-8.0.17-1.1.el7.x86_64 146 M
mysql-commercial-common x86_64 8.0.17-1.1.el7 /mysql-commercial-common-8.0.17-1.1.el7.x86_64 8.3 M
mysql-commercial-libs x86_64 8.0.17-1.1.el7 /mysql-commercial-libs-8.0.17-1.1.el7.x86_64 14 M
replacing mariadb-libs.x86_64 1:5.5.60-1.el7_5
mysql-commercial-libs-compat x86_64 8.0.17-1.1.el7 /mysql-commercial-libs-compat-8.0.17-1.1.el7.x86_64 6.3 M
replacing mariadb-libs.x86_64 1:5.5.60-1.el7_5
mysql-commercial-server x86_64 8.0.17-1.1.el7 /mysql-commercial-server-8.0.17-1.1.el7.x86_64 1.9 G
Transaction Summary
===================================================================================================================================================
Install 5 Packages
Total size: 2.1 G
Is this ok [y/d/N]:
Downloading packages:
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Installing : mysql-commercial-common-8.0.17-1.1.el7.x86_64 1/6
Installing : mysql-commercial-libs-8.0.17-1.1.el7.x86_64 2/6
Installing : mysql-commercial-client-8.0.17-1.1.el7.x86_64 3/6
Installing : mysql-commercial-server-8.0.17-1.1.el7.x86_64 4/6
Installing : mysql-commercial-libs-compat-8.0.17-1.1.el7.x86_64 5/6
Erasing : 1:mariadb-libs-5.5.60-1.el7_5.x86_64 6/6
Verifying : mysql-commercial-libs-compat-8.0.17-1.1.el7.x86_64 1/6
Verifying : mysql-commercial-server-8.0.17-1.1.el7.x86_64 2/6
Verifying : mysql-commercial-common-8.0.17-1.1.el7.x86_64 3/6
Verifying : mysql-commercial-libs-8.0.17-1.1.el7.x86_64 4/6
Verifying : mysql-commercial-client-8.0.17-1.1.el7.x86_64 5/6
Verifying : 1:mariadb-libs-5.5.60-1.el7_5.x86_64 6/6
Installed:
mysql-commercial-client.x86_64 0:8.0.17-1.1.el7 mysql-commercial-common.x86_64 0:8.0.17-1.1.el7
mysql-commercial-libs.x86_64 0:8.0.17-1.1.el7 mysql-commercial-libs-compat.x86_64 0:8.0.17-1.1.el7
mysql-commercial-server.x86_64 0:8.0.17-1.1.el7
Replaced:
mariadb-libs.x86_64 1:5.5.60-1.el7_5
Complete!
[root@localhost ~]#
#Starting the MySQL Server
[root@localhost ~]# systemctl start mysqld
[root@localhost ~]#
#A password for the superuser is set and stored in the error log file.
[root@localhost ~]# grep 'temporary password' /var/log/mysqld.log
2019-09-28T23:03:55.056353Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: P+iIMsXar6+p
[root@localhost ~]#
#set a custom password for the superuser account
[root@localhost ~]# mysql -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 8.0.17-commercial
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> ALTER USER 'root'@'localhost' IDENTIFIED BY 'Newpassword0!';
Query OK, 0 rows affected (0.04 sec)
mysql>
#set a custom password for the superuser account
[root@localhost ~]# yum install mysql-workbench-commercial-8.0.17-1.1.el7.x86_64.rpm
Loaded plugins: fastestmirror, langpacks
Examining mysql-workbench-commercial-8.0.17-1.1.el7.x86_64.rpm: mysql-workbench-commercial-8.0.17-1.1.el7.x86_64
Marking mysql-workbench-commercial-8.0.17-1.1.el7.x86_64.rpm to be installed
Resolving Dependencies
--> Running transaction check
---> Package mysql-workbench-commercial.x86_64 0:8.0.17-1.1.el7 will be installed
--> Processing Dependency: libzip for package: mysql-workbench-commercial-8.0.17-1.1.el7.x86_64
Loading mirror speeds from cached hostfile
* base: mirror.kakao.com
* epel: mirrors.aliyun.com
* extras: mirror.kakao.com
* updates: mirror.kakao.com
--> Processing Dependency: proj for package: mysql-workbench-commercial-8.0.17-1.1.el7.x86_64
--> Processing Dependency: libGLU.so.1()(64bit) for package: mysql-workbench-commercial-8.0.17-1.1.el7.x86_64
--> Processing Dependency: libzip.so.2()(64bit) for package: mysql-workbench-commercial-8.0.17-1.1.el7.x86_64
--> Running transaction check
---> Package libzip.x86_64 0:0.10.1-8.el7 will be installed
---> Package mesa-libGLU.x86_64 0:9.0.0-4.el7 will be installed
---> Package proj.x86_64 0:4.8.0-4.el7 will be installed
--> Finished Dependency Resolution
Dependencies Resolved
=================================================================================================================================================================================================================================================
Package Arch Version Repository Size
=================================================================================================================================================================================================================================================
Installing:
mysql-workbench-commercial x86_64 8.0.17-1.1.el7 /mysql-workbench-commercial-8.0.17-1.1.el7.x86_64 177 M
Installing for dependencies:
libzip x86_64 0.10.1-8.el7 base 48 k
mesa-libGLU x86_64 9.0.0-4.el7 base 196 k
proj x86_64 4.8.0-4.el7 epel 181 k
Transaction Summary
=================================================================================================================================================================================================================================================
Install 1 Package (+3 Dependent packages)
Total size: 178 M
Total download size: 426 k
Installed size: 178 M
Is this ok [y/d/N]: y
Downloading packages:
(1/3): libzip-0.10.1-8.el7.x86_64.rpm | 48 kB 00:00:00
(2/3): mesa-libGLU-9.0.0-4.el7.x86_64.rpm | 196 kB 00:00:00
(3/3): proj-4.8.0-4.el7.x86_64.rpm | 181 kB 00:00:01
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Total 343 kB/s | 426 kB 00:00:01
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Installing : proj-4.8.0-4.el7.x86_64 1/4
Installing : mesa-libGLU-9.0.0-4.el7.x86_64 2/4
Installing : libzip-0.10.1-8.el7.x86_64 3/4
Installing : mysql-workbench-commercial-8.0.17-1.1.el7.x86_64 4/4
Error in file "/usr/share/applications/org.gnome.font-viewer.desktop": "font/ttf" is an invalid MIME type ("font" is an unregistered media type)
Error in file "/usr/share/applications/org.gnome.font-viewer.desktop": "font/otf" is an invalid MIME type ("font" is an unregistered media type)
Verifying : mysql-workbench-commercial-8.0.17-1.1.el7.x86_64 1/4
Verifying : libzip-0.10.1-8.el7.x86_64 2/4
Verifying : mesa-libGLU-9.0.0-4.el7.x86_64 3/4
Verifying : proj-4.8.0-4.el7.x86_64 4/4
Installed:
mysql-workbench-commercial.x86_64 0:8.0.17-1.1.el7
Dependency Installed:
libzip.x86_64 0:0.10.1-8.el7 mesa-libGLU.x86_64 0:9.0.0-4.el7 proj.x86_64 0:4.8.0-4.el7
Complete!
[root@localhost ~]#
#set a firealld
[root@localhost ~]# firewall-cmd --permanent --zone=public --add-port=3306/tcp
[root@localhost ~]# vi /etc/firewalld/zones/public.xml
[root@localhost ~]# systemctl restart firewalld
댓글
댓글 쓰기