install mysql on ubuntu

Categories
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;