CentOS Install MySQL

cd/usr/local/src/

wget http://repo.mysql.com/mysql57-community-release-el7-8.noarch.rpm

RPM-IVH mysql57-community-release-el7-8.noarch.rpm

Yum-y Install Mysql-server

Default configuration file path:
Configuration file:/etc/my.cnf
Log file:/var/log/var/log/mysqld.log
Service startup script:/usr/lib/systemd/system/mysqld.service
Socket file:/var/run/mysqld/mysqld.pid

MY.CNF:

1. datadir=/Var/lib/mysql
2. socket=/Var/lib/mysql/mysql.sock
3. server_id = 1
4. Expire_logs_days = 3

Start the MySQL service

Service mysqld Restart

View Current Password:

grep "Password"/var/log/mysqld.log

Reset Password:

<<mysql<< alter user ' root ' @ ' localhost ' identified by ' root!! 2018 ';

Remote connection:

Use MySQL

Grant all privileges on * * to [email protected] '% ' identified by ' password ';

Flush privileges;

CentOS Install MySQL