mariadb linux二进制tar包安装

地址为：https://downloads.mariadb.org/

释放安装包  /usr/local/mariadb 

tar -xvzf mariadb-5.5.66-linux-x86_64.tar.gz

mv mariadb-5.5.66-linux-x86_64 /usr/local/mariadb/

cd /usr/local/mariadb

 

备份原有mysql配置： mv /etc/my.cnf /etc/my.cnf.bak

复制配置文件： cp support-files/my-huge.cnf /etc/my.cnf

basedir = /usr/local/mariadb

skip_name_resolve = ON  

innodb_file_per_table = ON

 

创建用户组：groupadd mysql

增加 mysql 用户 并归于mysql 属组：useradd -g mysql mysql

 

进入mysql目录更改权限 ：

/home 

chown mysql mysql

chgrp mysql mysql

 

/usr/local/mariadb

初始化安装：scripts/mysql_install_db --user=mysql

 

  /etc/profile

全局配置 

MYSQL_HOME=/usr/local/mariadb
export MYSQL_HOME
export PATH=/usr/local/mariadb/bin:$PATH

刷新source /etc/profile

 

 

/usr/local/mariadb

启动服务 ./mysql.server start

 

 

忘记密码，重新设置

vim /etc/my.cnf

在[mysqld]里添加, 用来跳过密码验证的过程 ： skip-grant-tables

保存 退出

# mysql
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 2
Server version: 5.5.66-MariaDB MariaDB Server

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

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

MariaDB [(none)]> use mysql;
Database changed
MariaDB [mysql]> update user set password=password("new-password") where user="root";
Query OK, 4 rows affected (0.00 sec)
Rows matched: 4  Changed: 4  Warnings: 0

MariaDB [mysql]> flush privileges;
Query OK, 0 rows affected (0.00 sec)

MariaDB [mysql]> quit

重新启动 MariaDB

远程连接linux中的mysql报错1130解决办法

登录mysql
MariaDB [(none)]> use mysql;
Database changed
MariaDB [mysql]> update user set host='%' where host='localhost' and user='root';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

MariaDB [mysql]> flush privileges;
Query OK, 0 rows affected (0.00 sec)

MariaDB [mysql]> exit

重新启动 MariaDB

设置开机自启

如 /etc/init.d/mysql 无 mysql 文件 则

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

# chkconfig --add mysql

 

# chkconfig --list

查看服务列表（若 3 4 5 为 off，则执行：chkconfig --level 345 mysql on）