Create User
MariaDB [(None)]> CREATE USER ' DBAdmin ' @ '% ' identified by ' mypasswd ';
Query OK, 0 rows Affected (0.00 sec)
MariaDB [(None)]> CREATE USER ' tdtc2014 ' @ ' localhost ' identified by ' QAZXSW ';
Query OK, 0 rows Affected (0.00 sec)
MariaDB [(None)]> GRANT all privileges on * * to ' DBAdmin ' @ '% ' with GRANT OPTION;
Query OK, 0 rows Affected (0.00 sec)
MariaDB [(None)]> GRANT select,insert,update,delete on carnumber.* to ' tdtc2014 ' @ ' localhost ';
Query OK, 0 rows Affected (0.00 sec)
MariaDB [(none)]> show grants for ' DBAdmin ';
+-------------------------------------------------------------------------------------------------------------- ---------------------+
| Grants for [email protected]% |
+-------------------------------------------------------------------------------------------------------------- ---------------------+
| GRANT all privileges on * * to ' DBAdmin ' @ '% ' identified by PASSWORD ' *8640888bfb179c50ef0b4de12251e66b4fb18a77 ' with GRANT OPTION |
+-------------------------------------------------------------------------------------------------------------- ---------------------+
1 row in Set (0.00 sec)
MariaDB [(none)]> \q
Bye
Create User-mysql