mysql.user empty

Jmnote (토론 | 기여)님의 2017년 9월 26일 (화) 00:35 판 (→‎개요)
(차이) ← 이전 판 | 최신판 (차이) | 다음 판 → (차이)

1 개요[ | ]

mysql.user empty
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;
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 같이 보기[ | ]

문서 댓글 ({{ doc_comments.length }})
{{ comment.name }} {{ comment.created | snstime }}