CentOS7 installing MySQL

Replaced MySQL database with mariadb in CENTOS7

1. Make sure Yum is on the machine and perform the installation command

Yum Install mariadb Maraidb-server

2. Start MARIADB

Systemctl start mariadb# Set boot Systemctl enable mariadb# close Mariadbsystemctl Stop mariadb# restart Maraidbsystemctl restart Mariadb

3, modify the user password 3.1, in the MySQL database to modify the user table password

-- This test modifies the root user's password -- password is a cryptographic function Update User set Password=password ('root'whereuser  ='root';

3.2. Make the settings effective

privileges;

4. Set Allow remote connection

--authorization to all users of all machines with Root/root login to change the access to all tables and additionsGrant  All  on *.*  to 'Root'@'%'Identified by 'Root';--All Permissions--* * All the tables etc.--root user of ' root ' @ '% ' all machines--identified by ' root ' login with root password

Executes the statement in 3.2, which is set to take effect

Setup is complete!

CentOS7 installing MySQL