Centos 7 binary installation and configuration MariaDB database
Since each company’s database server version is different, I still recommend everyone to use the Mariadb database. At least for now, the community and products are very stable. As for any new features, it is recommended to go to its official website to learn more about the features.
View system version command
$ cat /etc/redhat-release CentOS Linux release 7.4.1708 (Core) x64
Download the MariaDB binary installation package:
https://downloads.mariadb.org 解压并安装 Mariadb-devel 静态库： $ yum install mariadb-devel numactl -y $ mkdir /renwole $ cd /renwole $ tar zxvf mariadb-10.2.8-linux-glibc_214-x86_64.tar.gz 移动目录并创建软连接： $ mv mariadb-10.2.8-linux-glibc_214-x86_64 /usr/local $ cd /usr/local $ ln -s mariadb-10.2.8-linux-glibc_214-x86_64 mysql 创建 MariaDB（MySQL）用户和组 $ groupadd mysql $ useradd -g mysql mysql 赋予 MariaDB（MySQL）目录权限： $ cd /usr/local/mysql $ chown -R root . $ chown -R mysql data
Delete the built-in my.cnf configuration file and create a new configuration file:
$ rm -rf /etc/my.cnf $ cp /usr/local/mysql/support-files/my-large.cnf /etc/my.cnf
Note: There are 5 configuration files under /usr/local/mysql/support-files. Please select the configuration file according to the memory size of the server (you can also customize and optimize the my.cnf configuration file. If you have it before, as long as it is the same The version can be used normally, so there is no need to create it again. When MariaDB (MySQL) starts, it will automatically look for the my.cnf file in /etc).
The files are:
my-small.ini （内存 <pre class="brush:php;toolbar:false"> $ vim /etc/my.cnf datadir = /usr/local/mysql/data
Note: This path is used to initialize the database. In the future, your database will exist in this directory. This storage path can be changed to other paths to avoid unnecessary losses caused by future system downtime, so please change it according to your own needs. For relative paths, don’t forget to give permissions.
$ cd /usr/local/mysql/scripts $ ./mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data $ cd /usr/local/mysql/support-files $ cp mysql.server /etc/init.d/mysql $ chmod +x /etc/init.d/mysql $ systemctl enable mysql 添加系统变量，例如直接输入：mysql -uroot -p 会提示无此命令： $ vim /etc/profile 在文件末端添加以下内容： PATH=$PATH:/usr/local/mysql/bin export PATH 使变量立即生效并启动Mysql数据库： $ source /etc/profile $ systemctl restart mysql $ ss -antp
$ /usr/local/mysql/bin/mysql_secure_installation
Note: Press Enter to prompt you to enter the MariaDB (MySQL) password. The newly installed mysql password is empty by default, so just press Enter, then enter Y to set the MySQL password. Enter twice and press Enter. Then press Y all the way ( The general meaning is to delete the test database, anonymous account, and finally the Y configuration takes effect
.The above is the detailed content of Centos 7 binary installation and configuration MariaDB database. For more information, please follow other related articles on the PHP Chinese website!
Hot AI Tools
Undress AI Tool
Undress images for free
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Clothoff.io
AI clothes remover
Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
How to install software on Linux using the terminal?
Aug 02, 2025 pm 12:58 PM
There are three main ways to install software on Linux: 1. Use a package manager, such as apt, dnf or pacman, and then execute the install command after updating the source, such as sudoaptininstallcurl; 2. For .deb or .rpm files, use dpkg or rpm commands to install, and repair dependencies when needed; 3. Use snap or flatpak to install applications across platforms, such as sudosnapinstall software name, which is suitable for users who are pursuing version updates. It is recommended to use the system's own package manager for better compatibility and performance.
The Ultimate Guide to High-Performance Gaming on Linux
Aug 03, 2025 am 05:51 AM
ChoosePop!_OS,Ubuntu,NobaraLinux,orArchLinuxforoptimalgamingperformancewithminimaloverhead.2.InstallofficialNVIDIAproprietarydriversforNVIDIAGPUs,ensureup-to-dateMesaandkernelversionsforAMDandIntelGPUs.3.EnabletheperformanceCPUgovernor,usealow-latenc
What are the main pros and cons of Linux vs. Windows?
Aug 03, 2025 am 02:56 AM
Linux is suitable for old hardware, has high security and is customizable, but has weak software compatibility; Windows software is rich and easy to use, but has high resource utilization. 1. In terms of performance, Linux is lightweight and efficient, suitable for old devices; Windows has high hardware requirements. 2. In terms of software, Windows has wider compatibility, especially professional tools and games; Linux needs to use tools to run some software. 3. In terms of security, Linux permission management is stricter and updates are convenient; although Windows is protected, it is still vulnerable to attacks. 4. In terms of difficulty of use, the Linux learning curve is steep; Windows operation is intuitive. Choose according to requirements: choose Linux with performance and security, and choose Windows with compatibility and ease of use.
Understanding RAID Configurations on a Linux Server
Aug 05, 2025 am 11:50 AM
RAIDimprovesstorageperformanceandreliabilityonLinuxserversthroughvariousconfigurations;RAID0offersspeedbutnoredundancy;RAID1providesmirroringforcriticaldatawith50�pacityloss;RAID5supportssingle-drivefailuretoleranceusingparityandrequiresatleastthre
Linux how to enable and disable services at boot
Aug 08, 2025 am 10:23 AM
To manage the startup of Linux services, use the systemctl command. 1. Check the service status: systemctlstatus can check whether the service is running, enabled or disabled. 2. Enable the service startup: sudosystemctlenable, such as sudosystemctlenablenginx. If it is started at the same time, use sudosystemctlenable--nownginx. 3. Disable the service startup: sudosystemctldisable, such as sudosystemctldisablecups. If it is stopped at the same time, use sudosystemctldisabl
Linux how to list all running processes
Aug 08, 2025 am 06:42 AM
Usepsauxforacompletesnapshotofallrunningprocesses,showingdetailedinformationlikeUSER,PID,CPU,andmemoryusage.2.Usetoporhtopforreal-timemonitoringofprocesseswithdynamicupdates,wherehtopoffersamoreintuitiveinterface.3.UsepgreporpidoftoquicklyfindthePIDs
How to clean up your Linux system
Aug 22, 2025 am 07:42 AM
Removeunusedpackagesanddependencieswithsudoaptautoremove,cleanpackagecacheusingsudoaptcleanorautoclean,andremoveoldkernelsviasudoaptautoremove--purge.2.Clearsystemlogswithsudojournalctl--vacuum-time=7d,deletearchivedlogsin/var/log,andempty/tmpand/var
Linux how to view the contents of a file
Aug 19, 2025 pm 06:44 PM
ToviewfilecontentsinLinux,usedifferentcommandsbasedonyourneeds:1.Forsmallfiles,usecattodisplaytheentirecontentatonce,withcat-ntoshowlinenumbers.2.Forlargefiles,uselesstoscrollpagebypageorlinebyline,searchwith/search_term,andquitwithq.3.Usemoreforbasi
