티스토리 뷰

728x90

출처 http://ask.nate.com/qna/view.html?n=4636134

MySQL 4.1.21 설치후 접속 오류 해결

해당오류
- ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
- ERROR 2003 <HY000>:Can't connect to Mysql server on 'localhost'<10061>
- mysqladmin: connect to server at 'localhost' failed
- error: 'Can't connect to MySQL server on 'localhost' (10061)'

Enter password: ******
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 4 to server version: 4.1.21-community-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> use mysql;
Database changed
mysql> update user set password=password('sqldba') where user='root';
Query OK, 0 rows affected (0.00 sec)
Rows matched: 2  Changed: 0  Warnings: 0

mysql> delete from user where user='';
Query OK, 0 rows affected (0.00 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

mysql>

댓글
300x250
공지사항
최근에 올라온 글
최근에 달린 댓글
Total
Today
Yesterday
«   2024/03   »
1 2
3 4 5 6 7 8 9
10 11 12 13 14 15 16
17 18 19 20 21 22 23
24 25 26 27 28 29 30
31
글 보관함