rkcb/mariadb_admin_misc.md

Last active December 27, 2018 18:22

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/rkcb/3687c9b27ccc7ce9ab60ddf059c091f6.js"></script>
Save rkcb/3687c9b27ccc7ce9ab60ddf059c091f6 to your computer and use it in GitHub Desktop.

Download ZIP

Raw

mariadb_admin_misc.md

Useful links

https://mariadb.com/kb/en/library/grant/

Stop mariadb server on Ubuntu 18.04

sudo service mariadb stop

Grant "root" rights for escobar in the database mydb

GRANT ALL PRIVILEGES ON mydb.* to 'escobar'@'localhost' WITH GRANT OPTION;

Show grants for the current user

SHOW GRANTS;

Show grants for a user

SHOW GRANTS FOR 'escobar'@'localhost';

Show users

SELECT User FROM mysql.user;

For reseting the password for 'root' see

https://www.digitalocean.com/community/tutorials/how-to-reset-your-mysql-or-mariadb-root-password

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment