Creating a Data Directory

Create a data directory to store MySQL data files.

1. Create a data directory /data and related directories for processes.

   1 2 3

   mkdir -p /data/mysql cd /data/mysql mkdir data tmp run log relaylog

2. Change the user group and user permission on the /data directory to mysql:mysql.

   1 2	chown -R mysql:mysql /data ll /

   Example of the expected result: The user group and user permissions for /data have been changed to mysql:mysql.

   total 22
   lrwxrwxrwx.    1 root  root     7 Aug 29 15:55 bin -> usr/bin
   dr-xr-xr-x.    5 root  root  4096 Aug 29 16:07 boot
   drwxr-xr-x     3 mysql mysql   27 Sep 13 15:23 data
   drwxr-xr-x    18 root  root  3560 Aug 30 09:17 dev
   drwxr-xr-x.  100 root  root  8192 Sep 13 15:22 etc
   drwxr-xr-x.    4 root  root   164 Sep 13 15:15 home
   drwxr-xr-x.    2 root  root     6 Aug 29 16:02 kunpeng_autotest_share
   lrwxrwxrwx.    1 root  root     7 Aug 29 15:55 lib -> usr/lib
   lrwxrwxrwx.    1 root  root     9 Aug 29 15:55 lib64 -> usr/lib64
   drwxr-xr-x.    2 root  root     6 Apr 12  2018 media
   dr-xr-xr-x     7 root  root  2048 Nov 27  2018 mnt
   drwxr-xr-x.    3 root  root    16 Aug 29 15:59 opt
   dr-xr-xr-x  1193 root  root     0 Jan  1  1970 proc
   drwxr-xr-x     2 root  root     6 Aug 29 16:05 pxe_install_share
   dr-xr-x---.    4 root  root   285 Aug 30 09:19 root
   drwxr-xr-x    29 root  root   880 Aug 30 09:23 run
   lrwxrwxrwx.    1 root  root     8 Aug 29 15:55 sbin -> usr/sbin
   drwxr-xr-x.    2 root  root     6 Apr 12  2018 srv
   dr-xr-xr-x    12 root  root     0 Aug 29 16:06 sys
   drwxrwxrwt.    8 root  root   144 Sep 13 14:58 tmp
   drwxr-xr-x.   13 root  root   207 Aug 29 15:55 usr
   drwxr-xr-x.   20 root  root  4096 Aug 29 16:05 var