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
Mount Windows partitions in to Linux May 6, 2011 Procedure to mount remote windows partition (NAS share) 1) Make sure you have following information: ==> Windows username and password to access share name ==> Sharename (such as //server/share) or IP address ==> root level access on Linux 2) Login to Linux as a root user (or use su command)… Read More
Install and Configure Fail2Ban for Zimbra on CentOS 7 September 12, 2023 Below is how to install and configure Fail2Ban for Zimbra. In this guidance, I use CentOS. Please adjust python-pip version if using another OS 1. Install pip yum install python3-pip 2. Install dependencies required by Fail2Ban pip3 install pyinotify pip3 install dnspython 3. Download and extract Fail2Ban cd /tmp/ wget… Read More
Mounting OCI bucket on CentOS 7 Linux May 30, 2023June 14, 2023 Install s3fs-fuse In order to use this you have to enable EPEL Repository- sudo yum install epel-release sudo yum install s3fs-fuse [opc@linux8 ~]$ sudo yum install s3fs-fuse Last metadata expiration check: 0:00:41 ago on Sun 15 May 2022 05:40:13 PM CST. Dependencies resolved. ================================================================================================================================= Package Architecture Version Repository Size =================================================================================================================================… Read More