Basedir and datadir instructions in MySQL configuration file

Vi/data/mysql/my.cnf

Vi/etc/my.cnf

1. Basedir Parameters

The original description is:
Path to installation directory. All paths is usually resolved relative to this.
Explain:
This parameter specifies the installation path (MySQL installation directory) where MySQL is installed, and filling in the full path can solve the problem caused by the relative path.

mysql> SELECT @ @basedir;

+------------------+
| @ @basedir |
+------------------+
| /usr/local/mysql |
+------------------+
1 row in Set (0.00 sec)

2. DataDir parameters

The original description is:
Path to the database root.
Explain:
This parameter specifies the path under which the MySQL database file is placed. The database file is the MySQL data file that we often say, and it is the MySQL directory.

mysql> SELECT @ @datadir;
+-------------------+
| @ @datadir |
+-------------------+
| /data/mysql/data/|
+-------------------+
1 row in Set (0.00 sec)

Basedir and datadir instructions in MySQL configuration file