Learning mysql8 technology on oel7.9 platform

Learning mysql8 technology on oel7.9 platform

1. mysql8 downloading and installation

• download path for the latest release version: https://dev.mysql.com/downloads/mysql/
• download path for the previous release version: https://downloads.mysql.com/archives/community/
• download all packages
• unpack the .tar package (tar zxvf mysql-8.0.22-1.el7.x86_64.rpm-bundle.tar)
• install .rpm packages in order
  rpm -i mysql-community-client-plugins-8.0.22-1.el7.x86_64.rpm
  rpm -i mysql-community-common-8.0.22-1.el7.x86_64.rpm
  rpm -i mysql-community-libs-8.0.22-1.el7.x86_64.rpm
  rpm -i mysql-community-client-8.0.22-1.el7.x86_64.rpm
  rpm -i mysql-community-server-8.0.22-1.el7.x86_64.rpm
• check mysql version and make sure the installation was successful: mysql --version

[root@bogon Downloads]# mysql --version
mysql  Ver 8.0.22 for Linux on x86_64 (MySQL Community Server - GPL)

problem: when you install the mysql-community-libs-8.0.22-1.el7.x86_64.rpm package, if you have a problem like this

[root@bogon Downloads] rpm -i mysql-community-libs-8.0.22-1.el7.x86_64.rpm 
warning: mysql-community-libs-8.0.22-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
error: Failed dependencies:
	mariadb-libs is obsoleted by mysql-community-libs-8.0.22-1.el7.x86_64

solution:

	[root@bogon Downloads] rpm -qa | grep mariadb
mariadb-libs-5.5.68-1.el7.x86_64
[root@bogon Downloads] rpm -e mariadb-libs-5.5.68-1.el7.x86_64
error: Failed dependencies:
	libmysqlclient.so.18()(64bit) is needed by (installed) net-snmp-agent-libs-1:5.7.2-49.el7.x86_64
	libmysqlclient.so.18()(64bit) is needed by (installed) net-snmp-1:5.7.2-49.el7.x86_64
	libmysqlclient.so.18()(64bit) is needed by (installed) postfix-2:2.10.1-9.el7.x86_64
	libmysqlclient.so.18(libmysqlclient_18)(64bit) is needed by (installed) net-snmp-agent-libs-1:5.7.2-49.el7.x86_64
	libmysqlclient.so.18(libmysqlclient_18)(64bit) is needed by (installed) postfix-2:2.10.1-9.el7.x86_64
	mysql-libs is needed by (installed) net-snmp-1:5.7.2-49.el7.x86_64
[root@bogon Downloads] rpm -e --nodeps mariadb-libs-5.5.68-1.el7.x86_64

2. Start the mysql service

 [root@bogon mysql] systemctl status mysqld.service
● mysqld.service - MySQL Server
   Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
   Active: inactive (dead)
     Docs: man:mysqld(8)
           http://dev.mysql.com/doc/refman/en/using-systemd.html
[root@bogon mysql] systemctl start mysqld.service
[root@bogon mysql] systemctl status mysqld.service
● mysqld.service - MySQL Server
   Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
   Active: active (running) since Thu 2021-01-14 18:42:31 CST; 5s ago
     Docs: man:mysqld(8)
           http://dev.mysql.com/doc/refman/en/using-systemd.html
  Process: 25591 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)
 Main PID: 25669 (mysqld)
   Status: "Server is operational"
    Tasks: 38
   CGroup: /system.slice/mysqld.service
           └─25669 /usr/sbin/mysqld
Jan 14 18:42:16 bogon systemd[1]: Starting MySQL Server...
Jan 14 18:42:31 bogon systemd[1]: Started MySQL Server.

3. Reset password for root user

• check the temporary password: grep “password” /var/log/mysqld.log
• mysqladmin -uroot -p’oldpassword’ password newpassword (This is an unsafe method)
• log into MySQL using user ‘root’ and temporary password: mysql -uroot -p
• reset password for user ‘root’ in three ways:
  SET PASSWORD FOR root@localhost = ‘Egtc!123456’;
  alter user ‘root’@‘localhost’ identified by ‘Egtc123$’;

4.Create new user

• create user linda@localhost identified by ‘Linda123$’;
• mysql> grant all privileges on student.* to linda@localhost;
• mysql> flush privileges;