MySQL 8 use caching_sha2_password as default autentication method. Many mysql clients still not support this method. If you need to use old method, you can set autentication plugin as mysql_native_password. You can also set this as default method by editing my.cnf file.

To change a user to use mysql_native_password, run


Read More…

Install MySQL 8 on CentOS, RHEL 6/7

To Add MySQL yum repository to your server, go to Download the rpm file available. For RHEL/CentOS 7

For RHEL/CentOS 6

Installing MySQL Server

Stop/Start MySQL To stop/start MySQL, use service name “mysqld”.

MySQL 8 root Password When MySQL first starts, it create a random password and store in MySQL […]

Read More…

Install MySQL 8 on Ubuntu/Debian

To install MySQL 8 on Ubuntu/Debian, download the .deb repository file from

It ask you to select MySQL version, default is 8, just press down arrow and select “Ok”. Now you are ready to install MySQL 8, you need to run apt update before you can install.

It ask you to enter […]

Read More…