Skip to content

Instantly share code, notes, and snippets.

@RafPe

RafPe/mysql_ssl_users.sql

Created April 20, 2016 08:31
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save RafPe/38758d6489d839f7eb7e0fa2c88af8c8 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save RafPe/38758d6489d839f7eb7e0fa2c88af8c8 to your computer and use it in GitHub Desktop.
Download ZIP
Create mysql users with SSL
Raw
mysql_ssl_users.sql
# Creates user which is required to present client side certificate
GRANT ALL PRIVILEGES ON *.* TO 'ssluser'@'%' IDENTIFIED BY 'ssluser' REQUIRE X509;
# Creates user which will use encrypted connection to database
GRANT ALL PRIVILEGES ON *.* TO 'ssluser'@'%' IDENTIFIED BY 'ssluser' REQUIRE SSL;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment