Pages

Wednesday, December 24, 2014

centos 7 mariadb to mysql server in vritualmin webmin




 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