Add a remote user
-
Type:
GRANT ALL PRIVILEGES ON *.*
TO marty@'%'
IDENTIFIED BY 'watch4keys'
WITH GRANT OPTION;
then press ENTER.
This command string is slightly different than the previous one:
-
TO marty@'%'
GRANT ALL PRIVILEGES ON *.*
TO marty@'%'
IDENTIFIED BY 'watch4keys'
WITH GRANT OPTION;
The % wildcard allows connections on this account from any domain, not just localhost.
If you only wanted connections from the visibooks.com domain, you'd use this instead:
GRANT ALL PRIVILEGES ON *.*
TO marty@visibooks.com
IDENTIFIED BY 'watch4keys'
WITH GRANT OPTION;
-
WITH GRANT OPTION
GRANT ALL PRIVILEGES ON *.*
TO marty@'%'
IDENTIFIED BY 'watch4keys'
WITH GRANT OPTION;
The GRANT OPTION sets the ability to GRANT privileges to other users. In other words, marty can create accounts for new users.