GRANT ALL PRIVILEGES ON *.* TO 'user'@'localhost' IDENTIFIED BY 'something' WITH GRANT OPTION;
[b]此命令需root用户[/b]
mysql默认只能localhost访问,如果需要外部访问,也可以用这条命令设置。
GRANT ALL PRIVILEGES ON *.* TO 'user'@'[color=red]hostname[/color]' IDENTIFIED BY 'something' WITH GRANT OPTION;
[b]此命令需root用户[/b]
mysql默认只能localhost访问,如果需要外部访问,也可以用这条命令设置。
GRANT ALL PRIVILEGES ON *.* TO 'user'@'[color=red]hostname[/color]' IDENTIFIED BY 'something' WITH GRANT OPTION;