[Skip to content](#main)

[→](/)

[![Avunu](/brand/avunu-logo.svg)![Avunu](/brand/avunu-logo-light.svg)](/)[Services](/services/)[Consulting](/services/consulting/)[ERP](/services/erp/)[Odoo](/services/erp/odoo/)[ERPNext](/services/erp/erpnext/)[Custom software](/services/custom-software/)[Devices & IoT](/services/devices-iot/)[Websites](/services/websites/)[Infrastructure](/services/infrastructure/)[Partners](/partners/)

[Work](/work/)[Open source](/open-source/)[Knowledge base](/kb/)[About](/about/)

[About Avunu](/about/)[Team](/about/team/)[Insights](/insights/)[Contact](/contact/)

[Client portal](https://erp.avunu.net/projects)[Start a project](/start/)

- [Services](/services/)[Consulting](/services/consulting/)
- [ERP](/services/erp/)
- [Odoo](/services/erp/odoo/)
- [ERPNext](/services/erp/erpnext/)
- [Custom software](/services/custom-software/)
- [Devices & IoT](/services/devices-iot/)
- [Websites](/services/websites/)
- [Infrastructure](/services/infrastructure/)
- [Partners](/partners/)

[Work](/work/)[Open source](/open-source/)[Knowledge base](/kb/)[About](/about/)

- [About Avunu](/about/)
- [Team](/about/team/)
- [Insights](/insights/)
- [Contact](/contact/)

[Client portal](https://erp.avunu.net/projects)[Start a project](/start/)

[Knowledge base](/kb/)[Databases](/kb/databases/)MariaDB and MySQL Cheatsheet

Search the knowledge basePress/

ESC

Jump to

[Browse the knowledge base](/kb/)[Frappe](/kb/frappe/)[ERPNext](/kb/erpnext/)[Odoo](/kb/odoo/)[WordPress](/kb/wordpress/)[NixOS](/kb/nixos/)[Email](/kb/email/)[Linux](/kb/linux/)[Databases](/kb/databases/)[Containers](/kb/containers/)[Proxmox](/kb/proxmox/)[Git & Dev Tools](/kb/git-and-dev-tools/)

↵select↑↓navigateescclose

Search the knowledge base

[Skip to the article](#kb-article)[Databases](/kb/databases/)3 articles

- [Overview](/kb/databases/)
- [Convert Tables to a Different Storage Engine](/kb/databases/convert-table-storage-engines/)
- [MariaDB and MySQL Cheatsheet](/kb/databases/mariadb-mysql-cheatsheet/)
- [Recover Data from a MariaDB Server That Won't Start](/kb/databases/emergency-recovery-mode/)

Other sections[Frappe](/kb/frappe/)[ERPNext](/kb/erpnext/)[Odoo](/kb/odoo/)[WordPress](/kb/wordpress/)[NixOS](/kb/nixos/)[Email](/kb/email/)[Linux](/kb/linux/)[Containers](/kb/containers/)[Proxmox](/kb/proxmox/)[Git & Dev Tools](/kb/git-and-dev-tools/)

In Databases: 3 articles

[Overview](/kb/databases/)[Convert Tables to a Different Storage Engine](/kb/databases/convert-table-storage-engines/)[MariaDB and MySQL Cheatsheet](/kb/databases/mariadb-mysql-cheatsheet/)[Recover Data from a MariaDB Server That Won't Start](/kb/databases/emergency-recovery-mode/)

Other sections[Frappe](/kb/frappe/)[ERPNext](/kb/erpnext/)[Odoo](/kb/odoo/)[WordPress](/kb/wordpress/)[NixOS](/kb/nixos/)[Email](/kb/email/)[Linux](/kb/linux/)[Containers](/kb/containers/)[Proxmox](/kb/proxmox/)[Git & Dev Tools](/kb/git-and-dev-tools/)

DatabasesMariaDB and MySQL Cheatsheet

Everyday MariaDB and MySQL commands for creating users, checking and optimizing tables, dumping single tables, and inspecting schemas.

UpdatedOct 1, 2026

Applies toMariaDB 10.11MariaDB 11.4MariaDB 11.8

Tagsmariadbmysqlsqlcheatsheet

Reading time5 min

On this page[Create a Database and User](#create-a-database-and-user)[Allow a User to Set Definers](#allow-a-user-to-set-definers)[Create an Administrative User for Development](#create-an-administrative-user-for-development)[Change How Root Authenticates](#change-how-root-authenticates)[Check and Repair All Tables](#check-and-repair-all-tables)[Optimize All Tables](#optimize-all-tables)[Dump and Restore a Single Table](#dump-and-restore-a-single-table)[Extract One Table from a Full Dump](#extract-one-table-from-a-full-dump)[List a Table's Columns](#list-a-tables-columns)[Capitalize Every Word](#capitalize-every-word)

Quick recipes for routine MariaDB administration. Each section is self-contained, so jump to the task you need. Commands use the `mariadb`, `mariadb-dump`, and `mariadb-check` client names. On older servers or MySQL, the `mysql`, `mysqldump`, and `mysqlcheck` names take the same options.

Tip

On Debian and Ubuntu, the MariaDB `root` account authenticates through the Unix socket, so `sudo mariadb` logs you in without a password. For other accounts, put credentials in `~/.my.cnf` (mode `600`) rather than typing `--password=...` on the command line, where they end up in shell history and the process list.

## Create a Database and User

Create an application database with a full Unicode character set and a user that can access only that database.

```
<span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">CREATE</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">DATABASE</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E"><</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">DB_NAME</span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">></span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">CHARACTER</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">SET</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> utf8mb4 </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">COLLATE</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> utf8mb4_unicode_ci;</span>
<span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">CREATE</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> USER </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">'<DB_USER>'</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">@</span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">'localhost'</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> IDENTIFIED </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">BY</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">'<DB_PASSWORD>'</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">;</span>
<span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">GRANT</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> ALL PRIVILEGES </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">ON</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E"><</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">DB_NAME</span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">></span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">.</span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">*</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">TO</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">'<DB_USER>'</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">@</span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">'localhost'</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">;</span>
```

`CREATE USER` and `GRANT` take effect immediately, so `FLUSH PRIVILEGES` isn't needed. Leave off `WITH GRANT OPTION` unless the user really needs to grant privileges to others.

## Allow a User to Set Definers

Imported dumps often contain views, triggers, or routines with a `DEFINER` clause naming another account. In MariaDB 10.5.2 and later, the `SET USER` privilege lets a non-root user create those objects.

```
<span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">GRANT</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">SET</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> USER </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">ON</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">*</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">.</span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">*</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">TO</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">'<DB_USER>'</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">@</span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">'localhost'</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">;</span>
```

If you'd rather change the definer in the dump itself, see [Shell One-Liners](/kb/linux/shell-one-liners/#replace-text-in-a-file).

## Create an Administrative User for Development

Frappe's `bench new-site` and similar tools need an account that can create databases and users. On a development machine, create a dedicated admin account rather than reusing `root`.

```
<span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">CREATE</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> USER </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">'<ADMIN_USER>'</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">@</span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">'localhost'</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> IDENTIFIED </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">BY</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">'<DB_PASSWORD>'</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">;</span>
<span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">GRANT</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> ALL PRIVILEGES </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">ON</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">*</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">.</span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">*</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">TO</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">'<ADMIN_USER>'</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">@</span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">'localhost'</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">WITH</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">GRANT</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">OPTION</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">;</span>
```

Warning

This account has full control of every database on the server. Use a strong password, keep it bound to `localhost`, and don't create it on production servers unless a tool requires it.

## Change How Root Authenticates

To let the system `root` user log in through the Unix socket with no password (the Debian and Ubuntu default), run:

```
<span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">ALTER</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">USER</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">'root'</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">@</span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">'localhost'</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> IDENTIFIED VIA unix_socket;</span>
```

To allow either socket login or a password:

```
<span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">ALTER</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">USER</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">'root'</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">@</span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">'localhost'</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> IDENTIFIED VIA unix_socket </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">OR</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> mysql_native_password </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">USING</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">PASSWORD</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">(</span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">'<DB_PASSWORD>'</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">);</span>
```

To remove the root password entirely, for example on a throwaway local development container:

```
<span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">ALTER</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">USER</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">'root'</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">@</span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">'localhost'</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> IDENTIFIED </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">BY</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">''</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">;</span>
```

Warning

An empty root password lets any local user (and any process that can reach the socket or port) take full control of the server. Never do this on a shared or production machine. Prefer `unix_socket` authentication, which is passwordless for the system `root` account only.

## Check and Repair All Tables

Check every table in every database, and repair the ones whose storage engine supports `REPAIR TABLE`:

```
<span style="--shiki-dark:#FFA657;--shiki-light:#953800">mariadb-check</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">--check</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">--auto-repair</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">--all-databases</span>
```

Add `-u root -p` if you aren't using socket authentication.

Note

`--auto-repair` only fixes engines that support repair (MyISAM, Aria, ARCHIVE, CSV). InnoDB tables can't be repaired this way. A corrupted InnoDB table needs a dump and restore, or [Emergency Recovery Mode](/kb/databases/emergency-recovery-mode/) if the server won't start.

## Optimize All Tables

Rebuild tables to reclaim space after large deletes:

```
<span style="--shiki-dark:#FFA657;--shiki-light:#953800">mariadb-check</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">--optimize</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">--all-databases</span>
```

For InnoDB, MariaDB reports `Table does not support optimize, doing recreate + analyze instead`. That's expected: the table is rebuilt with `ALTER TABLE ... FORCE`. Each rebuild needs free disk space roughly equal to the table's size and can take a long time on big tables, so run it during a quiet period.

## Dump and Restore a Single Table

Dump one table (quote names that contain spaces) and restore it into the same or another database:

```
<span style="--shiki-dark:#FFA657;--shiki-light:#953800">mariadb-dump</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">--single-transaction</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E"><</span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">DB_NAM</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">E</span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">></span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">'tabScheduled Job Log'</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">></span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">table.sql</span>
<span style="--shiki-dark:#FFA657;--shiki-light:#953800">mariadb</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E"><</span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">DB_NAM</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">E</span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">></span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E"><</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">table.sql</span>
```

The dump includes `DROP TABLE IF EXISTS`, so restoring replaces the existing table.

## Extract One Table from a Full Dump

Pull a single table out of a large `mariadb-dump` file without restoring everything. Each table's section runs from its `DROP TABLE` line to the matching `UNLOCK TABLES`:

```
<span style="--shiki-dark:#FFA657;--shiki-light:#953800">sed</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">-n</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">'/^DROP TABLE IF EXISTS `<TABLE_NAME>`/,/^UNLOCK TABLES/p'</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">backup.sql</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">></span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">table.sql</span>
<span style="--shiki-dark:#FFA657;--shiki-light:#953800">mariadb</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E"><</span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">DB_NAM</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">E</span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">></span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E"><</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">table.sql</span>
```

## List a Table's Columns

Query `information_schema` for column names and types in their defined order:

```
<span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">SELECT</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> COLUMN_NAME, COLUMN_TYPE</span>
<span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">FROM</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">information_schema</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">.</span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">COLUMNS</span>
<span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">WHERE</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> TABLE_SCHEMA </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">=</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">'<DB_NAME>'</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">  </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">AND</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> TABLE_NAME </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">=</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">'<TABLE_NAME>'</span>
<span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">ORDER BY</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> ORDINAL_POSITION;</span>
```

For a quick interactive look, `SHOW COLUMNS FROM <TABLE_NAME>;` gives the same information.

## Capitalize Every Word

MariaDB has no built-in title-case function. This stored function capitalizes each word, leaving short joining words lowercase unless they come first:

```
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">DELIMITER </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">//</span>

<span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">CREATE OR REPLACE</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">FUNCTION</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">CAP_FIRST</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">(input </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">VARCHAR</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">(</span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">255</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">))</span>
<span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">RETURNS</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">VARCHAR</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">(</span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">255</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">) DETERMINISTIC</span>
<span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">BEGIN</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">  </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">DECLARE</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> i </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">INT</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">DEFAULT</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">1</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">;</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">  </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">DECLARE</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> word_count </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">INT</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">;</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">  </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">DECLARE</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> word </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">VARCHAR</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">(</span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">255</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">);</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">  </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">DECLARE</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">output</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">VARCHAR</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">(</span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">255</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">) </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">DEFAULT</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">''</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">;</span>

<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">  </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">IF</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> input </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">IS</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">NULL</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">THEN</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">RETURN</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">NULL</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">;</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">  </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">END</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">IF</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">;</span>

<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">  </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">SET</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> input </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">=</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">TRIM</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">(</span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">LOWER</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">(input));</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">  </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">SET</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> word_count </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">=</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> CHAR_LENGTH(input) </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">-</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> CHAR_LENGTH(</span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">REPLACE</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">(input, </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">' '</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">, </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">''</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">)) </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">+</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">1</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">;</span>

<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">  </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">WHILE</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> i </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E"><=</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> word_count DO</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">SET</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> word </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">=</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> SUBSTRING_INDEX(SUBSTRING_INDEX(input, </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">' '</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">, i), </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">' '</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">, </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">-</span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">1</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">);</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">IF</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> i </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">=</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">1</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">OR</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> word </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">NOT</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">IN</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> (</span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">'a'</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">, </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">'an'</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">, </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">'and'</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">, </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">'for'</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">, </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">'of'</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">, </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">'the'</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">, </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">'with'</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">) </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">THEN</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">      </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">SET</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> word </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">=</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">CONCAT</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">(</span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">UPPER</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">(</span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">LEFT</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">(word, </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">1</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">)), </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">SUBSTRING</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">(word, </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">2</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">));</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">END</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">IF</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">;</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">SET</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">output</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">=</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> CONCAT_WS(</span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">' '</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">, </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">NULLIF</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">(</span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">output</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">, </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">''</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">), word);</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">SET</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> i </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">=</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> i </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">+</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">1</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">;</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">  </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">END</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">WHILE</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">;</span>

<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">  </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">RETURN</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">output</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">;</span>
<span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">END</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">//</span>

<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">DELIMITER ;</span>
```

```
<span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">SELECT</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> CAP_FIRST(</span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">'the QUICK brown fox and the lazy dog'</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">);</span>
```

```text
The Quick Brown Fox and the Lazy Dog
```

Edit the `NOT IN` list to change which words stay lowercase.

Sources

- [mariadb.com/docs/server/reference/sql-statements/account-management-sql-statements/grant](https://mariadb.com/docs/server/reference/sql-statements/account-management-sql-statements/grant)
- [mariadb.com/docs/server/clients-and-utilities/table-tools/mariadb-check](https://mariadb.com/docs/server/clients-and-utilities/table-tools/mariadb-check)
- [mariadb.com/docs/server/clients-and-utilities/backup-restore-and-import-clients/mariadb-dump](https://mariadb.com/docs/server/clients-and-utilities/backup-restore-and-import-clients/mariadb-dump)

Need help with your databases?

Our notes can take you a long way, but sometimes you'd rather have someone who's done it before.

[Managed infrastructure](/services/infrastructure/)

[← PreviousConvert Tables to a Different Storage Engine](/kb/databases/convert-table-storage-engines/)[Next →Recover Data from a MariaDB Server That Won't Start](/kb/databases/emergency-recovery-mode/)

CC0This article is in the public domain ([CC0 1.0](https://creativecommons.org/publicdomain/zero/1.0/)), code samples included. Use it however helps you.

On this page

- [Create a Database and User](#create-a-database-and-user)
- [Allow a User to Set Definers](#allow-a-user-to-set-definers)
- [Create an Administrative User for Development](#create-an-administrative-user-for-development)
- [Change How Root Authenticates](#change-how-root-authenticates)
- [Check and Repair All Tables](#check-and-repair-all-tables)
- [Optimize All Tables](#optimize-all-tables)
- [Dump and Restore a Single Table](#dump-and-restore-a-single-table)
- [Extract One Table from a Full Dump](#extract-one-table-from-a-full-dump)
- [List a Table's Columns](#list-a-tables-columns)
- [Capitalize Every Word](#capitalize-every-word)

[Back to top↑](#top)

Services

- [ERP implementation](/services/erp/)
- [Odoo](/services/erp/odoo/)
- [ERPNext](/services/erp/erpnext/)
- [Custom software](/services/custom-software/)
- [Devices & IoT](/services/devices-iot/)
- [Websites](/services/websites/)
- [Infrastructure](/services/infrastructure/)

Resources

- [Our work](/work/)
- [Open source](/open-source/)
- [Knowledge base](/kb/)
- [Insights](/insights/)

Company

- [About](/about/)
- [Team](/about/team/)
- [Partners](/partners/)
- [Contact](/contact/)

Clients

- [Project portal](https://erp.avunu.net/projects)
- [Invoices](https://erp.avunu.net/)
- [Support](https://erp.avunu.net/)

[![Avunu](/brand/avunu-logo-light.svg)](/)[\<av-icon data-jx-static>\<svg viewBox="0 0 24 24" width="20" height="20" fill="currentColor" stroke="none" stroke-width="1.6" stroke-linecap="round" stroke-linejoin="round" aria-hidden="true" focusable="false">\<path d="M20.400 20.500h-3.600v-5.600c0-1.300 0-3-1.800-3s-2.100 1.400-2.100 2.900v5.700H9.400V9h3.400v1.600c.5-.9 1.600-1.900 3.400-1.900 3.600 0 4.300 2.400 4.300 5.500v6.300zM5.300 7.400a2.100 2.100 0 1 1 0-4.100 2.100 2.100 0 0 1 0 4.100zm1.800 13.100H3.600V9h3.500v11.500zM22.200 0H1.800C.8 0 0 .8 0 1.700v20.600c0 .9.800 1.700 1.800 1.700h20.400c1 0 1.800-.8 1.800-1.700V1.700C24 .8 23.200 0 22.200 0z">\</path>\</svg>\</av-icon>](https://www.linkedin.com/company/avunu)[\<av-icon data-jx-static>\<svg viewBox="0 0 24 24" width="20" height="20" fill="currentColor" stroke="none" stroke-width="1.6" stroke-linecap="round" stroke-linejoin="round" aria-hidden="true" focusable="false">\<path d="M12 .3a12 12 0 0 0-3.8 23.4c.6.1.8-.3.8-.6v-2c-3.3.7-4-1.6-4-1.6-.6-1.4-1.4-1.8-1.4-1.8-1-.7.1-.7.1-.7 1.2.1 1.8 1.2 1.8 1.2 1 1.8 2.8 1.3 3.5 1 .1-.8.4-1.3.7-1.6-2.7-.3-5.5-1.3-5.5-5.9 0-1.3.5-2.4 1.2-3.2-.1-.3-.5-1.5.1-3.2 0 0 1-.3 3.3 1.2a11.500 11.500 0 0 1 6 0c2.300-1.500 3.300-1.200 3.300-1.200.6 1.700.2 2.900.1 3.200.8.8 1.200 1.900 1.200 3.200 0 4.600-2.800 5.600-5.500 5.900.4.400.8 1.100.8 2.200v3.300c0 .3.2.7.8.6A12 12 0 0 0 12 .3">\</path>\</svg>\</av-icon>](https://github.com/Avunu)[Client portal](https://erp.avunu.net/projects)[Start a project](/start/)

Avunu LLC · 948 East Philadelphia Street, York, PA 17403 · (717) 814-8540Knowledge base articles are in the public domain[Privacy](/privacy/)[Terms](/terms/)
