??????????MySQL?????
???????????? ???????[ 2016/3/23 10:51:54 ] ????????????? MySQL
????2.1 ????????
1 [root@Mysql_server tools]# mysql -uroot -p
2 Enter password:
3 Welcome to the MySQL monitor. Commands end with ; or g.
4 Your MySQL connection id is 8
5 Server version: 5.5.32 MySQL Community Server (GPL)
6
7 Copyright (c) 2000?? 2013?? Oracle and/or its affiliates. All rights reserved.
8
9 Oracle is a registered trademark of Oracle Corporation and/or its
10 affiliates. Other names may be trademarks of their respective
11 owners.
12
13 Type 'help;' or 'h' for help. Type 'c' to clear the current input statement.
14
15 mysql> show databases; ##???????
16 +--------------------+
17 | Database |
18 +--------------------+
19 | information_schema |
20 | mysql |
21 | performance_schema |
22 | test |
23 +--------------------+
24 4 rows in set (0.00 sec)
25
26 mysql> drop database test; ##???test??
27 Query OK?? 0 rows affected (0.00 sec)
28
29 mysql> show databases;
30 +--------------------+
31 | Database |
32 +--------------------+
33 | information_schema |
34 | mysql |
35 | performance_schema |
36 +--------------------+
37 3 rows in set (0.00 sec)
38
39 mysql> select user??host from mysql.user; ##??????б??
40 +------+---------------+
41 | user | host |
42 +------+---------------+
43 | root | 127.0.0.1 |
44 | root | ::1 |
45 | | Mysql\_server |
46 | root | Mysql\_server |
47 | | localhost |
48 | root | localhost |
49 +------+---------------+
50 6 rows in set (0.00 sec)
51
52 mysql> drop user root@'::1'; ##??????????
53 Query OK?? 0 rows affected (0.00 sec)
54
55 mysql> drop user ''@'Mysql\_server'; ##?????д??????????????????????н???
56 Query OK?? 0 rows affected (0.00 sec)
57
58 mysql> drop user ''@'localhost';
59 Query OK?? 0 rows affected (0.01 sec)
60
61 mysql> drop user 'root'@'Mysql\_server'; ?????д??????????????????????н???
62 Query OK?? 0 rows affected (0.00 sec)
63
64 mysql> select user??host from mysql.user;
65 +------+---------------+
66 | user | host |
67 +------+---------------+
68 | root | 127.0.0.1 |
69 | | Mysql\_server |
70 | root | Mysql\_server |
71 | root | localhost |
72 +------+---------------+
73 4 rows in set (0.00 sec)
74 ?????д??????????????????????
75 mysql> delete from mysql.user where user="" and host="Mysql\_server";
76 Query OK?? 1 row affected (0.02 sec)
77
78 mysql> delete from mysql.user where user="root" and host="Mysql\_server";
79 Query OK?? 1 row affected (0.00 sec)
80
81 mysql> select user??host from mysql.user; ##?????????????????????б?
82 +------+-----------+
83 | user | host |
84 +------+-----------+
85 | root | 127.0.0.1 |
86 | root | localhost |
87 +------+-----------+
88 2 rows in set (0.00 sec)
89 mysql> flush privileges; ##??????????Ч
90 Query OK?? 0 rows affected (0.00 sec)
???????????sql???
????1 mysql> grant all on *.* to 'root'@'localhost' identified by '123456' with grant option;flush privileges;
???????????????????????漰???????????????????SPASVOС??(021-61079698-8054)?????????????????????????
??????
???mysql?????????????mysql????? distinct?÷?MySQL?н???????????з??Mysql?????????MySQL Cluster??δ????????????????ν?MySQL??????????300???????MySQL???Uber???????????????????MySql SQL??????????MySQL?????????????????λЧ?????SQL???Java???????:?????MySQL???????linux?°??mysql????MySQL ???????????????????binlog??MySQL????????????Щ??????MySQL???????Mysql???????JDBC?????mysql?????
???·???
??????????????????
2023/3/23 14:23:39???д?ò??????????
2023/3/22 16:17:39????????????????????Щ??
2022/6/14 16:14:27??????????????????????????
2021/10/18 15:37:44???????????????
2021/9/17 15:19:29???·???????·
2021/9/14 15:42:25?????????????
2021/5/28 17:25:47??????APP??????????
2021/5/8 17:01:11????????
?????????App Bug???????????????????????Jmeter?????????QC??????APP????????????????app?????е????????jenkins+testng+ant+webdriver??????????????JMeter????HTTP???????Selenium 2.0 WebDriver ??????