创建数据库添加用户并授予相应的权限:
mysql> create database phpbb;
Query OK, 1 row affected (0.02 sec) mysql> use phpbb;
Database changed
mysql> grant create,select,update,insert,delete,alter
-> on phpbb.*
-> to phpbbroot@localhost identified by '52netseek';
Query OK, 0 rows affected (0.00 sec) phpbbroot 是要授该数据库予权限的用户,'52netseek'是密码授予所有的权限:
>grant all privileges
>on bbs.*
>to bbsroot@localhost identified by '52netseek'
mysql> create database phpbb;
Query OK, 1 row affected (0.02 sec) mysql> use phpbb;
Database changed
mysql> grant create,select,update,insert,delete,alter
-> on phpbb.*
-> to phpbbroot@localhost identified by '52netseek';
Query OK, 0 rows affected (0.00 sec) phpbbroot 是要授该数据库予权限的用户,'52netseek'是密码授予所有的权限:
>grant all privileges
>on bbs.*
>to bbsroot@localhost identified by '52netseek'
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货