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

Post a Comment

Popular posts from this blog

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

Image
an authentication error has occurred the token supplied to the function is invalid I have installed xrdp 0.9.8 at server side. Remote desktop connections are working fine when i am connect it from windows 8/10. but when i am trying to connect RDP from windows 7 it is showing error which is showing on left side. in xrdp 0.9.8 TLSv1.2 and TLSv1.3 is added by default. in older version of windows system TLSv1.3 was not supported. thats why it is not connecting with xrdp server. To resolve this issue from server side follow the steps below. 1. Login to xrdp server. 2. navigate to xrdp configuration file location, $cd /etc/xrdp $vim xrdp.ini replace ssl_protocols=TLSv1.2, TLSv1.3 with ssl_protocols=TLSv1, TLSv1.1 3. Restart xrdp service. $ service xrdp restart
Read more

Windows shared network printer issue in ubuntu 18.04

Windows shared network printing issue in ubuntu 18.04. - printers are installed in windows 8 machine and shared. - when try to find the network printer from ubuntu 18.04 using the ip of windows machine then it is showing an error  "no network printer found" - even, when we found the shared folders using smbclient command then it will showing an error smbclient -L 192.168.1.20 output: syslog option deprecated, Enter WORKGROUP\root's password:     Sharename       Type      Comment     ---------       ----      -------     ADMIN$          Disk      Remote Admin     Backup          Disk          bk              Disk          bkp             Disk          C$              Disk      Default share     Canon UFR II Color Class Driver Printer   Canon UFR II Color Class Driver     Canon-LBP2900-toc64 Printer   Canon LBP2900     Canon2900       Printer   \\MUIN-KHAN\Canon-LBP2900     D$              Disk      Default share     Data            Disk          HP-LaserJet-M
Read more

Rename printer from command line in ubuntu.

Rename printer name from backend without GUI. 1. rename the printer name into /etc/cups/printers.conf for E.g. OldName="Canon_LBP-2900_CAPT" NewName="Canon_LBP2900" Stop cups service first service cups stop  > /dev/null 2>&1 Replace the old name with new printer name sed -i 's/'$OldName'/'$NewName'/g' /etc/cups/printers.conf Restart cups service service cups restart  > /dev/null 2>&1 2. Also need to rename the ppd of the old printer which is located at /etc/cups/ppd rename the old printer ppd name  mv /etc/cups/ppd/"$OldName".ppd  /etc/cups/ppd/"$NewName".ppd Restart cups service service cups restart
Read more