为mysql添加用户和修改密码

>GRANTE ALL PRIVILEGES ON  *.*   TO  identified by '123456' with grante option   添加Tube用户。

>flush privileges  刷新授权表

>drop user '  删除Tube用户

修改Tube用户密码

>grant usage on *.* to  identified by '654321'

>flush privileges  刷新授权表

root密码忘记解决之道。

#service mysqld stop

#mysql -u root | use mysql;

>update user set password=password('new-password') where user='root';

#service mysqld start