ÃֽŠ°Ô½Ã±Û(DB)
2016.11.03 / 10:17
[MySQL] ERROR 1044 (42000): Access denied for user 'user'@'localhost' to database 'userdb' ¿¡·¯
±â¸®¾Æºü
Ãßõ ¼ö 408
1. ¿¡·¯ ¹ß»ý »óȲ
(1) use·Î Database º¯°æÇÏ¿´À»¶§.
mysql> use kdhong_db
[MySql] ERROR 1044 (42000): Access denied for user 'user'@'localhost' to database 'userdb'
(2) MySQLÀÇ ROOT°èÁ¤(°ü¸®ÀÚ°èÁ¤)À¸·Î ¾ÆÀ̵ð »ý¼º ÈÄ ·Î±×ÀÎ ÇÏ¿´À»¶§.
mysql> mysql -ulucky -p1234 lucky_db
[MySql] ERROR 1044 (42000): Access denied for user 'lucky'@'localhost' to database 'lucky_db'
¡Ø·Î±×ÀÎ ÇÏ´Â ¹æ¹ý :> mysql -u¾ÆÀ̵ð -pºñ¹Ð¹øÈ£ µ¥ÀÌÅͺ£À̽º¸í
2. ÇØ°á¹æ¹ý
$ mysql -uroot -p1234
mysql> grant all privileges on userdb.* to 'lucky'@'localhost' identified by 'Æнº¿öµå' with grant option;
Query OK, 0 rows affected (0.16 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.11 sec)