Mac上用Brew安装mariadb命令及root密码问题解决

2023年4月7日技巧分享评论73,939字数 2883阅读9分36秒阅读模式

Ethan_2023-04-07_17-38-23

最近需要用到MariaDB,习惯性用brew安装了,一行命令搞定:

brew install mariadb

然后设置自动启动mariadb,也是一行命令:

brew services start mariadb

官方文档:Installing MariaDB Server on macOS Using Homebrew

打印下已启动的服务列表:brew services list,可以看到mariadb已经启动了:

Ethan_2023-04-07_17-17-40

以上,就算完成了mariadb的安装及启动。

可以输入mariadb -v来查看版本信息。

Ethan_2023-04-07_16-23-47

这个时候会默认进入mariadb命令,可以输入下面命令来查看端口号和状态(加分号后按回车才会执行语句)

查看端口号:

show global variables like 'port';

查看状态:

status;

密码问题解决

当我输入mariadb-secure-installation初始化时,上来就找我要密码,我直接按enter是不管用的,可是去网上搜了下,说的都是root用户,默认没有密码,我就有点无语了。

最后还是找到了这一条命令解决的:

MariaDB [(none)]> ALTER USER root@localhost IDENTIFIED VIA mysql_native_password USING PASSWORD("你的密码");

首先需要输入mariadb,进入mariadb命令行模式,然后再输入上面的命令就可以修改root用户的密码了。

完整的过程可以下面的代码:

os@osdeMacBook-Pro mariadb@10.11 % mariadb
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 29
Server version: 10.11.2-MariaDB Homebrew

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)]> ALTER USER root@localhost IDENTIFIED VIA mysql_native_password USING PASSWORD("123456");
Query OK, 0 rows affected (0.014 sec)

MariaDB [(none)]> Ctrl-C -- exit!
Aborted
os@osdeMacBook-Pro mariadb@10.11 % mariadb-secure-installation

NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MariaDB
      SERVERS IN PRODUCTION USE!  PLEASE READ EACH STEP CAREFULLY!

In order to log into MariaDB to secure it, we'll need the current
password for the root user. If you've just installed MariaDB, and
haven't set the root password yet, you should just press enter here.

Enter current password for root (enter for none): 
OK, successfully used password, moving on...

Setting the root password or using the unix_socket ensures that nobody
can log into the MariaDB root user without the proper authorisation.

You already have your root account protected, so you can safely answer 'n'.

Switch to unix_socket authentication [Y/n] n
 ... skipping.

You already have your root account protected, so you can safely answer 'n'.

Change the root password? [Y/n] n
 ... skipping.

By default, a MariaDB installation has an anonymous user, allowing anyone
to log into MariaDB without having to have a user account created for
them.  This is intended only for testing, and to make the installation
go a bit smoother.  You should remove them before moving into a
production environment.

Remove anonymous users? [Y/n] y
 ... Success!

Normally, root should only be allowed to connect from 'localhost'.  This
ensures that someone cannot guess at the root password from the network.

Disallow root login remotely? [Y/n] y
 ... Success!

By default, MariaDB comes with a database named 'test' that anyone can
access.  This is also intended only for testing, and should be removed
before moving into a production environment.

Remove test database and access to it? [Y/n] y
 - Dropping test database...
 ... Success!
 - Removing privileges on test database...
 ... Success!

Reloading the privilege tables will ensure that all changes made so far
will take effect immediately.

Reload privilege tables now? [Y/n] y
 ... Success!

Cleaning up...

All done!  If you've completed all of the above steps, your MariaDB
installation should now be secure.

Thanks for using MariaDB!

现在再去连接本地的mariadb就可以成功了:

Ethan_2023-04-07_17-29-17

Mac 配置指南,必备的新手设置及软件 电脑软件

Mac 配置指南,必备的新手设置及软件

虽然起了一个大众的标题,但是这个笔记还是主要为了记录我这次重新装机后的一些配置习惯以及会优先安装的软件,主要为了自用,也给大家做一个参考。 推荐的软件我都会尽量提供官方的下载地址,大家别在百度上随便搜...
MAC上的最好用的5个SSH客户端工具推荐 电脑软件

MAC上的最好用的5个SSH客户端工具推荐

SSH 或 Secure Shell 是一种网络协议,允许您通过加密连接远程访问另一台计算机。 您使用 SSH 在一台计算机上打开文件并运行程序,同时使用另一台计算机。 SSH 内置于大多数现代计算机...
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定