Fulltext results:

MySQL: Create User @info:mysql:user

4 Hits, Last modified: 9 years ago

te User ==== <code sql> CREATE USER '{user}'@'%' IDENTIFIED BY '{passwd}'; </code> ==== Create User ... == ''{db}'' <code sql> CREATE USER '{user}'@'%' IDENTIFIED BY '{passwd}'; GRANT USAGE ON * . * TO '{user}'@'%' IDENTIFIED BY '{passwd}' WITH MAX_QUERIES_PER_HO... f8'; GRANT ALL ON `dbname`.* TO 'dbuser'@'dbhost' IDENTIFIED BY 'dbpass'; </code> {{tag>admin databas

MySQL: Change Password @info:mysql:user

1 Hits, Last modified: 11 years ago

r. <code sql> GRANT USAGE ON *.* TO '{user}'@'%' IDENTIFIED BY '{passwd}'; FLUSH PRIVILEGES; </code>

MySQL: Backup @info:mysql:database

1 Hits, Last modified: 12 years ago

S} ${DB} </code> ===== Export all Databases individually ===== <code bash> # set or replace the vari