ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) 참고자료2!

출처 : https://www.linux.co.kr/home2/board/subbs/board.php?bo_table=database&wr_id=3460&page=4

리눅스포털

www.linux.co.kr

 

Q) [mysql] 실행이 안됩니다.

 글쓴이 : 김성훈

 

# ./mysqld_safe &
# 090621 03:01:19 mysqld_safe Logging to '/usr/local/mysql/data/error.err'.
090621 03:01:20 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data
090621 03:01:20 mysqld_safe mysqld from pid file /usr/local/mysql/data/error.pid ended

[1]+  Done                    ./mysqld_safe

# ps -ef|grep mysql
root     15776 15637  0 03:05 pts/1    00:00:00 grep mysql

# cat /usr/local/mysql/data/error.err
090621 03:01:20 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data
/usr/local/mysql/libexec/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
090621  3:01:20 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
090621  3:01:20 [ERROR] /usr/local/mysql/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
090621  3:01:20 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: './mysql/host.frm' (errno: 13)
090621 03:01:20 mysqld_safe mysqld from pid file /usr/local/mysql/data/error.pid ended

답변 감사합니다.

좋은 하루 되세요.

 

A)

정창호 09-06-30 16:12

 

mysql 을 설치하시고 관련 DB 가 생성이 안된상태 같습니다. mysql_install_db 는 실행했나요? 실행하고 난후에도 mysql 권한으로 되어있는지 확인도 해보시길 바랍니다.