Shulou(Shulou.com)06/01 Report--

1. Query MariaDB package

[root@test ~] # yum list all | grep mariadb

2. Install mariaDB

[root@test ~] # yum-y install mariadb-server

3. Configure mariaDB

[root@test ~] # systemctl start mariadb # start MariaDB [root @ test ~] # systemctl enable mariadb # set MariaDB to boot self-boot [root@test ~] # netstat-ntlp # check whether port 3306 successfully starts [root@test ~] # mysql_secure_installation # first installation requires data base configuration Enter current password for root (enter for none): # enter data The password of the library super administrator root (note that it is not the password of the system root) Enter Set root password directly if you enter for the first time without setting a password? Set the password, yNew password: # New password Re-enter new password: # enter the password again Remove anonymous users? [YBO] # remove anonymous users, yDisallow root login remotely? [YBO] # deny root remote login, yRemove test database and access to it? [test] # Delete the database, y: delete. N: do not delete, there will be a test database in the database, generally do not need Reload privilege tables now? [YBO] # reload permissions table, y. Or restart the service, maybe.

4. Log in to test mariaDB

[root@test] # mysql-u root-pEnter password:Welcome to the MariaDB monitor. Commands end with; or\ g.Your MariaDB connection id is 8Server version: 5.5.60-MariaDB MariaDB ServerCopyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.Type 'help;' or'\ h' for help. Type'\ c' to clear the current input statement.MariaDB [(none)] > MariaDB [(none)] > quit

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.