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;
                
            
        
浙公网安备 33010602011771号