当前位置: 代码迷 >> 综合 >> centos7 安装 mariadb-10
  详细解决方案

centos7 安装 mariadb-10

热度:10   发布时间:2024-01-03 13:45:56.0


下载地址:

http://mirrors.ustc.edu.cn/mariadb/mariadb-10.0.19/source/mariadb-10.0.19.tar.gz



因为用cmake所以线安装下这个 可以


yum install cmake



下载了tar.gz文件解压到指定的目录tar -zxvf XXX.tar.gz

进入到安装目录

[hcr@localhostmariadb-10.0.19]$ pwd

/app/mysql/mariadb-10.0.19


//创建下用户 分组,需要安装的目录,和数据库目录

[hcr@localhostmariadb-10.0.19]$ sudo groupadd mysql

[sudo] password forhcr:

[hcr@localhostmariadb-10.0.19]$ sudo useradd -g mysql mysql -s /bin/false

[hcr@localhostmariadb-10.0.19]$ mkdir -p /app/data/mysql

[hcr@localhostmariadb-10.0.19]$ sudo chown -R mysql:mysql /app/data/mysql/

[hcr@localhostmariadb-10.0.19]$ mkdir /app/local/mysql




cmake . -DCMAKE_INSTALL_PREFIX=/app/local/mysql -DMYSQL_DATADIR=/app/data/mysql/ -DSYSCONFDIR=/etc



这儿可能会碰到 缺少ncurses(Curseslibrary not found异常)的问题,可以安装下,

yum installncurses-devel 或者现在rpm 指定安装

如果安装了还报错 可以考录把当前目录删除掉然后重新解压一下,然后重新执行一下上边的命令


[hcr@localhostmariadb-10.0.19]$ make

//此处有点,我去坑爹阿,太长时间了等把,早知道应该选择

[hcr@localhostmariadb-10.0.19]$ make install

//一堆的installing

[hcr@localhostmariadb-10.0.19]$ cd /app/local/mysql/

[hcr@localhostmysql]$ sudo cp support-files/my-huge.cnf /etc/my.cnf



[hcr@localhostmysql]$ sudo vi /etc/my.cnf //编辑配置文件,[mysqld]部分增加 datadir= /app/data/mysql  //添加MariaDB数据库路径

datadir =/app/data/mysql

[hcr@localhostmysql]$ sudo cp ./support-files/mysql.server /etc/rc.d/init.d/mysqld

[hcr@localhostmysql]$ sudo chmod 755 /etc/init.d/mysqld

[hcr@localhostmysql]$ sudo chkconfig mysqld on


[hcr@localhostmysql]$ sudo vi /etc/rc.d/init.d/mysqld


这个地方默认是

basedir=

datadir=

改成

basedir =/app/local/mysql  #MariaDB程序安装路径
datadir= /app/data/mysql  #MariaDB数据库存放目录


//服务启动

[hcr@localhostmysql]$ sudo service mysqld start

Starting MySQL.SUCCESS!


//配置到环境中

[hcr@localhostmysql]$ sudo vi /etc/profile //增加了一个环境变量

exportPATH=$PATH:/app/local/mysql/bin



到这儿重起下机器

[hcr@localhostmysql]$ sudo shutdown -r now



初始化mysqlroot密码

[root@localhost ~]#mysql_secure_installation

NOTE: RUNNING ALLPARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MariaDB

SERVERS INPRODUCTION USE! PLEASE READ EACH STEP CAREFULLY!

In order to log intoMariaDB to secure it, we'll need the current

password for theroot user. If you've just installed MariaDB, and

you haven't set theroot password yet, the password will be blank,

so you should justpress enter here.

Enter currentpassword for root (enter for none):

ERROR 1045 (28000):Access denied for user 'root'@'localhost' (using password: YES)

Enter currentpassword for root (enter for none):

ERROR 1045 (28000):Access denied for user 'root'@'localhost' (using password: YES)

//初始化直接enter就好了

Enter currentpassword for root (enter for none):

OK, successfullyused password, moving on...

Setting the rootpassword ensures that nobody can log into the MariaDB

root user withoutthe proper authorisation.

Set root password?[Y/n] y

New password:

Re-enter newpassword:

Password updatedsuccessfully!

Reloading privilegetables..

... Success!

By default, aMariaDB installation has an anonymous user, allowing anyone

to log into MariaDBwithout having to have a user account created for

them. This isintended only for testing, and to make the installation

go a bit smoother. You should remove them before moving into a

productionenvironment.

Remove anonymoususers? [Y/n] y

... Success!

Normally, rootshould only be allowed to connect from 'localhost'. This

ensures that someonecannot guess at the root password from the network.

Disallow root loginremotely? [Y/n] y

... Success!

By default, MariaDBcomes with a database named 'test' that anyone can

access. This isalso intended only for testing, and should be removed

before moving into aproduction environment.

Remove test databaseand access to it? [Y/n] n

... skipping.

Reloading theprivilege tables will ensure that all changes made so far

will take effectimmediately.

Reload privilegetables now? [Y/n] y

... Success!

Cleaning up...

All done! If you'vecompleted all of the above steps, your MariaDB

installation shouldnow be secure.

Thanks for usingMariaDB!

[root@localhost ~]#




[root@localhost ~]#service mysqld restart

Shutting downMySQL.. SUCCESS!

Starting MySQL.SUCCESS!



[root@localhost~]# mysql -u root -p

Enter password:

Welcome to theMariaDB monitor. Commands end with ; or \g.

Your MariaDBconnection id is 5

Server version:10.0.19-MariaDB-log Source distribution

Copyright (c) 2000,2015, Oracle, MariaDB Corporation Ab and others.

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

MariaDB [(none)]>show tables

-> ;

ERROR 1046 (3D000):No database selected

MariaDB [(none)]>show databases;

+--------------------+

| Database |

+--------------------+

| information_schema|

| mysql |

| performance_schema|

| test |

+--------------------+

4 rows in set (0.04sec)

MariaDB [(none)]> //创建个测试库连接下

MariaDB [(none)]>create database r_test;

Query OK, 1 rowaffected (0.01 sec)

MariaDB [(none)]>grant all privileges on r_test.* to 'r_test'@'localhost' identifiedby 'r_test';

Query OK, 0 rowsaffected (0.00 sec)

MariaDB [(none)]>grant all privileges on r_test.* to 'r_test'@'%' identified by'r_test';

Query OK, 0 rowsaffected (0.00 sec)



navicat连接下




安装方式拜读参考:

http://www.linuxidc.com/Linux/2014-11/109049.htm