2019-08-08 Ubuntu 16.04 安装新版Mari

之前参加仓库方法按照官方给出的方法

https://downloads.mariadb.org/mariadb/repositories/#mirror=tuna&distro=Ubuntu&distro_release=xenial--ubuntu_xenial&version=10.4

1. 更新本地的仓库:

sudo apt-get update

2. ubuntu16.04下安装

apt-get install mariadb-server

3. MariaDB root 账户默认使用了 UNIX_SOCKET 插件，只允许 root 用户连接，无需密码。

mysql -uroot -p

4. 进入mysql，设置root密码，并刷新权限表

SET PASSWORD FOR 'root'@'localhost' = PASSWORD('newpass');

FLUSH PRIVILEGES;

5. 添加远程用户访问权限，root为用户名称，%代表所有用户均可访问，可指定IP，如'192.168.11.1',mypassword为密码

GRANT ALL PRIVILEGES ON *.* TO root@'%' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;

FLUSH PRIVILEGES;

6. 如远程无法访问，需要修改配置文件server.cnf，位置如下图，

pxl@pxl-virtual-machine:/etc/mysql/mariadb.conf.d$ ll

总用量 24

drwxr-xr-x 2 root root 4096 2月  9 09:30 ./

drwxr-xr-x 4 root root 4096 2月  9 08:42 ../

-rw-r--r-- 1 root root  495 1月  17 00:46 50-client.cnf

-rw-r--r-- 1 root root  336 1月  17 00:46 50-mysql-clients.cnf

-rw-r--r-- 1 root root  321 1月  17 00:46 50-mysqld_safe.cnf

-rw-r--r-- 1 root root 3494 2月  9 09:30 50-server.cnf

将下图的skip-external-locking和bind-address注释

[mysqld]

# * Basic Settings

user            = mysql

pid-file        = /var/run/mysqld/mysqld.pid

socket          = /var/run/mysqld/mysqld.sock

port            = 3306

basedir        = /usr

datadir        = /var/lib/mysql

tmpdir          = /tmp

lc-messages-dir = /usr/share/mysql

#skip-external-locking

# Instead of skip-networking the default is now to listen only on

# localhost which is more compatible and is not less secure.

#bind-address          = 127.0.0.1

重启mariadb

service mysql restart