phpMyAdmin创建数据库无权限

配置以下权限即可：

flush privileges;
grant all ON *.* to 'root'@'localhost' with grant option;
grant all on cactidb.* to root@'localhost' identified by 'root';
grant all on reload.* to root@'localhost' identified by 'root';
grant all on process.* to root@'localhost' identified by 'root';
show grants for 'root'@'localhost';

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

INSERT INTO `all_messages` (`name`, `time`, `content`) VALUE ("Lisi", "2023-3-18", "hungry");