cd /etc/yum.repos.d/
mv MariaDB.repo MariaDB-old
systemctl stop mariadb.service
wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm
rpm -ivh mysql-community-release-el7-5.noarch.rpm
yum remove mariadb-server mariadb
yum install mysql-server
/usr/bin/mysql_secure_installation
service mysql start
mysql -u root -p
systemctl disable mariadb
systemctl enable mysqld
wget http://software.virtualmin.com/gpl/scripts/install.sh
chmod +x install.sh
vi install.sh
remove mariadb mariadb-server
./install.sh
vi /etc/my.cnf
Hash or Off this line
# Recommended in standard MySQL setup
#sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
goto https://ipaddress:10000
Click -- webmin ---> Servers----> MySQL Database Server--> Module Config--> Configurable Options to System Configuration-->
Command to start MySQL server---/bin/systemctl start mysqld.service -->
Command to stop MySQL server--/bin/systemctl stop mysqld.service--> Save
No comments:
Post a Comment