Django

mysql 8.0以上修改root密码

1. 生成Data文件

   mysqld --initialize-insecure --user=mysql 
   

2. 启动服务

   net start mysql
   

3. 登录mysql

   mysql -u root -p
   

4. 查询用户密码

   select host,user,authentication_string from mysql.user;
   

5. 设置root用户密码

   update user set authentication_string='' where user='root';
   ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'Kuai123#';
   FLUSH PRIVILEGES;
   

6. 创建库

   CREATE DATABASE video CHARACTER SET utf8;
   

7. pycharm 的url

      jdbc:mysql://localhost:3306/video?useSSL=false&serverTimezone=UTC