MySQL Tutorial/Privilege/Remote User

Материал из SQL эксперт
Версия от 09:49, 26 мая 2010; Admin (обсуждение | вклад) (1 версия)
(разн.) ← Предыдущая | Текущая версия (разн.) | Следующая → (разн.)
Перейти к: навигация, поиск

Designate an IP or host address from which the user can connect

GRANT ALL PRIVILEGES
ON myDatabase.*
TO newuser@192.168.0.2
IDENTIFIED BY "newpassword";


Give a non-local user permissions on the database for use with remote clients.

GRANT ALL PRIVILEGES
ON myDatabase.*
TO newuser@192.168.0.2
IDENTIFIED BY "newpassword";
Now a user on the machine "192.168.0.2" can connect to the database.


To allow a user to connect from anywhere you would use a wildcard "%"

GRANT ALL PRIVILEGES
ON myDatabase.*
TO newuser@"%"
IDENTIFIED BY "newpassword";