1、下载MariaDB 10.2.6稳定版(免费),选择版本时选择MAC .pkg版本:
https://downloads.mariadb.org/mariadb/10.2.6/
2、官网安装说明:
https://mariadb.com/kb/en/mariadb/installing-mariadb-server-pkg-packages-on-macos/
3、安装完后,默认的用户名是root,密码为空,但是用远程工具(譬如Navicat)远程连接时不能用root用户连接,必须新建用户;
4.基于第三点,首先我们打开MAC终端,输入sudo /usr/local/mariadb/server/bin/mariadb,然后会提示输入管理员密码,接着直接连接上MariaDB,连接上数据库后,需要更改root密码和新建用户,因为远程工具不能用root用户登录
sudo /usr/local/mariadb/server/bin/mariadb
5.创建新用户:CREATE USER 'username'@'host' IDENTIFIED BY 'password'; 如果想让该用户可以从任意远程主机登陆,host可以使用通配符%;
CREATE USER 'zhangsan'@'%' IDENTIFIED BY '123456';
6.新用户授权:
GRANT ALL ON *.* TO 'zhangsan'@'%';
7.修改root用户的密码:
SET password for 'root'@'localhost'=password('123456');
8.默认情况下MariaDB是自启动:
启动MariaDB:
sudo launchctl start com.mariadb.server
关闭DB:
sudo launchctl stop com.mariadb.server
9.自己常用:
sudo /usr/local/mariadb/server/bin/mariadb
SET password for 'root'@'localhost'=password('123456');