Allow MYSQL remote admin login By LotusshaneyMarch 9, 2012March 9, 2012Tech CREATE USER 'root'@'%' IDENTIFIED BY 'password'; grant all privileges on *.* to 'root'@'%' identified by 'password'; GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION; can’t connect to mysql MySQL : MySQL 5.1 Reference Manual : 5.5.2 Adding User Accounts