Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

Operation steps for xshell to build mysql

2025-02-24 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)06/01 Report--

This article is to share with you about the steps of building mysql in xshell. The editor thought it was very practical, so I shared it with you as a reference. Let's follow the editor and have a look.

Xshell's method to build mysql: first install repo; then start mysql and obtain a temporary password; then log in to mysql and change the temporary password to your own password; finally, log in with the modified password.

Xshell's method of building mysql:

1. If there is no mysql package to download on the official website, you need to download the yum repo configuration file on the official website of mysql.

2. See if there is a mysql package in / opt.

3. Install repo:

Rpm-ivh mysql57-community-release-el7-9.noarch.rpm

4. Check whether two repo files mysql-community.repo,mysql-community-source.repo are generated in the / etc/yum.repos.d/ directory.

5. Use the yum command to complete the installation

Yum install mysql-server

6. Start mysql

Systemctl start mysqld

7. Get a temporary password

Grep 'temporary password' / var/log/mysqld.log

7.1 if no temporary password is obtained, delete the residual data of the previously installed mysql

Rm-rf / var/lib/mysql

7.2 restart msql

8. Log in to mysql

Mysql-u root-p

9. Change the temporary password to your own password

Set password=password ("yourpassword")

Point: when you get to step 9, a lot of people will have this problem.

Solution:

10. Exit mysql

Quit

11. Log in with the modified password.

Thank you for reading! This is the end of the procedure for xshell to build mysql. I hope the above content can be of some help to you, so that you can learn more knowledge. If you think the article is good, you can share it and let more people see it.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report