Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

Mysql Learning Notes (4-General binary format installation MariaDB)

2025-04-04 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

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

Install and use MariaDB:

Installation method:

(1) rpm package

(a) provided by the issuer of OS

(B) official provision of procedures

(2) Source code packet

(3) packages in general binary format

Install MariaDB in universal binary format:

(1) prepare the data directory

Take the / mydata/data directory as an example

(2) install and configure mariadb

# useradd-r mysql

# tar xf mariadb-VERSION.tar.xz-C / usr/local

# cd / usr/local

# ln-sv mariadb-VERSION mysql

# cd / usr/local/mysql

# chown-R root:mysql. / *

# scripts/mysql_install_db-- user=mysql-datadir=/mydata/data

# cp support-files/mysql.server / etc/init.d/mysqld

# chkconfig-add mysqld

(3) provide configuration file

A configuration file in ini format through which all programs can obtain configuration information

[program_name]

OS Vendor provides the profile lookup order for the services installed by the mariadb rpm package:

/ etc/mysql/my.cnf-> / etc/my.cnf-- >-- default-extra-file=/PATH/TO/CONF_FILE-- > ~ / .my.cnf

The lookup order of configuration files for service programs installed in universal binary format:

/ etc/my.cnf-> / etc/mysql/my.cnf-- >-- default-extra-file=/PATH/TO/CONF_FILE-- > ~ / .my.cnf

The method to get its reading order:

Mysqld-verbose-help

# cp support-files/my-large.cnf / etc/my.cnf

Add three options:

Datadir = / mydata/data

Innodb_file_per_table = ON

Skip_name_resolve = ON

(4) start the service

# service mysqld start

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.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report