mysql install -issues

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

#init mysql_db
mysql_install_db
#safe mode
mysqld_safe --user=mysql --skip-grant-tables --skip-networking &
#client management
mysql -u root mysql

#select

select * from user ;

#it's empty
#add user
INSERT INTO user(host, user, password, select_priv, insert_priv, update_priv) VALUES ('localhost', 'root', PASSWORD('123456'),'Y', 'Y','Y');
#update user_info
UPDATE user SET Password = PASSWORD('newpass') WHERE user = 'root';    

FLUSH PRIVILEGES;

posted @ 2015-03-23 12:26  山顶的鱼  阅读(73)  评论(0)    收藏  举报