ALTER USER 'root'@'localhost' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER#修改加密规则
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password'#更新一下用户的密码
FLUSH PRIVILEGES#刷新权限
mysqladmin -h hostname flush-privilegesuse mysqlupdate user set password =password('yourpass') where user='root'
出现无法连接数据库的话,命令行用root用户登陆,敲下面命令:
SET PASSWORD FOR sns@'localhost'=OLD_PASSWORD('sns')
然后刷新mysql权限
FLUSH PRIVILEGES
导入数据的方法 mysql -u name -p --default-character-set=utf8 databasename <path\*.sql
create database name character set utf8
如果出现#1251 - Client does not support authentication protocol requested by server的错误:
解决办法:先用root登录MYSQL服务器,执行
mysql>set password for user1@"localhost"=old_password('yourPassword')
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)