Mysql upgrade (5.7 to 8.0)

Upgrade Mysql 5.7.29 to Mysql 8.0.19 

 

Download package: 

wget https://repo.mysql.com/mysql-apt-config_0.8.10-1_all.deb

 

Install package: 

sudo dpkg -i mysql-apt-config_0.8.10-1_all.deb

 

Update repository: 

sudo apt-get update

 

Install mysql: 

sudo apt-get install mysql-server

 

Check mysql is properly installed or not:

apt policy mysql-server 

If any errors occur related to expire key:

sudo apt-key adv --keyserver keyserver.ubuntu.com --recv-keys [KEY] 

sudo apt-key adv --keyserver hkp://keyserver.ubuntu.com:80 --recv [KEY]

 

Do below changes in mysql configuration file,

/etc/mysql/my.cnf

 

[mysqld]

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_ALL_TABLES

max_connections=10000

max_allowed_packet=100M

group_concat_max_len=1000000

key_buffer_size=64M

interactive_timeout=129600

wait_timeout=129600

innodb_flush_log_at_trx_commit=0

thread_stack=2572864

innodb_buffer_pool_size=1G

bind-address=0.0.0.0

range_optimizer_max_mem_size=0

skip-log-bin