[root@ns1 /root]# mysql mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MySQL monitor. Commands end with ; or \.
Your MySQL connection id is 90 to server version: 3.22.22
Type 'help' for help.
mysql> insert into db
-> values('%','artaction','artaction','y','y','y','y','y','y','y','y','y','y');
Query OK, 1 row affected (0.00 sec)
mysql> insert into user values('%','artaction',password('at2332!'),'n','n','n','n','n','n','n','n','n','n','n','n','n','n')
-> ;
Query OK, 1 row affected (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql> exit
mysqladmin reload 한다음에
root 계정에서..
mysqlshow artaction -u artaction -p artaction
이렇게 하면
mysqlshow: Access denied for user: 'artaction@localhost' (Using password: YES)
물론 artaction 계정 하고 db도 만들었찌요
왜 이런 에러가 나는걸까요?
잘못된것도 없는것 같은데..
지금 하루동안 수없이 지우고 다시해도 안됩니다..
제발 고수님들의 조언이 필요합니다..
꼭좀 답좀 주세요..
|