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

Environment: Linux centos8 4.18.0-80.el8.x86_64, Mysql8.0.18

1. Download the RPM package on Mysql's official website

2. Check whether rpm-qa has been installed | grep-I mysql3, delete the rpm-e-- nodeps software name before uninstalling, and delete the related dependent files. 4. Install the client (mysql-client) rpm-ivh rpm package * install mysql-community-common-8.0.18* install mysql-community-libs-8.0.18* install mysql-community-client-8.0.18 (the first two are its dependencies)

5. Install the server (mysql-server)

6. Check whether the installation is successful by the following ways: * ps-ef | grep mysql* cat / etc/group | grep mysql* cat / etc/password | grep mysql* mysqladmin-- version...

7. Initialize mysqlmysqld-- initialize / / create data file directory and mysql system database to generate random root password 8, start mysql service systemctl start mysqld

Startup failed because the / var/lib/mysql directory does not have sufficient permissions

9. / var/lib/mysql directory permissions authorize chown-R mysql:mysql / var/lib/mysql/

10. Start mysql service systemctl start mysqld / / start ps-ef | grep mysql / / View mysql service

11. View the randomly generated root password cat / var/log/mysqld.log for initialization | grep password

12. Security settings mysql_secure_installation

13. Mysql login mysql-uroot-p / / Random password login

14. Reset the password (Mysql8.0+ has changed) first leave the old password of root blank use mysql;update user set authentication_string='' where user='root'; Note: the Mysql5.7+ password field has been changed to the authentication_string field.

Reset to new password alter user 'root'@'localhost' identified by' newpassword'; Note: the way Mysql8.0 changes the password (here is a pit, note) before Mysql8.0: update user set password=password ('root') where user='root'

15. Log in to mysqlmysql-uroot-proot with a new password after exit

16. How to stop, restart and view mysql service systemctl stop mysqld / / stop service systemctl restart mysqld / / restart service systemctl status mysqld / / View service 17. Mysql related installation directory file / usr/bin / / related commands

/ usr/share/mysql / / configuration file directory

/ var/lib/mysql / / Database file storage directory

Startup configuration file for / etc/my.cnf / / mysql

18. The configuration file under the my.ini / / windows operating system the configuration file under the my.cnf / / linux operating system mysqld / / is the background daemon, that is, mysql daemonmysql / / is the client command line

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.