Fulltext results:

MySQL: Create User

3 Hits, Last modified: 9 years ago

EATE USER '{user}'@'%' IDENTIFIED BY '{passwd}'; GRANT USAGE ON * . * TO '{user}'@'%' IDENTIFIED BY '{... TIONS 0 ; CREATE DATABASE IF NOT EXISTS `{db}`; GRANT ALL PRIVILEGES ON `{db}` . * TO '{user}'@'%'; </... T EXISTS `dbname` DEFAULT CHARACTER SET = 'utf8'; GRANT ALL ON `dbname`.* TO 'dbuser'@'dbhost' IDENTIFIED

MySQL: Change Password

1 Hits, Last modified: 11 years ago

''{user}'' with the name of the user. <code sql> GRANT USAGE ON *.* TO '{user}'@'%' IDENTIFIED BY '{pass