MySql

 

我找到的都太变态了

 

不行

 

我得自己写一个

use mysql;

update user set authentication_string=password('123456') where user='root';


flush privileges;

exit;

mysql -u root -p

 

mysql> use bike;
Database changed
mysql>
mysql> show variables like '%time_zone%';
+------------------+--------+
| Variable_name    | Value  |
+------------------+--------+
| system_time_zone |        |
| time_zone        | SYSTEM |
+------------------+--------+
2 rows in set, 1 warning (0.02 sec)

mysql>
mysql> set global time_zone='+8:00';
Query OK, 0 rows affected (0.03 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.11 sec)

mysql> exit;
Bye