Creating a mysql user

From MyWiki

Revision as of 14:29, 11 June 2015 by George2 (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Jump to: navigation, search

GRANT ALL PRIVILEGES ON <database>.* TO 'newuser'@'localhost';
use the ip as well
GRANT ALL PRIVILEGES ON <database>.* TO 'newuser'@'127.0.0.1';

Retrieved from "https://wiki.twig.es/index.php?title=Creating_a_mysql_user&oldid=2075"