---
title: MySQL Configuration
slug: kron-dam-supported-databases-and-databases-clients/mysql-configuration
docTags: 
createdAt: 2025-01-14T09:22:32.917Z
---

### Purpose 

In MySQL, the objective is to create a user that can connect and perform SELECT operations on any database/table without modification rights. 

### Grant Permissions 

:::CodeblockTabs
MySQL

```pgsql
 -- Connection - only privilege
GRANT USAGE ON *.* TO ’[ username ]’@’%’;

-- Grant read access to all tables
GRANT SELECT ON *.* TO ’[ username ]’@’%’;

-- Apply privileges
FLUSH PRIVILEGES ;
```
:::

### Testing Permissions 

Connect as \[username] and execute a SELECT query: 

```pgsql
USE testdb ;
SELECT * FROM test_table ;
```

If \[username] can retrieve the data without an error, the privileges are correctly granted.