Installing a MySQL Database (Community Edition)

This section describes how to initialize disks and install a MySQL database (community edition).

Log in to the management console.
Click in the upper left corner of the management console and select AP-Singapore.
Click in the upper left corner of the page and choose Compute > Elastic Cloud Server.
Locate the ECS ecs-mysql and click Remote Login in the Operation column.
Select CloudShell-based Login.
Enter the password of user root.

The password is the one you specified during the ECS creation.

Create the mysql folder.

mkdir /mysql
View data disk information.

fdisk -l

The command output is as follows.
Initialize the data disk.

mkfs.ext4 /dev/vdb
Attach the disk.

mount /dev/vdb /mysql
Check whether the disk has been attached.

df -h

If the following output is returned, the disk has been attached.
Create a folder and switch to the install folder.

mkdir -p /mysql/install/data

mkdir -p /mysql/install/tmp

mkdir -p /mysql/install/file

mkdir -p /mysql/install/log

cd /mysql/install
Download and install the MySQL client.
Initialize the MySQL client.

/mysql/install/mysql-8.0.22/bin/mysqld --defaults-file= /etc/my.cnf --initialize-insecure
Start the MySQL client.

nohup /mysql/install/mysql-8.0.22/bin/mysqld --defaults-file= /etc/my.cnf &
Connect to the MySQL client.

/mysql/install/mysql-8.0.22/bin/mysql
Create user root and assign the required permissions to it.

grant all privileges on *.* to 'root'@'%' identified by 'xxx' with grant option;FLUSH PRIVILEGES;