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 LookingGlass on Linux July 19, 2021 Requirements PHP >= 5.3 PHP PDO with SQLite driver (required for rate-limit) SSH/Terminal access (able to install commands/functions if non-existent) Installations: Related Read More
Accessing private network using pritunl VPN June 30, 2020 This tutorial will describe securing access to a private network using a Pritunl server. The diagram below shows the network topology for this tutorial. First remove the 0.0.0.0/0 route from the server. This route tunnels all internet traffic over the vpn, for this setup only the traffic for the private… Read More
E: Release file for http://archive.debian.org/debian/dists/jessie-backports/InRelease is expired (invalid since 715d 18h 14min 9s). Updates for this repository will not be applied Update Wheezy or Jessie Repo February 6, 2021 Wheezy and jessie both has gone EOL and repos too. archive repo doesn’t seem to usually work either. So here’s a little trick that worked for me. Below is my repo.list file- deb http://archive.debian.org/debian jessie main deb http://archive.debian.org/debian-archive/debian-security/ jessie updates/ma$ #deb http://security.debian.org/ jessie/updates non-free contrib main #deb http://mirrors.ocf.berkeley.edu/debian/ jessie-updates main… Read More