


Detailed steps to install MySQL 5.7.12 under CentOS 6.5 (pictures and text)
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
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*
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
Start the Mysql service
# service mysqld start 初始化 MySQL 数据库: [确定] Installing validate password plugin: [确定] 正在启动 mysqld:
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
SLES PlatformUse the following commands:
grep 'temporary password' /var/log/mysql/mysqld.log
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>
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!';
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
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!

Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

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

Hot Article

Hot Tools

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics

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

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.

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 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 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.

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

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.

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
