Fulltext results:

MySQL: Change Password

8 Hits, Last modified: 12 years ago

====== MySQL: Change Password ====== * Replace ''{passwd}'' with the password of the user. * Replace ''{user}'' with the name of the user. <code sql> GRANT USAGE ON *.* TO '{user}'@'%' IDENTIFIED BY '{passwd}'; FLUSH PRIVILEGES; </code> Or you can altern

MySQL: Create User

4 Hits, Last modified: 10 years ago

ode sql> CREATE USER '{user}'@'%' IDENTIFIED BY '{passwd}'; </code> ==== Create User and Database ==== ... ode sql> CREATE USER '{user}'@'%' IDENTIFIED BY '{passwd}'; GRANT USAGE ON * . * TO '{user}'@'%' IDENTIFIED BY '{passwd}' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNEC... ALL ON `dbname`.* TO 'dbuser'@'dbhost' IDENTIFIED BY 'dbpass'; </code> {{tag>admin database mysql sql}}