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
cd /tmp/ && wget https://dev.mysql.com/get/mysql-apt-config_0.8.17-1_all.deb
dpkg -i mysql-apt-config_0.8.17-1_all.deb && mysql-apt-config_0.8.17-1_all.deb && apt-get update
No comments:
Post a Comment