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?

Answer locked. Get the free KnowCard app to reveal it — plus spaced-repetition review so it actually sticks.

This is one card from the KnowCard library — thousands more across SAP, Linux, Python and more. In the app you get the answer, AI explanations, and cards that come back right before you would forget them. Free to start on iOS, Android or the web.

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?

Start learning today

Free to start — download the app or use it in your browser.