MySQL

From Wasya Wiki
Revision as of 20:58, 3 January 2016 by Piousbox (Talk | contribs) (Created page with " Don't forget to change bind_ip in /etc/mysql/my.cfg to 0.0.0.0! Allow root to login from anywhere. From: http://stackoverflow.com/questions/11223235/mysql-root-access-from-a...")

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Don't forget to change bind_ip in /etc/mysql/my.cfg to 0.0.0.0!

Allow root to login from anywhere. From: http://stackoverflow.com/questions/11223235/mysql-root-access-from-all-hosts

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password';
FLUSH PRIVILEGES;