Table of Contents
Download the installation package
Extract the installation package
Remove the installed earlier version
Installation sequence
Start the Mysql service
Change the administrator password
Authorize remote login
Conclusion
Home Database Mysql Tutorial Detailed steps to install MySQL 5.7.12 under CentOS 6.5 (pictures and text)

Detailed steps to install MySQL 5.7.12 under CentOS 6.5 (pictures and text)

Apr 02, 2017 pm 06:00 PM
centos mysql Install

To install MySQL 5.7.12 under CentOS 6.5, use the rpm installation package downloaded from the official website

Download the installation package

You can refer to this:How to download the latest version of MySQL from the official website Installation package?

Extract the installation package

tar -xvf mysql-5.7.12-1.el6.x86_64.rpm-bundle.tar
Copy after login

Remove the installed earlier version

If you do not remove it, a conflict will be prompted and the version may be different Different

yum -y remove mysql-libs-5.1.73*
Copy after login

This can refer to:

Solution to prompt conflicts with file from package when installing mysql*.rpm on CentOS

How to completely uninstall MySQL under CentOS? Solve the problem of unclean uninstallation

Installation sequence

rpm -ivh mysql-community-common-5.7.12-1.el6.x86_64.rpm 
rpm -ivh mysql-community-libs-5.7.12-1.el6.x86_64.rpm 
rpm -ivh mysql-community-client-5.7.12-1.el6.x86_64.rpm
rpm -ivh mysql-community-server-5.7.12-1.el6.x86_64.rpm
rpm -ivh mysql-community-devel-5.7.12-1.el6.x86_64.rpm
Copy after login

Start the Mysql service

# service mysqld start
初始化 MySQL 数据库:                                      [确定]
Installing validate password plugin:                       [确定]
正在启动 mysqld:
Copy after login

Change the administrator password

View the initial administrator password, The following commands apply to RHEL, Oracle Linux, CentOS, and Fedora platforms:

grep 'temporary password' /var/log/mysqld.log
Copy after login

SLES PlatformUse the following commands:

grep 'temporary password' /var/log/mysql/mysqld.log
Copy after login

You will find that the initial password is super complicated. Fortunately, I use XShell and can copy and paste

# grep 'temporary password' /var/log/mysqld.log
2016-05-14T02:57:24.372528Z 1 [Note] A temporary password is generated for root@localhost: ?sSq8?.IucXV
[root@localhost /]# 
[root@localhost /]# mysql -uroot -p?sSq8?.IucXV
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 15
Server version: 5.7.12

Copyright (c) 2000, 2016, 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>
Copy after login

Note: This way of writing (mysql -uroot -p ?sSq8?.IucXV) Sometimes it is not feasible due to special characters in the password. You need to execute (mysql -uroot -p) first, and then enter the password according to the prompts.

Use the following command to change the password

ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass4!';
Copy after login

The password must contain uppercase letters, lowercase letters, numbers and symbols, otherwise it will prompt: ERROR 1819 (HY000): Your password does not satisfy the current policy requirements (Your password does not meet the current security policy requirements)

Authorize remote login

Reference: Modify MySQL initial password through Shell under CentOS6.5 , enable remote login, authorize remote login users

If you do not enable remote login permissions, you will encounter an error similar to the following:

Use Navicat for MySQL on the client to connect remotely. Reporting 10038 error

Detailed steps to install MySQL 5.7.12 under CentOS 6.5 (pictures and text)

For the case of this problem, please refer to:mysql remotely reporting 10038 error

Conclusion

Note that the installation using yum is different from the installation using rpm (or the location of the initial password is different after installation of different versions). I remember that after the previous installation The initial password is saved in the /root/.mysql_sercret file.

If you find or encounter any problems during the installation process, please feel free to discuss them together.

Recommended related articles:

mysql 5.7.12 win64 manual installation tutorial steps (pictures and texts)

mysql-5.7.12 decompression Version installation steps tutorial

The above is the detailed content of Detailed steps to install MySQL 5.7.12 under CentOS 6.5 (pictures and text). For more information, please follow other related articles on the PHP Chinese website!

Statement of this Website
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

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

Video Face Swap

Video Face Swap

Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

How to start mysql by docker How to start mysql by docker Apr 15, 2025 pm 12:09 PM

The process of starting MySQL in Docker consists of the following steps: Pull the MySQL image to create and start the container, set the root user password, and map the port verification connection Create the database and the user grants all permissions to the database

Centos shutdown command line Centos shutdown command line Apr 14, 2025 pm 09:12 PM

The CentOS shutdown command is shutdown, and the syntax is shutdown [Options] Time [Information]. Options include: -h Stop the system immediately; -P Turn off the power after shutdown; -r restart; -t Waiting time. Times can be specified as immediate (now), minutes ( minutes), or a specific time (hh:mm). Added information can be displayed in system messages.

MySQL's Role: Databases in Web Applications MySQL's Role: Databases in Web Applications Apr 17, 2025 am 12:23 AM

The main role of MySQL in web applications is to store and manage data. 1.MySQL efficiently processes user information, product catalogs, transaction records and other data. 2. Through SQL query, developers can extract information from the database to generate dynamic content. 3.MySQL works based on the client-server model to ensure acceptable query speed.

Laravel Introduction Example Laravel Introduction Example Apr 18, 2025 pm 12:45 PM

Laravel is a PHP framework for easy building of web applications. It provides a range of powerful features including: Installation: Install the Laravel CLI globally with Composer and create applications in the project directory. Routing: Define the relationship between the URL and the handler in routes/web.php. View: Create a view in resources/views to render the application's interface. Database Integration: Provides out-of-the-box integration with databases such as MySQL and uses migration to create and modify tables. Model and Controller: The model represents the database entity and the controller processes HTTP requests.

Centos stops maintenance 2024 Centos stops maintenance 2024 Apr 14, 2025 pm 08:39 PM

CentOS will be shut down in 2024 because its upstream distribution, RHEL 8, has been shut down. This shutdown will affect the CentOS 8 system, preventing it from continuing to receive updates. Users should plan for migration, and recommended options include CentOS Stream, AlmaLinux, and Rocky Linux to keep the system safe and stable.

How to install mysql in centos7 How to install mysql in centos7 Apr 14, 2025 pm 08:30 PM

The key to installing MySQL elegantly is to add the official MySQL repository. The specific steps are as follows: Download the MySQL official GPG key to prevent phishing attacks. Add MySQL repository file: rpm -Uvh https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm Update yum repository cache: yum update installation MySQL: yum install mysql-server startup MySQL service: systemctl start mysqld set up booting

Centos install mysql Centos install mysql Apr 14, 2025 pm 08:09 PM

Installing MySQL on CentOS involves the following steps: Adding the appropriate MySQL yum source. Execute the yum install mysql-server command to install the MySQL server. Use the mysql_secure_installation command to make security settings, such as setting the root user password. Customize the MySQL configuration file as needed. Tune MySQL parameters and optimize databases for performance.

Centos configuration IP address Centos configuration IP address Apr 14, 2025 pm 09:06 PM

Steps to configure IP address in CentOS: View the current network configuration: ip addr Edit the network configuration file: sudo vi /etc/sysconfig/network-scripts/ifcfg-eth0 Change IP address: Edit IPADDR= Line changes the subnet mask and gateway (optional): Edit NETMASK= and GATEWAY= Lines Restart the network service: sudo systemctl restart network verification IP address: ip addr

See all articles