RHEL 7 Installation Mariadb

RedHat Enterprise Linux 7 starts. The database that comes with the system disk is MARIADB, and the installation process is as follows:

1. Mount the installation disk image:mount/dev/cdrom/mnt

2. Create a Yum Source:cat >/etc/yum.repos.d/d.repo << EOF

[d]

Baseurl=file:///mnt

Eof

3. Import KEY:yum--import/mnt/rpm-gpg-key-redhat-release

4. Installation:yum-y install mariadb-server mariadb

5. Complete the installation. Start service:systemctl start Mariadb.service

6. Set up self-boot:systemctl enable Mariadb.service

7. Interview mariadb:mysql-u root-p password is empty

8. View the database:show databases;

9. After installation, unmount the optical drive:umount/mnt

10. Delete the Yum Source:rm-f/etc/yum.repos.d/d/repo

11. Set the root user password:mysqladmin-u root-h host_name password "newpwd"

12. Set Remote access Permissions

mysql-u Root-ppassword //Enter the MySQL console

mysql>use MySQL;

mysql>update User Set host = '% ' where user = ' root '; This command can be skipped when running an error

Mysql>flush privileges;

mysql>select Host, user from user; Check that '% ' is inserted into the database

Mysql>quit

13.After [mysqld] in/etc/my.cnf, join the Lower_case_table_names=1 and restart the MySQL service. This has been set successfully.

0: Distinguishes between uppercase and lowercase, 1: uppercase and lowercase are not distinguished.

( follow the public number.) Get a lot of other content )

RHEL 7 Installation Mariadb