Mysql Upgrade 5.7 to 8

 

Upgrade Mysql 5.7.29 to Mysql 8.0.19


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


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


  • sudo apt-get update


  • sudo apt-get install mysql-server


  • apt policy mysql-server    (used to check mysql is properly installed or not)


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]


 

[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

event_scheduler=OFF


Apply below Query

SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));



Create user in mysql


SET GLOBAL validate_password.policy=LOW;

SET GLOBAL validate_password_policy=LOW;


CREATE USER user1@'%' IDENTIFIED BY 'user123';

GRANT ALL PRIVILEGES ON *.* To 'user'@'%' ;


FLUSH PRIVILEGES;



Provide % access to root user in mysql 8

update mysql.user set host="localhost" where user="root";

FLUSH PRIVILEGES;



Install Mysql workbench



Comments

Popular posts from this blog

Error while connecting RDP "an authentication error has occurred the token supplied to the function is invalid".

Windows shared network printer issue in ubuntu 18.04

Rename printer from command line in ubuntu.