Configuration MySQL

Config_MySQL.sh

# Show the default password for root user

grep "A temporary password" /var/log/mysqld.log

# MySQL Secure Installation

mysql_secure_installation


# Remove anonymous users? (Press y|Y for Yes, any other key for No) : y
 
# Disallow root login remotely? (Press y|Y for Yes, any other key for No) : y
 
# Remove test database and access to it? (Press y|Y for Yes, any other key for No) : y
 
# Reload privilege tables now? (Press y|Y for Yes, any other key for No) : y
# Step 6. Restart and enable the MySQL service

# Use the following command to restart the mysql service:

# Restart MySQL 
service mysqld restart

# Connect to MySQL server
mysql -u root -p

# mysql>
#Use the SHOW DATABASESto display all databases in the current server:

#mysql> show databases;

#+--------------------+
#| Database           |
#+--------------------+
#| information_schema |
#| mysql              |
#| performance_schema |
#| sys                |
#+--------------------+