Skip to main content
Database Administrators

Return to Question

Tweeted twitter.com/StackDBAs/status/926660217856720896
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Removed "MD5" because the password hashes are actually SHA-1. (No bigge)
Source Link
IcarusNM
IcarusNM
  • 581
  • 1
  • 4
  • 11

I am setting up ProxySQL in front of a Percona MySQL server with 88 user accounts. I don't even know most of their passwords. Passwords are stored in MySQL as MD5 hashes but are stored in ProxySQL in plain text. How can I easily bring in all 88 accounts into ProxySQL at once? Or is there a pass-through authentication switch I can turn on?

I am setting up ProxySQL in front of a Percona MySQL server with 88 user accounts. I don't even know most of their passwords. Passwords are stored in MySQL as MD5 hashes but are stored in ProxySQL in plain text. How can I easily bring in all 88 accounts into ProxySQL at once? Or is there a pass-through authentication switch I can turn on?

I am setting up ProxySQL in front of a Percona MySQL server with 88 user accounts. I don't even know most of their passwords. Passwords are stored in MySQL as hashes but are stored in ProxySQL in plain text. How can I easily bring in all 88 accounts into ProxySQL at once? Or is there a pass-through authentication switch I can turn on?

Source Link
IcarusNM
IcarusNM
  • 581
  • 1
  • 4
  • 11

How to easily bring 80 MySQL users into ProxySQL?

I am setting up ProxySQL in front of a Percona MySQL server with 88 user accounts. I don't even know most of their passwords. Passwords are stored in MySQL as MD5 hashes but are stored in ProxySQL in plain text. How can I easily bring in all 88 accounts into ProxySQL at once? Or is there a pass-through authentication switch I can turn on?