为什么在MariaDB中新建用户提示错误代码1227

Question

新安装的MariaDB，想要创建一个新用户，错误代码提示1227，好像是没有权限还是什么？
请问有没有办法解决？

Last login: Sun Apr 26 21:53:23 on ttys000

The default interactive shell is now zsh.
To update your account to use zsh, please run `chsh -s /bin/zsh`.
For more details, please visit https://support.apple.com/kb/HT208050.
rimasarus-MacBook-Pro:~ $    /usr/local/mariadb/server/bin/mariadb
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 15
Server version: 10.1.44-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)]> CREATE USER 'student'@'localhost' IDENTIFIED BY '1234';
ERROR 1227 (42000): Access denied; you need (at least one of) the CREATE USER privilege(s) for this operation
MariaDB [(none)]> 

Answer 1

你现在没权限。解决办法如下：
linux下用mysql_secure_installation命令初始化root，并设置密码。
然后在用root登录，设置用户。