Friday, September 23, 2011

Linux - mySQL

 Grant Remote Access
CREATE USER 'joe.soh'@'%' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON *.* TO 'joe.soh'@'%' WITH GRANT OPTION;

update user set password=PASSWORD("NEW-PASSWORD-HERE") where User='tom';

No comments:

Post a Comment