vlambda博客
学习文章列表

-bash-4.1$ tar -xvf mysql-8.0.23-1.el6.x86_64.rpm-bundle.tarmysql-community-client-8.0.23-1.el6.x86_64.rpmmysql-community-client-plugins-8.0.23-1.el6.x86_64.rpmmysql-community-common-8.0.23-1.el6.x86_64.rpmmysql-community-devel-8.0.23-1.el6.x86_64.rpmmysql-community-libs-8.0.23-1.el6.x86_64.rpmmysql-community-libs-compat-8.0.23-1.el6.x86_64.rpmmysql-community-server-8.0.23-1.el6.x86_64.rpmmysql-community-test-8.0.23-1.el6.x86_64.rpm

shell> rpm -qpl mysql-community-server-version-distribution-arch.rpm

shell> sudo yum install mysql-community-{server,client,common,libs}-*

-bash-4.1$ rpm -qa | grep mysqlmysql-community-common-8.0.23-1.el6.x86_64mysql-community-libs-8.0.23-1.el6.x86_64mysql-community-server-8.0.23-1.el6.x86_64mysql-community-client-8.0.23-1.el6.x86_64mysql-community-client-plugins-8.0.23-1.el6.x86_64mysql-community-libs-compat-8.0.23-1.el6.x86_64

-bash-4.1$ service mysqld statusmysqld is stopped

-bash-4.1$ serviceUsage: service < option > | --status-all | [ service_name [ command | --full-restart ] ]

systemctl status mysqld.service

-bash-4.1$ sudo service start mysqldstart: unrecognized service-bash-4.1$ sudo service mysqld startInitializing MySQL database: [ OK ]Starting mysqld: [ OK ]
-bash-4.1$ sudo service mysqld statusmysqld (pid 28030) is running...

 systemctl start mysqld

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

-bash-4.1$ sudo grep 'temporary password' /var/log/mysqld.log2021-02-16T09:16:36.715031Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: u7hf5?5:4hG4

shell> mysql -uroot -pmysql> ALTER USER 'root'@'localhost' IDENTIFIED BY '密码';

-bash-4.1$ mysql -uroot -pEnter password:Welcome to the MySQL monitor. Commands end with ; or \g.Your MySQL connection id is 10Server version: 8.0.23
Copyright (c) 2000, 2021, Oracle and/or its affiliates.
Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass4!';Query OK, 0 rows affected (0.03 sec)

-bash-4.1$ mysql -uroot -pMyNewPass4!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 11Server version: 8.0.23 MySQL Community Server - GPL
Copyright (c) 2000, 2021, Oracle and/or its affiliates.
Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> show databases;+--------------------+| Database |+--------------------+| information_schema || mysql || performance_schema || sys |+--------------------+4 rows in set (0.01 sec)mysql> use mysqlReading table information for completion of table and column namesYou can turn off this feature to get a quicker startup with -A
Database changedmysql> select Host,User from user;+-----------+------------------+| Host | User |+-----------+------------------+| localhost | mysql.infoschema || localhost | mysql.session || localhost | mysql.sys || localhost | root |+-----------+------------------+4 rows in set (0.00 sec)
mysql> SELECT VERSION(), CURRENT_DATE;+-----------+--------------+| VERSION() | CURRENT_DATE |+-----------+--------------+| 8.0.23 | 2021-02-16 |+-----------+--------------+1 row in set (0.00 sec)