MySQL表操作

创建数据库school，字符集为utf8

create database school default character set utf8 collate utf8_general_ci;

在school数据库中创建student表和score表

# 创建student表
mysql> create table school(
    -> id int(10) primary key auto_increment,
    -> name varchar(20) not null,
    -> sex varchar(4),
    -> birth year,
    -> department varchar(20) not null,
    -> address varchar(50)
    -> );
#创建score表
mysql> create table score(
    -> id int(10) primary key auto_increment,
    -> stu_id int(10) not null,
    -> c_name varchar(20),
    -> grade int(10)
    -> );

授权用户Tom，可以从任何地方登录并且管理数据库

#1、创建用户
create user Tom@'%' identified by 'Mysql@123'
    -> ;
#2、再给创建的用户授权
grant all privileges on *.* to 'Tom'@'%' with grant option;##授予他所有权限
#3、刷新配置
flush privileges;

更改Root账户密码

update mysql.user set authentication_string='Mysql@456' where user='root';
flush privileges;#刷新配置