Fulltext results:
- andunix Infos @info:mysql:permissions
- ===== andunix Infos ===== {{indexmenu>info:#1 .:#1}} ===== Tags ===== ~~TAGCLOUD:50~~
- andunix Infos @info:mysql:user
- ===== andunix Infos ===== {{indexmenu>info:#1 .:#1}} ===== Tags ===== ~~TAGCLOUD:50~~
- andunix Infos
- ===== andunix Infos ===== {{indexmenu>info:#1 .:#1}} ===== Tags ===== ~~TAGCLOUD:50~~
- andunix Infos @info:mysql:database
- ===== andunix Infos ===== {{indexmenu>info:#1 .:#1}} ===== Tags ===== ~~TAGCLOUD:50~~
- MySQL: Backup @info:mysql:database
- # sleep 10 # optional done wait # for child processes to end </code> {{tag>mysql admin backup export}}
- MySQL: Create User @info:mysql:user
- LL ON `dbname`.* TO 'dbuser'@'dbhost' IDENTIFIED BY 'dbpass'; </code> {{tag>admin database mysql sql}}
- MySQL: Revoke Permissions @info:mysql:permissions
- e sql> REVOKE ALL PRIVILEGES ON `{db}` . * FROM '{user}'@'%'; </code> {{tag>admin database mysql sql}}
- MySQL: Grant Permissions @info:mysql:permissions
- code sql> GRANT ALL PRIVILEGES ON `{db}` . * TO '{user}'@'%'; </code> {{tag>admin database mysql sql}}
- MySQL: View Permissions @info:mysql:permissions
- === <code sql> SHOW PRIVILEGES; SHOW GRANTS FOR '{user}'@'%'; </code> {{tag>admin database mysql sql}}
- MySQL: Remove User @info:mysql:user
- db} <code sql> DROP USER '{user}'@'%'; DROP DATABASE '{db}'; </code> {{tag>admin database mysql sql}}
- MySQL: Change Password @info:mysql:user
- D('{passwd}') WHERE User='{user}'; FLUSH PRIVILEGES; </code> {{tag>admin database mysql password sql}}
- MySQL: Remove Database @info:mysql:database
- ove Database ==== <code sql> DROP DATABASE IF EXISTS `{db}`; </code> {{tag>admin database mysql sql}}
- MySQL: Create Database @info:mysql:database
- S `{db}`; GRANT ALL PRIVILEGES ON `{db}` . * TO '{user}'@'%'; </code> {{tag>admin database mysql sql}}