一.题目要求
1.创建数据库school,字符集为utf8
2.在school数据库中创建Student和Score表
3.授权用户tom,密码Mysql@123,能够从任何地方登录并管理数据库school。
4.使用mysql客户端登录服务器,重置root密码
二.代码实现
1.创建数据库school,字符集为utf8
mysql> create database school;
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| myemployees |
| mysql |
| mysql1 |
| performance_schema |
| school |
| sys |
| test |
+--------------------+
8 rows in set (0.01 sec)
添加配置信息
[root@server ~]# vim /etc/my.cnf
2.建立school表
mysql> use school
Database changed
mysql> create table student
->
-> (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)
-> );
3.建立score表
mysql> create table score(
-> id int(10) primary key auto_increment,
-> stu_id int(10) not null,
-> c_name varchar(20),
-> crade int(10)
-> );
4.授权用户tom,密码Mysql@123,能够从任何地方登录并管理数据库school
mysql> create user tom@'localhost' identified by'Mysql@123';