Fulltext results:

MySQL: Backup @info:mysql:database

1 Hits, Last modified: 13 years ago

# sleep 10 # optional done wait # for child processes to end </code> {{tag>mysql admin backup export}}

MySQL: Create User @info:mysql:user

1 Hits, Last modified: 10 years ago

ALL ON `dbname`.* TO 'dbuser'@'dbhost' IDENTIFIED BY 'dbpass'; </code> {{tag>admin database mysql sql}}

MySQL: Revoke Permissions @info:mysql:permissions

1 Hits, Last modified: 13 years ago

ode sql> REVOKE ALL PRIVILEGES ON `{db}` . * FROM '{user}'@'%'; </code> {{tag>admin database mysql sql}}

MySQL: Grant Permissions @info:mysql:permissions

1 Hits, Last modified: 13 years ago

<code sql> GRANT ALL PRIVILEGES ON `{db}` . * TO '{user}'@'%'; </code> {{tag>admin database mysql sql}}

MySQL: View Permissions @info:mysql:permissions

1 Hits, Last modified: 13 years ago

==== <code sql> SHOW PRIVILEGES; SHOW GRANTS FOR '{user}'@'%'; </code> {{tag>admin database mysql sql}}

MySQL: Remove User @info:mysql:user

1 Hits, Last modified: 13 years ago

{db} <code sql> DROP USER '{user}'@'%'; DROP DATABASE '{db}'; </code> {{tag>admin database mysql sql}}

MySQL: Change Password @info:mysql:user

1 Hits, Last modified: 12 years ago

ORD('{passwd}') WHERE User='{user}'; FLUSH PRIVILEGES; </code> {{tag>admin database mysql password sql}}

MySQL: Remove Database @info:mysql:database

1 Hits, Last modified: 13 years ago

emove Database ==== <code sql> DROP DATABASE IF EXISTS `{db}`; </code> {{tag>admin database mysql sql}}

MySQL: Create Database @info:mysql:database

1 Hits, Last modified: 13 years ago

STS `{db}`; GRANT ALL PRIVILEGES ON `{db}` . * TO '{user}'@'%'; </code> {{tag>admin database mysql sql}}