mysql数据库设置与修改密码:update mysql.user set password=password('密码') where user='root'
如果报错: ERROR 1054 (42S22): Unknown column 'password' in 'field
解决:update mysql.user set authentication_string=password('root') where user='root' ;
update mysql.user set authentication_string=password('root') where user='root' ;
刷新特权:flush privileges;
flush privileges;