apt-get install mysql-server
echo -e "sql_require_primary_key=on\nsql_generate_invisible_primary_key\ninnodb_buffer_pool_size=20G\ninnodb_buffer_pool_instances=16\nmax_connections=120\ndefault_authentication_plugin=mysql_native_password" >> /etc/mysql/mysql.conf.d/mysqld.cnf
systemctl restart mysql
mysql
alter user root@localhost identified with mysql_native_password by '****';
mysql_config_editor set --login-path=sqlp -u root -p
**** echo "alias sqlp='mysql --login-path=sqlp'" >> ~/.bashrc
source ~/.bashrc
create user USER identified by '***';
grant all privileges on *.* to USER;
grant all privileges on *.* to USER with grant option;