Detailed explanation of the process of installing MySQL on Ubuntu 18.04.4

1 sudo apt-get update

2 sudo apt-get install mysql-server

3 sudo mysql_secure_installation # Initial configuration #1
VALIDATE PASSWORD PLUGIN can be used to test passwords...
Press y|Y for Yes, any other key for No: N (My Options)
#2
Please set the password for root here...
New password: (Enter password)
Re-enter new password: (re-enter)
#3
By default, a MySQL installation has an anonymous user,
allowing anyone to log into MySQL without having to have
a user account created for them...
Remove anonymous users? (Press y|Y for Yes, any other key for No) : N (My option)
#4
Normally, root should only be allowed to connect from
'localhost'. This ensures that someone cannot guess at
the root password from the network...
Disallow root login remotely? (Press y|Y for Yes, any other key for No) : Y (my choice)
#5
By default, MySQL comes with a database named 'test' that
Anyone can access...
Remove test database and access to it? (Press y|Y for Yes, any other key for No) : N (My option)
#6
Reloading the privilege tables will ensure that all changes
made so far will take effect immediately.
Reload privilege tables now? (Press y|Y for Yes, any other key for No) : Y (my choice)
4 systemctl status mysql.service # Check server status

4 systemctl status mysql.service # Check server status

5 Modify the mysql port number and change the listening address to all vim /etc/mysql/mysql.conf.d/mysqld.cnf # Edit the configuration file bind-address = 0.0.0.0 # Change the listening ip to all port = 3388 # Change the listening port to 3388, you can leave it unchanged for safety. After the modification, restart the service systemctl restart mysql.service

6 Open mysql remote access 1 Log in to the database mysql -u root -p

2 Switch to database mysql
use mysql
3 Delete anonymous users delete from user where user='';
4 Add users who are allowed remote access or allow remote access for existing users. Grant root all permissions to access any database on any host (%). mysql> grant all privileges on *.* to 'root'@'%' identified by 'Replace here with the password you want to set' with grant option;
flush privileges;
5 Exit the database mysql> exit
6 Restart the database sudo service mysql restart