Quote:
|
GRANT ALL PRIVILEGES ON <DBname>.<Table> TO <UserName>@<IP> IDENTIFIED BY '<Password>' WITH GRANT OPTION;
|
Where
-Dbname is an existing DB or any name you used to create a DB.
-UserName can be any user including root.
-IP can be any private, internal or external IP including localhost.
-Password MUST be the password assigned to the user.
Examples:
Quote:
GRANT ALL PRIVILEGES ON eq.* TO velox@192.168.0.101 IDENTIFIED BY 'veloxpass' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON velius.* TO belfedia@localhost IDENTIFIED BY 'belfpass' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO guest@10.0.0.1 IDENTIFIED BY 'nopass' WITH GRANT OPTION;
|