MariaDB 10.6.4でユーザーに権限を付与する方法

環境
MariaDB 10.6.4
Windows 10 Home 64bit

操作方法
1.ユーザーを作成します

MariaDB [(none)]> CREATE USER 'cftuser88'@'%' IDENTIFIED BY 'cftpassword';
Query OK, 0 rows affected (0.381 sec)

2.ユーザーの権限を付与します

MariaDB [(none)]> GRANT ALL PRIVILEGES ON *.* TO 'cftuser88'@'%' WITH GRANT OPTION;
Query OK, 0 rows affected (0.090 sec)

3.権限を更新します

MariaDB [(none)]> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.212 sec)

 

MariaDB

Posted by arkgame