Skip to content

Instantly share code, notes, and snippets.

@hughsaunders
Created January 20, 2014 13:34
Show Gist options
  • Save hughsaunders/8519919 to your computer and use it in GitHub Desktop.
Save hughsaunders/8519919 to your computer and use it in GitHub Desktop.
mysql users
[root@performance14-centos-54a ~]# mysql -u root -h 127.0.0.1 -p -e 'select user,host,password from mysql.user;'Enter password:
+------+--------------------------+-------------------------------------------+
| user | host | password |
+------+--------------------------+-------------------------------------------+
| root | localhost | *267958608B9116CCF2F8614408EAF6998AD54906 |
| root | 127.0.0.1 | *267958608B9116CCF2F8614408EAF6998AD54906 |
| | localhost | |
| | performance14-centos-54a | |
| repl | % | *6433632F0FCADD45047C97F4D35BCBAA800AFD45 |
| root | % | *267958608B9116CCF2F8614408EAF6998AD54906 |
+------+--------------------------+-------------------------------------------+
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment