Linux · MySQL / MariaDB

You need to give an application its own restricted database account. What two SQL commands set it up, and what password mistake must you avoid?

Sign in to see the full answer — free to start on the web.

This is one card from the KnowCard library. The full way to learn it — spaced-repetition review, progress tracking, and AI explanations — lives in the KnowCard app, free to start on the web. iOS & Android are coming soon.

Get started — it’s free

Already have an account? Sign in →

More in MySQL / MariaDB

You wrote a proprietary closed-source product that bundles the MySQL server. Someone tells you MySQL is free software, so no license is needed. Where does that reasoning break down?

A colleague assumes every distro ships MySQL. On Debian, Fedora, and openSUSE you can't find a MySQL package at all — only MariaDB. What is going on?

You picked a MariaDB version for a system you'll run for several years. Why does grabbing whatever is newest sometimes leave you patched for only one year?

You're migrating a server and need to copy the actual database contents, whether it runs MySQL or MariaDB. Which directory holds the data files?

The database won't come up after a config edit and you want to see why. What's a distribution-independent way to read the startup errors?

You edited settings under the [mysqld] section but nothing changed. Why, and how do other sections of the config behave differently?