mysql减少非root用户权限_数据库上手避坑之--赋予非root用户操作数据库的所有权限...

MariaDB [student_info]> create tablestu_info(　　　　//创建表-> stuId int(11),　　　　　　　　　　　　　　　　 //->是sql语句的提示符号，不是输入命令的一个部分-> stuName varchar(40),-> gender varchar(10),-> phone int(11),-> email varchar(40),-> account varchar(40),-> code varchar(40),-> adminId int(1));

Query OK,0 rows affected (0.166sec)

MariaDB[student_info]>show tables;　　　　　　　　　　//查看数据student_info中表+------------------------+

| Tables_in_student_info |

+------------------------+

| stu_info |

+------------------------+

1 row in set (0.001sec)

MariaDB[student_info]>describe stu_info;　　　　　　//查看表stu_info基本结构+---------+-------------+------+-----+---------+-------+

| Field | Type | Null | Key | Default | Extra |

+---------+-------------+------+-----+---------+-------+

| stuId | int(11) | YES | | NULL | |

| stuName | varchar(40) | YES | | NULL | |

| gender | varchar(10) | YES | | NULL | |

| phone | int(11) | YES | | NULL | |

| email | varchar(40) | YES | | NULL | |

| account | varchar(40) | YES | | NULL | |

| code | varchar(40) | YES | | NULL | |

| adminId | int(1) | YES | | NULL | |

+---------+-------------+------+-----+---------+-------+

8 rows in set (0.002sec)

MariaDB[student_info]> show create tablestu_info;　　//查看表stu_info详细结构语句+----------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

| Table | Create Table |

+----------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

| stu_info | CREATE TABLE`stu_info` (

`stuId`int(11) DEFAULT NULL,

`stuName`varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,

`gender`varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,

`phone`int(11) DEFAULT NULL,

`email`varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,

`account`varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,

`code`varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,

`adminId`int(1) DEFAULT NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci |

+----------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

1 row in set (0.000 sec)