11 任务1:安装 MariaDB 任务目标 完成 MariaDB的安装与配置 ¤实现数据库、数据表的创建 操作视频/现场演示
操作视频 / 现场演示 11 ✓ 任务1：安装MariaDB ◼ 任务目标 完成MariaDB的安装与配置 实现数据库、数据表的创建
2. touch /etc/yum. repos.d/MariaDB repo 12 3. echo [mariadb]>/etc/yum. repos. d/MariaDB repo 4. echo name MariaDB >>/etc/yum. repos. d/MariaDB repo 5.echobaseurl=https://mirrors.allyun.com/mariadb/yum/10.4/centos8-amd64>>/etc/yum.repos.d/mariadb.repo 6. echo module hotfixes=1 >>/etc/yum. repos, d/MariaDB repo echogpgkey=https://mirrors,aliyun.com/mariadb/yum/rpm-gpg-key-mariadb>>/etc/yum.reposd/mariAdb.repo 8. echo gpgcheck=1 >>/etc/yum. repos, d/MariaDB re 9. Install MariaDB 10.yum install MariaDB-server-y 命令指南/操作引导 n1.# Start mariadb 12. systemctl start mariadb 13.# Look MariaDB 14.# systemctl status mariadb head -10 15. systemctl status mariadb 17. systemctl enable mariadb 18. systemctl is-enabled mariadb 19.# Use the initial root permission for the MariaDB client 20. mysql - 'set password password(centos@mariadb#123) mysql -create database firstdb 24. mysql -euse firstdb create table test table(id int(11), name varchar(20), sex enum(o, 1, 2), primary key(id) 25. mysql -e"use firstdb show tables
命令指南 / 操作引导 12 1. # Configure MariaDB 2. touch /etc/yum.repos.d/MariaDB.repo 3. echo [mariadb] > /etc/yum.repos.d/MariaDB.repo 4. echo name = MariaDB >> /etc/yum.repos.d/MariaDB.repo 5. echo baseurl = https://mirrors.aliyun.com/mariadb/yum/10.4/centos8-amd64 >> /etc/yum.repos.d/MariaDB.repo 6. echo module_hotfixes=1 >> /etc/yum.repos.d/MariaDB.repo 7. echo gpgkey= https://mirrors.aliyun.com/mariadb/yum/RPM-GPG-KEY-MariaDB >> /etc/yum.repos.d/MariaDB.repo 8. echo gpgcheck=1 >> /etc/yum.repos.d/MariaDB.repo 9. # Install MariaDB 10. yum install MariaDB-server -y 11. # Start mariadb 12. systemctl start mariadb 13. # Look MariaDB 14. # systemctl status mariadb | head -10 15. systemctl status mariadb 16. # Configuration mariadb 17. systemctl enable mariadb 18. systemctl is-enabled mariadb 19. # Use the initial root permission for the MariaDB client 20. mysql -e "set password = password('centos@mariadb#123');" 21. # Use MariaDB 22. mysql -e "create database firstdb;" 23. mysql -e "show databases;" 24. mysql -e "use firstdb;create table test_table(id int(11),name varchar(20),sex enum('0','1','2'),primary key (id));" 25. mysql -e "use firstdb;show tables;
13 2管理 MariaDB phpMyAdmin Navicat Web方式管理 客户端方式管理 运维监控 河南中医药大学/阮晓龙713938213680/http://inux.xg.hactcm.edu.cn/http://www.5lxueweb.cn
河南中医药大学 / 阮晓龙 / 13938213680 / http://linux.xg.hactcm.edu.cn / http://www.51xueweb.cn 2.管理MariaDB 13 Web方式管理 客户端方式管理 运维监控
14 2管理 MariaDB phpMyAdmin 2.1 PHPMyAdmin o phpMyAdmin is a free software tool written in PHP, intended to handle the administration of MySQL over the Web. phpMyAdmin supports a wide range of operations on MySQL and MariaDB. Frequently used operations(managing databases, tables, columns, relations, indexes users, permissions, etc) can be performed via the user interface, while you still have the ability to directly execute any sql statement phpMyAdmin comes with a wide range of documentation and users are welcome to update our wiki pages to share ideas and howtos for various operations. The phpMyAdmin team will try to help you if you face any problem; you can use a variety of support channels to help To ease usage to a wide range of people, phpMyAdmin is being translated into languages and supports both ltr and rtl languages phpMyAdmin is a mature project with a stable and flexible code base; you can find out more about the project and its history and the awards it earned o The phpMyAdmin project is a member of Software Freedom Conservancy. SFC is a not-for profit organization that helps promote, improve, develop, and defend Free, Libre, and Open Source Software(FLOSS) projects 河南中医药大学/阮晓龙713938213680/http://inux.xg.hactcm.edu.cn/http://www.5lxueweb.cn
河南中医药大学 / 阮晓龙 / 13938213680 / http://linux.xg.hactcm.edu.cn / http://www.51xueweb.cn 2.管理MariaDB phpMyAdmin is a free software tool written in PHP, intended to handle the administration of MySQL over the Web. phpMyAdmin supports a wide range of operations on MySQL and MariaDB. Frequently used operations (managing databases, tables, columns, relations, indexes, users, permissions, etc) can be performed via the user interface, while you still have the ability to directly execute any SQL statement. phpMyAdmin comes with a wide range of documentation and users are welcome to update our wiki pages to share ideas and howtos for various operations. The phpMyAdmin team will try to help you if you face any problem; you can use a variety of support channels to get help.To ease usage to a wide range of people, phpMyAdmin is being translated into 72 languages and supports both LTR and RTL languages. phpMyAdmin is a mature project with a stable and flexible code base; you can find out more about the project and its history and the awards it earned. The phpMyAdmin project is a member of Software Freedom Conservancy. SFC is a not-forprofit organization that helps promote, improve, develop, and defend Free, Libre, and Open Source Software (FLOSS) projects. 14 2.1 PHPMyAdmin
15 2管理 MariaDB phpMyAdmin 2.1 PHPMyAdmin a Features Intuitive web interface Support for most MySQL features browse and drop databases, tables, views, fields and indexes create, copy, drop, rename and alter databases, tables, fields and indexes o maintenance server, databases and tables, with proposals on server configuration o execute, edit and bookmark any SQL-statement, even batch-queries 口mana ge MySQL user accounts and privileges o manage stored procedures and triggers port data from CSV and SQL Export data to various formats: CSV, SQL, XML, PDF, ISO/EC 26300-OpenDocument Text and Spreadsheet, Word, LATEX and others Administering multiple servers Creating graphics of your database layout in various formats Creating complex queries using Query-by-example(QBE) Searching globally in a database or a subset of it Transforming stored data into any format using a set of predefined functions, like displaying BLOB-data as image or o And much more 河南中医药大学/阮晓龙713938213680/http://inux.xg.hactcm.edu.cn/http://www.5lxueweb.cn
河南中医药大学 / 阮晓龙 / 13938213680 / http://linux.xg.hactcm.edu.cn / http://www.51xueweb.cn 2.管理MariaDB Features ◼ Intuitive web interface ◼ Support for most MySQL features: browse and drop databases, tables, views, fields and indexes create, copy, drop, rename and alter databases, tables, fields and indexes maintenance server, databases and tables, with proposals on server configuration execute, edit and bookmark any SQL-statement, even batch-queries manage MySQL user accounts and privileges manage stored procedures and triggers ◼ Import data from CSV and SQL ◼ Export data to various formats: CSV, SQL, XML, PDF, ISO/IEC 26300 - OpenDocument Text and Spreadsheet, Word, LATEX and others ◼ Administering multiple servers ◼ Creating graphics of your database layout in various formats ◼ Creating complex queries using Query-by-example (QBE) ◼ Searching globally in a database or a subset of it ◼ Transforming stored data into any format using a set of predefined functions, like displaying BLOB-data as image or download-link ◼ And much more... 15 2.1 PHPMyAdmin