MySQL: Show Users, Privileges and Passwords Rumi, December 29, 2020 Show all MySQL users: mysql> SELECT user FROM mysql.user; List only unique user names: mysql> SELECT DISTINCT user FROM mysql.user; Show MySQL users and hosts they are allowed to connect from: mysql> SELECT user,host FROM mysql.user; Show MySQL users, their passwords and hosts: mysql> SELECT user,host,password FROM mysql.user; in MySQL 5.7 and higher: mysql> SELECT host,user,authentication_string FROM mysql.user; Show privileges granted to the current MySQL user: mysql> SHOW GRANTS; Show privileges granted to the MySQL user (if you don’t specify a host for the user name, MySQL assumes % as the host): mysql> SHOW GRANTS FOR 'user_name'; Show privileges granted to a particular MySQL user account from a given host: mysql> SHOW GRANTS FOR 'user_name'@'host'; – e.g. – mysql> SHOW GRANTS FOR 'root'@'localhost'; mysql> SHOW GRANTS FOR 'root'@'%'; mysql> SHOW GRANTS FOR 'admin'@'192.168.0.1'; Related Administrations MySQL
Install Varnish on CentOS/RedHat/SL 5 or 6 December 5, 2012December 5, 2012 Varnish Cache is a web application accelerator also known as a caching HTTP reverse proxy. It is installed in front of the web application and it speeds up the web application significantly. Since varnish is not available in CentOS repo, you have to add the EPEL repo. However Varnish suggests… Read More
Configure NFS shares in Openfiler July 13, 2013 In this article I’ll explain how-to configure a NFS share in Openfiler and then add it as a datastore to your vSphere servers. I’ll take for granted that you already have an Openfiler server up and running. 1 – Enable NFS service As always point your browser to https://<openfiler_address>:446, login… Read More
Remove Node from Proxmox Cluster September 9, 2020 Step 1 : Migrate all VMs to another active node Migrate all VMs to another active node. You can use the live migration feature if you have a shared storage or offline migration if you only have local storage. Step 2 : Display all active nodes Display all active nodes in… Read More