创建数据库school,字符集为utf8
2、在school数据库中创建Student和Score表
素材看图
3、授权用户tom,密码Mysql@123,能够从任何地方登录并管理数据库school。
4、使用mysql客户端登录服务器,重置root密码.
1、创建数据库school,字符集为utf8
创建数据库school:
mysql> create database school;
设置字符集为utf8 :
[root@mysqlserver ~]# vim /etc/my.cnf //在该配置文件中添加如下信息
[mysqld]
character-set-server=utf8
2、在school数据库中创建Student和Score表
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)
-> );
Query OK, 0 rows affected (0.01 sec)
mysql> desc student;
+------------+-------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------+-------------+------+-----+---------+----------------+
| id | int(10) | NO | PRI | NULL | auto_increment |
| name | varchar(20) | NO | | NULL | |
| sex | varchar(4) | YES | | NULL | |
| birth | year(4) | YES | | NULL | |
| department | varchar(20) | NO | | NULL | |
| address | varchar(50) | YES | | NULL | |
+------------+-------------+------+-----+---------+----------------+
6 rows in set (0.00 sec)
mysql> create table score(
-> id int(10) primary key auto_increment,
-> Stu_id int(10) not null,
-> C_name varchar(20),
-> Grade int(10)
-> );
Query OK, 0 rows affected (0.01 sec)
mysql> desc score;
+--------+-------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+--------+-------------+------+-----+---------+----------------+
| id | int(10) | NO | PRI | NULL | auto_increment |
| Stu_id | int(10) | NO | | NULL | |
| C_name | varchar(20) | YES | | NULL | |
| Grade | int(10) | YES | | NULL | |
+--------+-------------+------+-----+---------+----------------+
4 rows in set (0.00 sec)
3、授权用户tom,密码mysql,能够从任何地方登录并管理数据库school
mysql> create user tom@'192.168.157.%' identified by 'Tom@1234';
Query OK, 0 rows affected (0.00 sec)
mysql> grant all on school.* to tom@'192.168.157.%';
Query OK, 0 rows affected (0.01 sec)
使用客户端登录