MySql

 

我找到的都太变态了

 

不行

 

我得自己写一个

 1 use mysql;
 2 
 3 update user set authentication_string=password('123456') where user='root';
 4 
 5 
 6 flush privileges;
 7 
 8 exit;
 9 
10 mysql -u root -p

 

 1 mysql> use bike;
 2 Database changed
 3 mysql>
 4 mysql> show variables like '%time_zone%';
 5 +------------------+--------+
 6 | Variable_name    | Value  |
 7 +------------------+--------+
 8 | system_time_zone |        |
 9 | time_zone        | SYSTEM |
10 +------------------+--------+
11 2 rows in set, 1 warning (0.02 sec)
12 
13 mysql>
14 mysql> set global time_zone='+8:00';
15 Query OK, 0 rows affected (0.03 sec)
16 
17 mysql> flush privileges;
18 Query OK, 0 rows affected (0.11 sec)
19 
20 mysql> exit;
21 Bye

 

转载于:https://www.cnblogs.com/ming-michelle/p/10725740.html