1、创建数据库school,字符集为utf8
CREATE DATABASE school CHARACTER SET utf8;
2、在school数据库中创建Student和Score表
CREATE TABLE Student (Id INT ( 10 ) AUTO_INCREMENT PRIMARY KEY,Stu_id INT(10) NOT NULL,C_name VARCHAR(20),Grade INT(10))
CREATE TABLE Score (Id INT(10) AUTO_INCREMENT PRIMARY KEY,Name VARCHAR(50),Sex VARCHAR(4),Birth YEAR,Department VARCHAR(20) NOT NULL,Address VARCHAR(50));
3、授权用户tom,密码Mysql@123,能够从任何地方登录并管理数据库school。
create user 'aa'@'%' identified by 'Mysql@123';
4、使用mysql客户端登录服务器,重置root密码
ALTER USER 'root'@'localhost' IDENTIFIED BY 'Mysql@123';