3 Wrz
2007
3 Wrz
'07
15:26
Konrad wrote:
CREATE USER 'lms'@'%' IDENTIFIED BY PASSWORD '***'; GRANT USAGE ON * . * TO 'lms'@'%' IDENTIFIED BY PASSWORD '***' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;
GRANT ALL PRIVILEGES ON `lms` . * TO 'lms'@'%' WITH GRANT OPTION ;
Tak będzie?
tak, czasami problemy z uprawnieniami wynikają z wykonywania aktualizacji mysqla bez odpalenia mysql_upgrade (mysql_fix_privilege_tables).
--
Aleksander 'A.L.E.C' Machniak http://alec.pl gg:2275252
LAN Management System Developer http://lms.org.pl
_______________________________________________
lms mailing list
lms@lists.lms.org.pl
http://lists.lms.org.pl/mailman/listinfo/lms