笺注:只有数据库管理员root可以创建数据库用户。
服务器本地查看数据库管理员root@localhost的权限:
[root@localhost ~]# mysql -u"root" -p"888" -e "show grants for root@localhost"
+----------------------------------------------------------------------------------------------------------------------------------------+
| Grants for root@localhost |
+----------------------------------------------------------------------------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD '*41DDB5DFD213B288EE050BD64DC6AA36815A3486' WITH GRANT OPTION |
| GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION |
+----------------------------------------------------------------------------------------------------------------------------------------+
服务器本地查看数据库本地用户zhuohua@localhost的权限:
[root@localhost ~]# mysql -u"root" -p"888" -e "show grants for zhuohua@localhost"
+-------------------------------------------------------------------------------------------------------------------------+
| Grants for zhuohua@localhost |
+-------------------------------------------------------------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'zhuohua'@'localhost' IDENTIFIED BY PASSWORD '*23AE809DDACAF96AF0FD78ED04B6A265E05AA257' |
+-------------------------------------------------------------------------------------------------------------------------+
使用数据库本地用户zhuohua@localhost登录phpMyAdmin:
笺注:数据库用户zhuohua@localhost可以创建数据库,但不可以创建数据库用户。
使用phpMyAdmin里的SQL查询:(在指定数据库里,创建表)
use db1;
create table t_1(
id int not null auto_increment,
name varchar(20) not null,
grade varchar(10),
age float default 60,
ruxueriqi datetime,
chinese decimal(50, 2),
math numeric(60, 3),
primary key (id)
);