grant all PRIVILEGES on discuz.* to ted@'123.123.123.123' identified by '123456';
其中 discuz是数据库名,ted是用户名,123.123.123.123是指定的ip,123456是设定的密码
添加用户
insert into mysql.user(Host,User,Password) values("localhost","phplamp",password("1234"));
grant all PRIVILEGES on discuz.* to ted@'123.123.123.123' identified by '123456';
其中 discuz是数据库名,ted是用户名,123.123.123.123是指定的ip,123456是设定的密码
添加用户
insert into mysql.user(Host,User,Password) values("localhost","phplamp",password("1234"));