search
HomeOperation and MaintenanceCentOScentos7 mysql8.0 installation method

centos7 Mysql8.0 installation method: First uninstall the historical version of MySQL; then use the command "sudo yum install mysql-server" to install MySQL; finally set it to start at boot.

centos7 mysql8.0 installation method

Recommendation: "centos tutorial"

CentOS 7 Installation of MySQL8.0

1. Uninstall the historical version of MySQL

Check whether you have the historical version

If you are not installing for the first time, you need to uninstall the historical version of MySQL. Use the command to check whether the historical version of MySQL component is installed

# rpm -qa|grep mysql

centos7 mysql8.0 installation method

For example, two installed MySQL Community Edition components are queried in the picture. Before installing the new version of MySQL, you need to remove the installed historical components

Check the MySQL service status

# service mysqld status

Pause the MySQL service

# service mysqld stop

Uninstall the MySQL service

You need to remove all components. Please note that there may be dependencies in the order of components.

# rpm -ev [需要移除组件的名称]

or

# rpm -e --nodeps [需要移除组件的名称]  //此命令为强制卸载

2. Install MySQL

Use rpm to install MySQL

Because the default database installed by CentOS 7 is Mariadb, use the YUM command MySQL cannot be installed, only Mariadb will be updated. Use rpm to install. You can right-click the mysql repo source warehouse to copy the specified version of the database.

# wget http://repo.mysql.com/mysql80-community-release-el7-1.noarch.rpm

Install the mysql80-community-release-el7-1.noarch.rpm package

# sudo rpm -ivh mysql80-community-release-el7-1.noarch.rpm

After the installation is completed, two files will be obtained in the /etc/yum.repos.d folder: mysql-community.repo && mysql-community-source.repo

centos7 mysql8.0 installation method

##Use yum to install the mysql service

# sudo yum install mysql-server

If the following content is displayed, the installation is successful

Complete!

Check whether it has been set to start the MySQL service at boot

# systemctl list-unit-files|grep mysqld

If

centos7 mysql8.0 installation method

is displayed, it means that it has been set to start at boot. If it is not set to start at boot If it is started, execute

# systemctl enable mysqld.service

Check if MySQL is started. If it is not started, execute the start service command

Check if the MySQL service is started

# ps -ef|grep mysql

Start the service

# systemctl start mysqld.service

Initialize MySQL

# mysqld --initialize

View MySQL initial default password

# grep 'temporary password' /var/log/mysqld.log

centos7 mysql8.0 installation method

Copy the password behind root@localhost:. Log in to mysql and paste the default password

Because of the changes in MySQL8.0, the password must be reset

alter user 'root'@'localhost' identified by '12345678';

If a prompt appears when setting the password

ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

It means you need to lower the policy level before executing

set global validate_password.policy=0;

Open the MySQL remote connection

use mysql;
#修改root账户权限
update user set host = '%' where user = 'root';
#刷新权限
flush privileges;

The above is the detailed content of centos7 mysql8.0 installation method. For more information, please follow other related articles on the PHP Chinese website!

Statement
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Migration from CentOS: The Best ApproachesMigration from CentOS: The Best ApproachesApr 12, 2025 am 12:13 AM

The best way to migrate from CentOS is to choose RockyLinux, AlmaLinux, or UbuntuServer. 1) Back up data, 2) Evaluate existing systems, 3) Test migration, 4) Perform migration, 5) Verify and optimize to ensure the best system performance.

The Discontinuation of CentOS: A DiscussionThe Discontinuation of CentOS: A DiscussionApr 11, 2025 am 12:09 AM

CentOS has stopped maintaining and has moved to CentOSStream and no longer provides a production-friendly version. Impacts include system migration and enterprise reevaluation of Linux policies. Alternatives are: 1. Migrate to RHEL, 2. Turn to Ubuntu or Debian, 3. Consider CentOSStream as a test platform, 4. Use AlmaLinux or RockyLinux. It is recommended to develop a migration plan as early as possible to evaluate existing system and team needs.

CentOS Automation with Ansible: Infrastructure as CodeCentOS Automation with Ansible: Infrastructure as CodeApr 10, 2025 am 09:40 AM

Use Ansible to implement automated management of CentOS. The specific steps include: 1) writing a playbook to define tasks, such as installing and configuring Apache; 2) executing the playbook through the SSH protocol to ensure consistency of system configuration; 3) using conditional judgment and loop functions to handle complex scenarios; 4) optimizing performance and following best practices, such as using asynchronous tasks and optimizing inventory files.

CentOS Interview Questions: Ace Your Linux System Administrator InterviewCentOS Interview Questions: Ace Your Linux System Administrator InterviewApr 09, 2025 am 12:17 AM

Frequently asked questions and answers to CentOS interview include: 1. Use the yum or dnf command to install software packages, such as sudoyumininstallnginx. 2. Manage users and groups through useradd and groupadd commands, such as sudouseradd-m-s/bin/bashnewuser. 3. Use firewalld to configure the firewall, such as sudofirewall-cmd--permanent-add-service=http. 4. Set automatic updates to use yum-cron, such as sudoyumininstallyum-cron and configure apply_updates=yes.

CentOS Troubleshooting: Diagnosing and Resolving Common IssuesCentOS Troubleshooting: Diagnosing and Resolving Common IssuesApr 08, 2025 am 12:09 AM

How to diagnose and solve common problems in CentOS system? First, check the startup log to solve the failure of system startup; second, check the network configuration file to solve the network problem; finally, use the Yum command to solve the package management problem. Through these steps, you can effectively diagnose and resolve common problems in CentOS systems.

CentOS Security Hardening: Protecting Your Server from IntrudersCentOS Security Hardening: Protecting Your Server from IntrudersApr 07, 2025 am 12:05 AM

CentOS server security reinforcement can be achieved through the following steps: 1. Keep the system software updated and use the "sudoyumupdate-y" command; 2. Disable unnecessary services, such as "sudosystemctldisablecups&&sudosystemctlstopcups"; 3. Configure SELinux as mandatory mode, use the "sudosetenforce1&&sudosed-i's/SELINUX=permissive/SELINUX=enforcing/g'/etc/selinux/config" command; 4. Regularly

Advanced CentOS System Administration: Mastering the Command LineAdvanced CentOS System Administration: Mastering the Command LineApr 06, 2025 am 12:10 AM

Advanced command line management skills of CentOS include: 1. Use systemctl to manage system services, 2. Use top to monitor system resources, 3. Use yum to manage software packages, 4. Use find and xargs to batch process files, 5. Use rsync to optimize file copying. These techniques can improve productivity, solve common problems, and optimize system performance.

CentOS Server Management: User Accounts, Permissions, and ServicesCentOS Server Management: User Accounts, Permissions, and ServicesApr 05, 2025 am 12:01 AM

In CentOS, how to manage user accounts, permissions and services? 1. Use the useradd command to create a user, 2. Use the usermod and groupmod commands to manage user permissions, 3. Use the systemd to manage services, such as the systemctlstart/stop/status command. Through these steps, CentOS servers can be managed efficiently to ensure their safe and efficient operation.

See all articles

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

AI Hentai Generator

AI Hentai Generator

Generate AI Hentai for free.

Hot Article

R.E.P.O. Energy Crystals Explained and What They Do (Yellow Crystal)
3 weeks agoBy尊渡假赌尊渡假赌尊渡假赌
R.E.P.O. Best Graphic Settings
3 weeks agoBy尊渡假赌尊渡假赌尊渡假赌
R.E.P.O. How to Fix Audio if You Can't Hear Anyone
3 weeks agoBy尊渡假赌尊渡假赌尊渡假赌
WWE 2K25: How To Unlock Everything In MyRise
3 weeks agoBy尊渡假赌尊渡假赌尊渡假赌

Hot Tools

MantisBT

MantisBT

Mantis is an easy-to-deploy web-based defect tracking tool designed to aid in product defect tracking. It requires PHP, MySQL and a web server. Check out our demo and hosting services.

Dreamweaver Mac version

Dreamweaver Mac version

Visual web development tools

ZendStudio 13.5.1 Mac

ZendStudio 13.5.1 Mac

Powerful PHP integrated development environment

MinGW - Minimalist GNU for Windows

MinGW - Minimalist GNU for Windows

This project is in the process of being migrated to osdn.net/projects/mingw, you can continue to follow us there. MinGW: A native Windows port of the GNU Compiler Collection (GCC), freely distributable import libraries and header files for building native Windows applications; includes extensions to the MSVC runtime to support C99 functionality. All MinGW software can run on 64-bit Windows platforms.

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use