Fulltext results:

MySQL: Create User

3 Hits, Last modified: 9 years ago

'@'%' IDENTIFIED BY '{passwd}' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ; CREATE DATABASE IF NOT EXISTS `{db}`; GRANT ALL PRIVILEGES ON `{db}` . * TO '{user}'@'%'; </code> Simpler

MySQL: Change Password

2 Hits, Last modified: 11 years ago

ser}'@'%' IDENTIFIED BY '{passwd}'; FLUSH PRIVILEGES; </code> Or you can alternatively use the follow... RD('{passwd}') WHERE User='{user}'; FLUSH PRIVILEGES; </code> {{tag>admin database mysql password sql