mysql.user empty

1 개요[ | ]

mysql.user empty

MySQL

Copy

FLUSH PRIVILEGES;
CREATE USER root@localhost IDENTIFIED BY '패스워드';
GRANT ALL PRIVILEGES ON *.* TO root@localhost;
UPDATE mysql.user SET Grant_priv='Y', Super_priv='Y' WHERE User='root';
FLUSH PRIVILEGES;

Console

Copy

MariaDB [(none)]> SELECT Host,User FROM mysql.user;
Empty set (0.00 sec)

MariaDB [(none)]> CREATE USER root@localhost IDENTIFIED BY '패스워드';
ERROR 1290 (HY000): The MariaDB server is running with the --skip-grant-tables option so it cannot execute this statement
MariaDB [(none)]> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)

MariaDB [(none)]> CREATE USER root@localhost IDENTIFIED BY '패스워드';
Query OK, 0 rows affected (0.00 sec)

MariaDB [(none)]> GRANT ALL PRIVILEGES ON *.* TO root@localhost;
Query OK, 0 rows affected (0.00 sec)

MariaDB [(none)]> UPDATE mysql.user SET Grant_priv='Y', Super_priv='Y' WHERE User='root';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

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

MariaDB [(none)]> SELECT Host,User,Grant_priv,Super_priv FROM mysql.user;
+-----------+------+------------+------------+
| Host      | User | Grant_priv | Super_priv |
+-----------+------+------------+------------+
| localhost | root | Y          | Y          |
+-----------+------+------------+------------+
1 row in set (0.00 sec)

MariaDB [(none)]> exit
Bye

2 같이 보기[ | ]