赋予所有用户访问权限
mysql> GRANT ALL PRIVILEGES ON *.* TO root@"%" IDENTIFIED BY "123456";
mysql> flush privileges;
赋予指定用户权限
grant all PRIVILEGES on discuz.* to ted@'123.123.123.123' identified by '123456';
赋予所有用户访问权限
mysql> GRANT ALL PRIVILEGES ON *.* TO root@"%" IDENTIFIED BY "123456";
mysql> flush privileges;
赋予指定用户权限
grant all PRIVILEGES on discuz.* to ted@'123.123.123.123' identified by '123456';