- Home
- Skills
- Data & Databases
- MySQL Config Check
More screenshots
Works with the AI Agents you already use
MySQL Config Check
skip-grant-tables turns off every password; MYSQL_ALLOW_EMPTY_PASSWORD gives anyone root.
$5
MySQL Config Check
Example session with this skill installed
Check this project with mysql-config-check.
- Read your context and instructions
- Compiled the mysql config check
$ python3 scripts/check_mysql.py examples/risky
BLOCK backup/.my.cnf:3 Y02 PASSWORD_IN_CONFIG
password = <redacted>
Why: A MySQL password is written in an option file ([client], [mysqldump] and similar) or a compose file that is part of the project. Everyone with the repository can log in.
Safer: Use mysql_config_editor (login paths), a .my.cnf outside the repository with mode 600, or MYSQL_ROOT_PASSWORD_FILE with Docker secrets; change the password that was committed.
BLOCK docker-compose.yml:7 Y03 EMPTY_ROOT_PASSWORD
BLOCK docker-compose.yml:8 Y02 PASSWORD_IN_CONFIG
BLOCK mysql/my.cnf:4 Y01 SKIP_GRANT_TABLES
REVIEW docker-compose.yml:5 Y16 PORT_PUBLISHED_TO_ALL
REVIEW mysql/my.cnf:2 Y13 NETWORK_WITHOUT_TLS
REVIEW mysql/my.cnf:5 Y11 LOCAL_INFILE_ON
REVIEW mysql/my.cnf:6 Y12 FILE_ACCESS_ANYWHERE
REVIEW mysql/my.cnf:7 Y14 OLD_TLS_VERSION
REVIEW mysql/my.cnf:8 Y15 GENERAL_LOG_ON
REVIEW mysql/my.cnf:9 Y17 NATIVE_PASSWORD_PLUGIN
(Each finding also has Why and Safer lines, as in the first one.)
Verdict: BLOCK. Checked 3 files, 3 with MySQL config content.
This is a static check of file text. NOT FLAGGED is not a guarantee.
Connects securely to your tools. The creator never sees your data.
About this skill
skip-grant-tables turns off every password; MYSQL_ALLOW_EMPTY_PASSWORD gives anyone root. This skill finds those and eight other MySQL and MariaDB mistakes before your database goes live, and tells you how to fix each one.
Your agent runs a scanner on option files (my.cnf, my.ini, .my.cnf, conf.d/*.cnf) the way MySQL reads them: sections including versioned ones, - and _ treated the same, loose-, enable- and disable- prefixes, quoted values, comments, and the last value winning. It also reads Docker Compose services that use mysql, mariadb or percona images. It knows that ${VARIABLE} values, _FILE variables and placeholders are not secrets. It never connects to the database. It returns BLOCK, REVIEW, or NOT FLAGGED, with the file, line, reason, and a safer approach. Passwords are never printed.
What it checks
BLOCK
- Y01: skip-grant-tables in a server section or compose command
- Y02: a password in an option file or a compose file
- Y03: an empty root password allowed
REVIEW
- Y11: local_infile on
- Y12: secure_file_priv set to empty
- Y13: bind-address open to the network without require_secure_transport
- Y14: TLS 1.0 or 1.1 allowed
- Y15: the general query log on
- Y16: 3306 published on every host interface
- Y17: mysql_native_password as the default plugin
What's included
- The scanner (Python 3.9+, standard library only)
- A rules guide with the reason and safer approach for each rule
- Risky and safe example option and compose files, and the real report the scanner produces on the risky ones
Limits It reads each file as written: !include files, SET PERSIST settings, users and grants inside the database, managed services (RDS, Cloud SQL, PlanetScale) and firewalls are not seen. NOT FLAGGED is not a guarantee.
Static check of option and compose files. Users, grants and managed database settings are not checked. NOT FLAGGED is not a guarantee.
How to use
- 1
Connect your agent to the Agensi MCP
Copy the prompt and paste it into Claude, ChatGPT, Cursor or any agent that supports MCP. It sets up the connection for you. Manual setup
- 2
Sign in to Agensi
Your agent shows a sign-in link. Sign in and click Allow.
- 3
Ask for what you need
Your agent loads this skill and uses it on your task. It always asks before any payment.
Reviews
No reviews yet
Be one of the first to try it. Every listed skill goes through the trust checks below.
Security scanned
Checked by our 8-point scan before listing
Fresh listing
Recently published to Agensi
Money-back guarantee
Doesn't do what its page promises? You get your money back.
Trust & safety
Security scan
Security scan passed 5 days ago
Permissions
Runs one local Python script in the terminal. It reads your project's files, writes nothing, and makes no network calls. The example files include a clearly fake, inert password (not-a-real-...) for the scanner to find. Nothing is run.