mysqlのユーザーを作成する要領
mysqlにログイン
pi@raspberrypi:~ $ mysql -u root -p
Enter password:
ユーザー作成
MariaDB [(none)]> create user testuser1;
パスワード設定
MariaDB [(none)]> set password for 'testuser1'=password('testpass');
設定確認
MariaDB [(none)]> select user ,host,password from mysql.user;
+-----------+-----------+-------------------------------------------+
| user | host | password |
+-----------+-----------+-------------------------------------------+
| root | localhost | *E924FF075410F41BBD416C9E4810A850CAE5FD55 |
| testuser1 | % | *00E247AC5F9AF26AE0194B41E1E769DEE1429A29 |
+-----------+-----------+-------------------------------------------+
2 rows in set (0.002 sec)
