Sunday, March 16, 2008

create mysql user and give permissions to access

$cmd:create user username


$cmd:grant all privileges on *.* to 'username'@'ipadress' identified by
'password' with grant option;

'*':the 1st '*' represents which databases you want to acces

'username': for which username you want to give permissions
'ipaddress': from which ipaddress you want to access, you can put localhost for local systema and '%' for all the systems in the network.(you can give both one at each time)

'password': for which password you want access

No comments: