...
STEP 1. Enable MySQL Repository
| Code Block |
|---|
sudo yum -y localinstall https://dev.mysql.com/get/mysql57-community-release-el7-9.noarch.rpm |
...
STEP 2. Install MySQL 5.7 Server
| Code Block |
|---|
sudo yum -y install mysql-community-server |
...
STEP 3. Start MySQL Service
| Code Block |
|---|
sudo service mysqld start |
STEP 4. Checking temporary password
| Code Block |
|---|
sudo grep 'A temporary password' /var/log/mysqld.log | tail -1 |
...
Change password by the pre-defined password above
| Code Block |
|---|
mysql_secure_installation |
Adding a mysql user account
| Code Block |
|---|
mysql -uroot -p<password>
#uninstall pluging to validate_password (not recommended)
uninstall plugin validate_password;
# below script is to create user account for local connection
CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'user_password';
# below script is to create user account can conneect from 1.2.3.4
CREATE USER 'newuser'@'1.2.3.4' IDENTIFIED BY 'user_password';
# below script is to create user account for any connection
CREATE USER 'newuser'@'%' IDENTIFIED BY 'user_password'; |
Granting user permission
| Code Block |
|---|
mysql -uroot -p<password> # grant privileges on a certain database GRANT ALL PRIVILEGES ON database_name.* TO 'database_user'@'localhost'; # grant privileges on all the database in the system GRANT ALL PRIVILEGES ON *.* TO 'database_user'@'localhost'; # grant full privileges on all the database in the system GRANT ALL PRIVILEGES ON *.* TO 'database_user'@'localhost' REQUIRE NONE WITH GRANT OPTION MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0;mysqladmin -u root -p password |
STEP 5. Initial MySQL Configuration
...