MySQL授权密码

mysql> crate databases school charcter set utf8;
Query OK, 1 row affected, 1 warning (0.00 sec)

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@123，能够从任何地方登录并管理数据库schoo。

mysql> create user tom@'localhost' identified by 'Mysql@123';
Query OK, 0 rows affected (0.00 sec)mysql>