1. brew info mariadb
mariadb: stable 10.6.4 (bottled)
Drop-in replacement for MySQL
https://mariadb.org/
Conflicts with:
mariadb-connector-c (because both install `mariadb_config`)
mysql (because mariadb, mysql, and percona install the same binaries)
mytop (because both install `mytop` binaries)
percona-server (because mariadb, mysql, and percona install the same binaries)
Not installed
From: https://mirrors.ustc.edu.cn/homebrew-core.git/Formula/mariadb.rb
License: GPL-2.0-only
2.brew doctor
3.brew cleanup
4.brew install mariadb
5.设置root密码
安装成功后root无法登陆,这时候
苹果->系统偏好设置->MySQL,关闭mysql服务
输入(cd /usr/local/mysql/bin/)回车
输入(sudo su)回车以获取管理员权限
输入(./mysqld_safe --skip-grant-tables &)回车以禁止mysql验证功能,mysql会自动重启
新建一个终端窗口(cmd+T),
输入命令(./mysql)回车
输入命令(flush privileges;)分号别忘记输了
输入命令(set password for 'root'@'localhost' = password('root');) password('root')中的root为新密码,自己随便设置,分号别忘记输入
至此,密码修改成功,可以正常登入了。
6.允许远程登录
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;
其中"*.*"代表所有资源所有权限, “'root'@%”其中root代表账户名,%代表所有的访问地址,也可以使用一个唯一的地址进行替换,只有一个地址能够访问。如果是某个网段的可以使用地址与%结合的方式,如10.0.42.%。IDENTIFIED BY 'root',这个root是指访问密码。WITH GRANT OPTION允许级联授权。
flush privileges;
查询mysql的user表就可以看到除了loclhost之外的其他地址登录了
MariaDB [mysql]> select host,user,plugin,authentication_string from user;
+-----------+---------------+-----------------------+-------------------------------------------+
| host | user | plugin | authentication_string |
+-----------+---------------+-----------------------+-------------------------------------------+
| localhost | root | mysql_native_password | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B |
| localhost | mysql.session | mysql_native_password | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE |
| localhost | mysql.sys | mysql_native_password | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE |
| % | root | mysql_native_password | NULL |
+-----------+---------------+-----------------------+-------------------------------------------+