校园春色亚洲色图_亚洲视频分类_中文字幕精品一区二区精品_麻豆一区区三区四区产品精品蜜桃

主頁 > 知識庫 > centos 7下安裝mysql(MariaDB)的教程

centos 7下安裝mysql(MariaDB)的教程

熱門標簽:如何辦理400客服電話 西藏地圖標注改進點 外呼系統線路經常出問題嗎 外呼系統怎樣才能不封號 地圖標注什么軟件好用 神行者百貨商場地圖標注 地圖標注專員入駐 安陽手機自動外呼系統原理是什么 地圖標注百度競價

centos7安裝MariaDB教程,分享給大家

1.centos7現狀:

  新系統無法再使用yum install mysql-server來安裝mysql,因為已使用mariadb代替mysql。

2.安裝mariadb:

[root@localhost ~]# yum -y install mariadb*
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
 * base: mirrors.linode.com
 * extras: mirrors.linode.com
 * updates: mirrors.linode.com
Resolving Dependencies
--> Running transaction check
---> Package mariadb.x86_64 1:5.5.37-1.el7_0 will be installed
---> Package mariadb-bench.x86_64 1:5.5.37-1.el7_0 will be installed
---> Package mariadb-devel.x86_64 1:5.5.37-1.el7_0 will be installed
---> Package mariadb-embedded.x86_64 1:5.5.37-1.el7_0 will be installed
---> Package mariadb-embedded-devel.x86_64 1:5.5.37-1.el7_0 will be installed
---> Package mariadb-libs.x86_64 1:5.5.37-1.el7_0 will be installed
---> Package mariadb-server.x86_64 1:5.5.37-1.el7_0 will be installed
--> Processing Dependency: perl-DBD-MySQL for package: 1:mariadb-server-5.5.37-1.el7_0.x86_64
---> Package mariadb-test.x86_64 1:5.5.37-1.el7_0 will be installed
--> Running transaction check
---> Package perl-DBD-MySQL.x86_64 0:4.023-5.el7 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

==========================================================================================================
 Package              Arch       Version           Repository     Size
==========================================================================================================
Installing:
 mariadb              x86_64      1:5.5.37-1.el7_0      updates      8.9 M
 mariadb-bench           x86_64      1:5.5.37-1.el7_0      updates      385 k
 mariadb-devel           x86_64      1:5.5.37-1.el7_0      updates      744 k
 mariadb-embedded         x86_64      1:5.5.37-1.el7_0      updates      3.6 M
 mariadb-embedded-devel      x86_64      1:5.5.37-1.el7_0      updates      7.4 M
 mariadb-libs           x86_64      1:5.5.37-1.el7_0      updates      752 k
 mariadb-server          x86_64      1:5.5.37-1.el7_0      updates       11 M
 mariadb-test           x86_64      1:5.5.37-1.el7_0      updates      7.9 M
Installing for dependencies:
 perl-DBD-MySQL          x86_64      4.023-5.el7         base        140 k

Transaction Summary
==========================================================================================================
Install 8 Packages (+1 Dependent package)

Total download size: 40 M
Installed size: 279 M
Downloading packages:
(1/9): mariadb-bench-5.5.37-1.el7_0.x86_64.rpm                   | 385 kB 00:00:00
(2/9): mariadb-devel-5.5.37-1.el7_0.x86_64.rpm                   | 744 kB 00:00:00
(3/9): mariadb-embedded-5.5.37-1.el7_0.x86_64.rpm                 | 3.6 MB 00:00:00
(4/9): mariadb-5.5.37-1.el7_0.x86_64.rpm                      | 8.9 MB 00:00:00
(5/9): mariadb-libs-5.5.37-1.el7_0.x86_64.rpm                   | 752 kB 00:00:00
(6/9): mariadb-server-5.5.37-1.el7_0.x86_64.rpm                  | 11 MB 00:00:00
(7/9): mariadb-embedded-devel-5.5.37-1.el7_0.x86_64.rpm              | 7.4 MB 00:00:00
(8/9): mariadb-test-5.5.37-1.el7_0.x86_64.rpm                   | 7.9 MB 00:00:00
(9/9): perl-DBD-MySQL-4.023-5.el7.x86_64.rpm                    | 140 kB 00:00:00
----------------------------------------------------------------------------------------------------------
Total                                   36 MB/s | 40 MB 00:00:01
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
 Installing : 1:mariadb-libs-5.5.37-1.el7_0.x86_64                          1/9
 Installing : 1:mariadb-5.5.37-1.el7_0.x86_64                            2/9
 Installing : perl-DBD-MySQL-4.023-5.el7.x86_64                           3/9
 Installing : 1:mariadb-server-5.5.37-1.el7_0.x86_64                         4/9
 Installing : 1:mariadb-devel-5.5.37-1.el7_0.x86_64                         5/9
 Installing : 1:mariadb-embedded-5.5.37-1.el7_0.x86_64                        6/9
 Installing : 1:mariadb-embedded-devel-5.5.37-1.el7_0.x86_64                     7/9
 Installing : 1:mariadb-test-5.5.37-1.el7_0.x86_64                          8/9
 Installing : 1:mariadb-bench-5.5.37-1.el7_0.x86_64                         9/9
 Verifying : 1:mariadb-test-5.5.37-1.el7_0.x86_64                          1/9
 Verifying : 1:mariadb-embedded-devel-5.5.37-1.el7_0.x86_64                     2/9
 Verifying : 1:mariadb-embedded-5.5.37-1.el7_0.x86_64                        3/9
 Verifying : 1:mariadb-libs-5.5.37-1.el7_0.x86_64                          4/9
 Verifying : 1:mariadb-bench-5.5.37-1.el7_0.x86_64                         5/9
 Verifying : 1:mariadb-5.5.37-1.el7_0.x86_64                            6/9
 Verifying : 1:mariadb-server-5.5.37-1.el7_0.x86_64                         7/9
 Verifying : perl-DBD-MySQL-4.023-5.el7.x86_64                           8/9
 Verifying : 1:mariadb-devel-5.5.37-1.el7_0.x86_64                         9/9

Installed:
 mariadb.x86_64 1:5.5.37-1.el7_0            mariadb-bench.x86_64 1:5.5.37-1.el7_0
 mariadb-devel.x86_64 1:5.5.37-1.el7_0         mariadb-embedded.x86_64 1:5.5.37-1.el7_0
 mariadb-embedded-devel.x86_64 1:5.5.37-1.el7_0     mariadb-libs.x86_64 1:5.5.37-1.el7_0
 mariadb-server.x86_64 1:5.5.37-1.el7_0         mariadb-test.x86_64 1:5.5.37-1.el7_0

Dependency Installed:
 perl-DBD-MySQL.x86_64 0:4.023-5.el7

Complete!
[root@localhost ~]# systemctl start mariadb.service
[root@localhost ~]# systemctl enable mariadb.service
ln -s '/usr/lib/systemd/system/mariadb.service' '/etc/systemd/system/multi-user.target.wants/mariadb.servi           
ce'
[root@localhost ~]# mysql
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 2
Server version: 5.5.37-MariaDB MariaDB Server

Copyright (c) 2000, 2014, Oracle, Monty Program Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> logout
  -> exit
  ->
  -> ;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaD           
B server version for the right syntax to use near 'logout
exit' at line 1
MariaDB [(none)]> exit
Bye
[root@localhost ~]# systemctl enable mariadb.service
[root@localhost ~]# mysql
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 3
Server version: 5.5.37-MariaDB MariaDB Server

Copyright (c) 2000, 2014, Oracle, Monty Program Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> show databases;
+--------------------+
| Database      |
+--------------------+
| information_schema |
| mysql       |
| performance_schema |
| test        |
+--------------------+
rows in set (0.00 sec)

MariaDB [(none)]> use test
Database changed
MariaDB [test]> show tables;
Empty set (0.00 sec)

MariaDB [test]> exit
Bye
[root@localhost ~]# mysql_secure_installation
/usr/bin/mysql_secure_installation: line 379: find_mysql_client: command not found

NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MariaDB
   SERVERS IN PRODUCTION USE! PLEASE READ EACH STEP CAREFULLY!

In order to log into MariaDB to secure it, we'll need the current
password for the root user. If you've just installed MariaDB, and
you haven't set the root password yet, the password will be blank,
so you should just press enter here.

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
Enter current password for root (enter for none):
OK, successfully used password, moving on...

Setting the root password ensures that nobody can log into the MariaDB
root user without the proper authorisation.

Set root password? [Y/n] y
New password:
Re-enter new password:
Password updated successfully!
Reloading privilege tables..
 ... Success!


By default, a MariaDB installation has an anonymous user, allowing anyone
to log into MariaDB without having to have a user account created for
them. This is intended only for testing, and to make the installation
go a bit smoother. You should remove them before moving into a
production environment.

Remove anonymous users? [Y/n] y
 ... Success!

Normally, root should only be allowed to connect from 'localhost'. This
ensures that someone cannot guess at the root password from the network.

Disallow root login remotely? [Y/n] y
 ... Success!

By default, MariaDB comes with a database named 'test' that anyone can
access. This is also intended only for testing, and should be removed
before moving into a production environment.

Remove test database and access to it? [Y/n] y
 - Dropping test database...
 ... Success!
 - Removing privileges on test database...
 ... Success!

Reloading the privilege tables will ensure that all changes made so far
will take effect immediately.

Reload privilege tables now? [Y/n] y
 ... Success!

Cleaning up...

All done! If you've completed all of the above steps, your MariaDB
installation should now be secure.

Thanks for using MariaDB!
[root@localhost ~]# mysql -uroot -p
Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 15
Server version: 5.5.37-MariaDB MariaDB Server

Copyright (c) 2000, 2014, Oracle, Monty Program Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> show databases;
+--------------------+
| Database      |
+--------------------+
| information_schema |
| mysql       |
| performance_schema |
| zbphp.com     |
+--------------------+
rows in set (0.00 sec)

MariaDB [(none)]>

以上就是本文的全部內容,希望對大家的學習有所幫助,也希望大家多多支持腳本之家。

您可能感興趣的文章:
  • centos 7安裝mysql5.5和安裝 mariadb使用的命令
  • centos 下面安裝python2.7 +pip +mysqld
  • centos 7安裝mysql5.5的方法
  • CentOS 7中安裝mysql server的步驟分享
  • CentOS下PHP7的編譯安裝及MySQL的支持和一些常見問題的解決辦法
  • mysql 5.7.17 安裝配置方法圖文教程(CentOS7)
  • 64位CentOs7源碼安裝mysql-5.6.35過程分享
  • Centos6.5編譯安裝mysql 5.7.14詳細教程
  • CentOS7.2虛擬機上安裝MySQL 5.6.32的教程
  • Centos7下MySQL安裝教程

標簽:酒泉 AXB 萍鄉 雞西 衡水 阜陽 張掖 貴港

巨人網絡通訊聲明:本文標題《centos 7下安裝mysql(MariaDB)的教程》,本文關鍵詞  centos,7下,安裝,mysql,MariaDB,;如發現本文內容存在版權問題,煩請提供相關信息告之我們,我們將及時溝通與處理。本站內容系統采集于網絡,涉及言論、版權與本站無關。
  • 相關文章
  • 下面列出與本文章《centos 7下安裝mysql(MariaDB)的教程》相關的同類信息!
  • 本頁收集關于centos 7下安裝mysql(MariaDB)的教程的相關信息資訊供網民參考!
  • 推薦文章
    校园春色亚洲色图_亚洲视频分类_中文字幕精品一区二区精品_麻豆一区区三区四区产品精品蜜桃
    欧美亚洲综合色| 国产美女主播视频一区| 久久精品视频在线看| 日韩一级片网址| 99久久精品国产麻豆演员表| 国产999精品久久久久久绿帽| 美女mm1313爽爽久久久蜜臀| 亚洲欧美国产毛片在线| 久久综合九色综合欧美98| 日韩午夜在线观看| 2020国产成人综合网| 久久久久久久久久久99999| 久久影音资源网| 国产精品美女久久久久久2018| 国产精品久线在线观看| 国产精品二区一区二区aⅴ污介绍| 久久这里只有精品视频网| 久久午夜电影网| 亚洲老妇xxxxxx| 国产一区二区在线视频| 韩国av一区二区三区在线观看| 国产成人午夜视频| 色婷婷久久综合| 精品欧美一区二区久久| 中文字幕亚洲综合久久菠萝蜜| 亚洲精品欧美综合四区| 亚洲综合男人的天堂| 日本亚洲欧美天堂免费| 成人午夜视频在线| 日韩欧美亚洲国产精品字幕久久久| 国产欧美视频在线观看| 日日夜夜免费精品| 91久久精品日日躁夜夜躁欧美| 91精品一区二区三区久久久久久| 国产精品毛片久久久久久| 喷水一区二区三区| 91免费观看视频| 欧美精品乱码久久久久久按摩| 久久精品男人天堂av| 天堂va蜜桃一区二区三区漫画版| 懂色av一区二区夜夜嗨| 久久这里只精品最新地址| 蜜芽一区二区三区| 色呦呦一区二区三区| 国产精品国产自产拍在线| 国产福利一区二区三区| 欧美日韩免费一区二区三区| 欧美成人猛片aaaaaaa| 亚洲国产欧美日韩另类综合 | 91免费观看视频在线| 国产亚洲精品精华液| 婷婷一区二区三区| 欧美一区二区二区| 国产九九视频一区二区三区| 久久久久久久久久久久久女国产乱 | 亚洲人成网站影音先锋播放| 国产精品18久久久久| 中文字幕一区在线观看视频| 国产成人精品影视| 国产精品亲子乱子伦xxxx裸| 成人精品视频一区二区三区| 最新不卡av在线| 欧美日韩中文国产| 视频一区二区欧美| 久久久久久久久久看片| 波多野结衣中文字幕一区| 亚洲精品国久久99热| 日韩欧美资源站| 成人黄色777网| 久久99精品国产麻豆不卡| 国产精品午夜在线| 欧美精选午夜久久久乱码6080| 黄一区二区三区| 亚洲激情成人在线| 欧美成人艳星乳罩| 91在线一区二区三区| 美日韩一区二区| 亚洲欧美一区二区三区国产精品| 91九色02白丝porn| 成人ar影院免费观看视频| 国内成+人亚洲+欧美+综合在线| 亚洲激情六月丁香| 国产精品久久久久久亚洲伦| 欧美性猛交xxxx乱大交退制版| 国产精品中文字幕日韩精品| 五月天丁香久久| 香蕉乱码成人久久天堂爱免费| 亚洲视频免费观看| 中国av一区二区三区| 久久久久久久国产精品影院| 日韩视频在线永久播放| 日韩一区二区麻豆国产| 欧美成人a在线| 91精品国产综合久久国产大片| 色综合视频一区二区三区高清| 91在线观看成人| 欧美日本一区二区在线观看| 欧美巨大另类极品videosbest | www.成人在线| 色综合一区二区| 91免费看视频| 欧洲在线/亚洲| 欧美军同video69gay| 精品国产精品网麻豆系列| 久久久久亚洲蜜桃| 一区二区三区中文免费| 日韩国产在线一| 国产乱色国产精品免费视频| 欧美人体做爰大胆视频| 成人永久免费视频| 国产成人久久精品77777最新版本 国产成人鲁色资源国产91色综 | 国产精品香蕉一区二区三区| 亚洲人成7777| 午夜精品久久久久| aaa亚洲精品| 亚洲韩国一区二区三区| 91精品国产综合久久香蕉麻豆| 色八戒一区二区三区| 91小视频免费观看| 666欧美在线视频| 国产精品成人午夜| 欧美aⅴ一区二区三区视频| 99久久久精品| 精品久久久久久久久久久久久久久久久 | 另类中文字幕网| 成人综合婷婷国产精品久久 | 欧美一二三区精品| 国产精品久久久久永久免费观看 | 日韩电影免费一区| 豆国产96在线|亚洲| 欧美男人的天堂一二区| 国产精品理伦片| 久久精品国产99国产| 在线免费不卡视频| 中文久久乱码一区二区| 蜜臀av性久久久久av蜜臀妖精| 欧美日韩中文国产| 欧美国产欧美综合| 精品一区二区三区在线播放视频| 91精品91久久久中77777| 欧美国产日本视频| 国产一区在线看| 日韩欧美一区在线| 日韩一区欧美二区| 欧美色精品天天在线观看视频| 中文字幕一区视频| 国产成人精品免费在线| 欧美大胆一级视频| 日本一区中文字幕| 欧美二区在线观看| 午夜精品久久久久久久久久| 色狠狠色狠狠综合| 一区二区在线电影| 色综合久久久网| 中文字幕一区二区三区蜜月 | 国产精品你懂的在线欣赏| 国产成人在线观看| 亚洲欧美另类图片小说| 91啪亚洲精品| 美女被吸乳得到大胸91| 久久影音资源网| 色88888久久久久久影院野外| 亚洲精品成a人| 日韩精品一区二区三区在线 | 亚洲精品视频一区| 91色在线porny| 日本vs亚洲vs韩国一区三区二区| 51久久夜色精品国产麻豆| 久久99国产精品免费网站| 久久免费视频一区| 91在线免费看| 成人夜色视频网站在线观看| 亚洲一区二区成人在线观看| 一区二区三国产精华液| 欧美大片拔萝卜| 欧美日韩1区2区| 在线精品视频小说1| 国产在线播放一区| 亚洲免费观看高清完整版在线观看熊| 久久蜜臀精品av| 麻豆精品在线看| 日本道免费精品一区二区三区| 337p粉嫩大胆噜噜噜噜噜91av| 免费美女久久99| 精品粉嫩aⅴ一区二区三区四区| 国产精品一卡二卡| 中文字幕亚洲成人| 91丨porny丨蝌蚪视频| 亚洲超碰精品一区二区| 欧美成人精品3d动漫h| 国产麻豆精品视频| 亚洲欧洲国产日本综合| 色狠狠av一区二区三区| 日韩黄色免费电影| 中文字幕五月欧美| 久久免费午夜影院| 亚洲精品一线二线三线| 欧美成人综合网站| 国产视频视频一区| 中文字幕一区二区不卡|