Learn In Linux Plateform: installing MySQL 5.6 in Centos server and client

how to install MySQL in centos 7.5
----------------------------------

first install centos7.5 server with gui. I presuume you hava successfully installed it. now download MYSQL for el7. extract it. open terminal and goto extracted files as these will be :-

MySQL-client-5.6.36-1.el7.x86_64.rpm
MySQL-devel-5.6.36-1.el7.x86_64.rpm
MySQL-embedded-5.6.36-1.el7.x86_64.rpm
MySQL-server-5.6.36-1.el7.x86_64.rpm
MySQL-shared-5.6.36-1.el7.x86_64.rpm
MySQL-shared-compat-5.6.36-1.el7.x86_64.rpm
MySQL-test-5.6.36-1.el7.x86_64.rpm

login as root and run following command :-

# rpm -ivh --force *.rpm

then :-

# service mysql start

now open new tab in teminal login as root(by ctrl + Shift + T ) then give folloawing command :-

# gedit /root/.mysql_secret

there will be password for root.

copy that password and give following command :-

# mysql_secure_installation

this will ask you password for root user.
paste that copied password by ( CTRL + SHIFT + V )

now change your root password.
remove anonymous user : y

Disallow root login remotely? [Y/n] y
Remove test database and access to it? [Y/n] n

Reloading the privilege tables will ensure that all changes made so far
will take effect immediately.

Reload privilege tables now? [Y/n] y
... Success!

now installing workbecnch for centos7:-

you need following rpms to install workbench:-

glibc-2.17-222.el7.x86_64.rpm
libtomcrypt-1.17-25.el7.x86_64.rpm
libtomcrypt-1.17-26.el7.x86_64.rpm
libtommath-0.42.0-5.el7.x86_64.rpm
libtommath-0.42.0-6.el7.x86_64.rpm
libzip-0.10.1-8.el7.x86_64.rpm
mysql-workbench-community-8.0.22-1.el7.x86_64.rpm
proj-4.8.0-4.el7.x86_64.rpm
python2-crypto-2.6.1-15.el7.x86_64.rpm
python2-cryptography-1.7.2-2.el7.x86_64.rpm
python3-3.6.8-13.el7.x86_64.rpm
python3-libs-3.6.8-13.el7.x86_64.rpm
python3-pip-9.0.3-7.el7_7.noarch.rpm
python3-setuptools-39.2.0-10.el7.noarch.rpm
python-paramiko-2.1.1-4.el7.noarch.rpm
python-paramiko-2.1.1-9.el7.noarch.rpm
support of data.txt
tinyxml-2.6.2-3.el7.x86_64.rpm
unixODBC-2.3.1-11.el7.x86_64.rpm

now create user and give fallowing command in terminal :-

[root@centos75server /]# mysql -u username -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 27
Server version: 5.6.36 MySQL Community Server (GPL)

Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

now MySQL server is installed successfully.

Now installing MySQL in client:-

install following rpms

MySQL-client-5.6.36-1.el7.x86_64.rpm
MySQL-devel-5.6.36-1.el7.x86_64.rpm
MySQL-embedded-5.6.36-1.el7.x86_64.rpm
MySQL-shared-5.6.36-1.el7.x86_64.rpm
MySQL-shared-compat-5.6.36-1.el7.x86_64.rpm
MySQL-test-5.6.36-1.el7.x86_64.rpm

install workbench in client same as described above for server .

now run workbench. login as root.

click on + . new account.