Settings after mysql/mariadb database installation is complete

Specify the innodb_file_per_table=1 parameter, which mainly prevents the ibdata file from being too large, in which all databases are stored. The above problem does not occur after you specify this parameter.

Specify the default character set: add the parameter: character_set_server=utf8 in the [mysqld] section.

Specify the default sort: collation-server=utf8_unicode_ci

Use the tab key to complete-the completion is the table name, column name, and database name. Not commands, variables in the database

On the mysql command line, use\ # to temporarily enable tab completion.

Add no-auto-rehash to the [mysql] section of mysql's configuration file my.cnf to achieve completion. You need to restart the mysql database.

You can use a mycli tool.

Use the tab key to complete-complete the mysql command

Add auto-rehash to the [mysql] section of mysql's configuration file my.cnf

Use the-- auto-rehash parameter when connecting using the mysql command