Buy Percona ServicesBuy Now!
  Thursday, February 23, 2017
   Sveta Smirnova

Troubleshooting MySQL access privileges issues

Please join Percona’s Principal Technical Services Engineer Sveta Smirnova as she presents “Troubleshooting MySQL access privileges issues” on February 23, 2017 at 11:00 am PST /2:00 pm EST (UTC-8).

Do you have registered users who can’t connect to the MySQL server? Strangers modifying data to which they shouldn’t have access?

MySQL supports a rich set of user privilege options, and allows you to fine tune access to every object in the server. The latest versions support authentication plugins that help to create more access patterns.

However, finding errors in such a big set of options can be problematic. This is especially true for environments with hundreds of users, all with different privileges on multiple objects. In this webinar, I will show you how to decipher error messages and unravel the complicated setups that can lead to access errors. We will also cover network errors that mimic access privileges errors.

We will discuss:

- Which privileges MySQL supports
- What GRANT statements are
- How privileges are stored
- How to find out why a privilege does not work properly
- How authentication plugins make difference
- What the best access control practices are

Sveta Smirnova
Principal Technical Services Engineer
Sveta joined Percona in 2015. Her main professional interests are problem solving, working with tricky issues, bugs, finding patterns which can solve typical issues quicker, teaching others how to deal with MySQL issues, bugs and gotchas effectively. Before joining Percona Sveta worked as Support Engineer in MySQL Bugs Analysis Support Group in MySQL AB-Sun-Oracle. She is author of book "MySQL Troubleshooting" and JSON UDF functions for MySQL.

Visit Percona Store


General Inquiries

For general inquiries, please send us your question and someone will contact you.