# MySQL Security & high performance

**URL:** <https://forums.percona.com/t/mysql-security-high-performance/9749>\
**Category:** MySQL & MariaDB\
**Tags:** mysql, percona\
**Created:** [March 22, 2021, 6:09pm UTC](https://forums.percona.com/t/mysql-security-high-performance/9749 "2021-03-22T18:09:27Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![ca1990](https://avatars.discourse-cdn.com/v4/letter/c/c2a13f/32.png) [@ca1990](https://forums.percona.com/u/ca1990)\
**Post date:** [March 22, 2021, 6:09pm UTC](https://forums.percona.com/t/mysql-security-high-performance/9749/1 "2021-03-22T18:09:27Z")

</div>

Hi there,

1. What are the measures or solutions to improve the security mechanism in `Percona MySQL`…?
2. What are the best practices for configuring `Percona MySQL` to acheive high performance …?

---

<div class="post-metadata">

**Author:** ![czenmarco](https://avatars.discourse-cdn.com/v4/letter/c/ea666f/32.png) [@czenmarco](https://forums.percona.com/u/czenmarco)\
**Post date:** [March 22, 2021, 6:45pm UTC](https://forums.percona.com/t/mysql-security-high-performance/9749/2 "2021-03-22T18:45:28Z")

</div>

Security :

- Set the root MySQL password.
- Delete the test account and database that were created during the initial installation of MySQL.
- Make sure that each individual MySQL account password is set.
- Grant privileges on an as-needed basis. Avoid granting global privileges unnecessarily.
- Don’t use wildcards in the hostname value that is associated with accounts.
- Periodically review an account’s MySQL users and databases to make sure that the permissions that are defined are valid.

High Performance:

- … waiting for input from the more experienced guys

---

<div class="post-metadata">

**Author:** ![ca1990](https://avatars.discourse-cdn.com/v4/letter/c/c2a13f/32.png) [@ca1990](https://forums.percona.com/u/ca1990)\
**Post date:** [March 23, 2021, 3:14pm UTC](https://forums.percona.com/t/mysql-security-high-performance/9749/3 "2021-03-23T15:14:39Z")

</div>

> [@czenmarco](#):
>
> Don’t use wildcards in the hostname value that is associated with accounts.

could you please brief the above point…?

---

<div class="post-metadata">

**Author:** ![ca1990](https://avatars.discourse-cdn.com/v4/letter/c/c2a13f/32.png) [@ca1990](https://forums.percona.com/u/ca1990)\
**Post date:** [March 23, 2021, 3:15pm UTC](https://forums.percona.com/t/mysql-security-high-performance/9749/4 "2021-03-23T15:15:22Z")

</div>

Hi there  
can anyone look into the point 2.

---

<div class="post-metadata">

**Author:** ![daniil.bazhenov](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/daniil.bazhenov/32/62_2.png) [@daniil.bazhenov](https://forums.percona.com/u/daniil.bazhenov)\
**Post date:** [March 23, 2021, 6:38pm UTC](https://forums.percona.com/t/mysql-security-high-performance/9749/5 "2021-03-23T18:38:49Z")

</div>

I think this is a very general question.  
[Our blog](https://www.percona.com/blog/) has over 1000 posts from MySQL experts: [Link](https://www.percona.com/blog/category/mysql/)  
There are many recommendations to improve performance and availability.

Also, I recommend you read the book by Peter Zaitsev:  
[High Performance MySQL: Optimization, Backups, Replication, and More](https://www.amazon.com/High-Performance-MySQL-Optimization-Replication/dp/0596101716/ref=sr_1_2?crid=TNTBP4WOBJ8I&dchild=1&keywords=mysql+high+availability&qid=1616524383&sprefix=MySQL+High+A%2Caps%2C264&sr=8-2)  
There he was trying to answer your question in a 600-page book.

I think that there is no universal answer to your question, which will fit into 6-10 points.