mysql使用笔记一

[root@localhost local]# grep 'temporary password' /var/log/mysqld.log
-06-16T04::36.398736Z  [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: oyazXUIps8)F
[root@localhost local]# mysql -uroot -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 
Server version: 8.0.29

Copyright (c) , , Oracle and/or its affiliates.

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> SHOW VARIABLES LIKE 'validate_password.%';
ERROR  (HY000): You must reset your password using ALTER USER statement before executing this statement.
mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '1234@abcd';
ERROR  (HY000): Your password does not satisfy the current policy requirements
mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '1qaz!QAZ';
Query OK,  rows affected (0.01 sec)

mysql> SHOW VARIABLES LIKE 'validate_password.%';
+--------------------------------------+--------+
| Variable_name                        | Value  |
+--------------------------------------+--------+
| validate_password.check_user_name    | ON     |
| validate_password.dictionary_file    |        |
| validate_password.length             |       |
| validate_password.mixed_case_count   |       |
| validate_password.number_count       |       |
| validate_password.policy             | MEDIUM |
| validate_password.special_char_count |       |
+--------------------------------------+--------+
 rows in set (0.02 sec)

mysql> set global validate_password.length=;
Query OK,  rows affected (0.00 sec)

mysql> set global validate_password.policy=;
Query OK,  rows affected (0.00 sec)

mysql> set global validate_password.check_user_name=off;
Query OK,  rows affected (0.00 sec)

mysql> SHOW VARIABLES LIKE 'validate_password.%';
+--------------------------------------+-------+
| Variable_name                        | Value |
+--------------------------------------+-------+
| validate_password.check_user_name    | OFF   |
| validate_password.dictionary_file    |       |
| validate_password.length             |      |
| validate_password.mixed_case_count   |      |
| validate_password.number_count       |      |
| validate_password.policy             | LOW   |
| validate_password.special_char_count |      |
+--------------------------------------+-------+
 rows in set (0.01 sec)

mysql> use mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> select host,user from user where user='root';
+-----------+------+
| host      | user |
+-----------+------+
| localhost | root |
+-----------+------+
 row in set (0.00 sec)

mysql> update user set host='%' where user='root';
Query OK,  row affected (0.01 sec)
Rows matched:   Changed:   Warnings: 

mysql> select host,user from user where user='root';
+------+------+
| host | user |
+------+------+
| %    | root |
+------+------+
 row in set (0.00 sec)

mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
ERROR  (): You are not allowed to create a user with GRANT
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
Query OK,  rows affected (0.01 sec)

mysql> FLUSH PRIVILEGES;
Query OK,  rows affected (0.01 sec)

mysql> 

[root@localhost local]# netstat -anpt 
Active Internet connections (servers and established)
Proto Recv-Q Send-Q Local Address           Foreign Address         State       PID/Program name    
tcp               ...:              ...:*               LISTEN      /sshd           
tcp               127.0..:            ...:*               LISTEN      /master         
tcp              192.168.13.50:        123.123.123.2:     ESTABLISHED /sshd: root@pts 
tcp               192.168.13.50:        192.168.13.11:     ESTABLISHED /sshd: root@pts 
tcp               192.168.13.50:        123.123.123.2:     ESTABLISHED /sshd: root@pts 
tcp6              :::                 :::*                    LISTEN      /mysqld         
tcp6              :::                   :::*                    LISTEN      /sshd           
tcp6              :::                  :::*                    LISTEN      /master         
tcp6              :::                :::*                    LISTEN      /mysqld         
pid-file=/var/run/mysqld/mysqld.pid
[root@localhost local]# vi /etc/my.cnf  
# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/8.0/en/server-configuration-defaults.html

[mysqld]

datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock

log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

bind-address=...
"/etc/my.cnf" L, C written
[root@localhost local]# firewall-cmd --zone=public --add-port=3306/tcp --permanent
success
[root@localhost local]# firewall-cmd --reload 
success
[root@localhost local]#