我解压在www.yabovip4.com

下载解压不说

 

www.yabovip4.com 1

高级中学档修改密码的时候,用的是:alter user ‘root’@’localhost’ identified by
‘root’;

可是当作者use mysql切换数据的时候,又提示小编修改密码?

  配置mysql的bin为情状变量

运维MySQL服务,MySQL服务能够成功运行,能够用root用户登入的时候提示供给输入密码,此时还尚未安装root密码

 

www.yabovip4.com 2

通过update user set authentication_string=password(‘root’) where user
=’root’的法子修改密码,提醒成功

可是重启中又让修改密码,用的是:alter user ‘root’@’localhost’ identified
by ‘root’;那样就成功了root密码的改造。

报到之后修改密码,利用alter user root identitied by ‘root’的艺术修改

下一场参谋网络,用:update user set
authentication_string=PASSWORD(‘root’) where User=’root’;能够修改成功

 

 

http://www.cnblogs.com/Alex-Zeng/p/5508766.html

然后开始展览劳动登记:E:\DBFiles\mysql-5.7.15-winx64\mysql-5.7.15-winx64\bin>mysqld
install MySQL
–defaults-file=”E:\DBFiles\mysql-5.7.15-winx64\mysql-5.7.15-winx64\my.ini”

我解压在www.yabovip4.com。然后用HeidiSQL处理工具能够符合规律连接:

那下终于好了

提示:The MySQL server is running with the –skip-grant-tables option so
it cannot execute this statement

从前都以下一步下一步的办法安装的,这一次通过uninstall的点子安装mysql,由于是累累测量检验,中间蒙受了相当多标题,折腾可叁遍才成功。

我解压在www.yabovip4.com。自身解压在:E:\DBFiles\mysql-5.7.15-winx64\mysql-5.7.15-winx64

我解压在www.yabovip4.com。   

提示:The MySQL server is running with the –skip-grant-tables option so
it cannot execute this statement

 

 

 

下一场小编有试行:alter user ‘root’@’localhost’ identified by ‘root’;

 

修改密码然后,remove掉上边配置的skip-grant-tables=1,用root用户和刚刚设置的密码root登陆,没问题,

 

在zip包中曾经不含data目录,供给初阶化一下:mysqld –initialize

加多布署文件E:\DBFiles\mysql-5.7.15-winx64\mysql-5.7.15-winx64\my.ini 

下一场参谋网络,用:update user set
authentication_string=PASSWO中华VD(‘root’) where User=’root’;可以修改成功

www.yabovip4.com 3

www.yabovip4.com 4

升迁安装成功

 

####################配置文件开始###################

 [client]
 default-character-set=utf8



 [mysqld]
 port=3306
 basedir  ="E:\DBFiles\mysql-5.7.15-winx64\mysql-5.7.15-winx64"
 datadir  ="E:\DBFiles\mysql-5.7.15-winx64\mysql-5.7.15-winx64/data/"
 tmpdir   ="E:\DBFiles\mysql-5.7.15-winx64\mysql-5.7.15-winx64/data/"
 socket   ="E:\DBFiles\mysql-5.7.15-winx64\mysql-5.7.15-winx64/data/mysql.sock"
 log-error="E:\DBFiles\mysql-5.7.15-winx64\mysql-5.7.15-winx64/data/mysql_error.log"
 #skip-grant-tables=1
 #server_id = 2
 #skip-locking


 max_connections=100
 table_open_cache=256
 query_cache_size=1M
 tmp_table_size=32M
 thread_cache_size=8
 innodb_data_home_dir="E:\DBFiles\mysql-5.7.15-winx64\mysql-5.7.15-winx64/data/"
 innodb_flush_log_at_trx_commit =1
 innodb_log_buffer_size=128M
 innodb_buffer_pool_size=128M
 innodb_log_file_size=10M
 innodb_thread_concurrency=16
 innodb-autoextend-increment=1000
 join_buffer_size = 128M
 sort_buffer_size = 32M
 read_rnd_buffer_size = 32M
 max_allowed_packet = 32M
 explicit_defaults_for_timestamp=true
 sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
 #sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

####################配置文件结束###################

www.yabovip4.com 5

参考:

 

甘休服务,在my.ini中加二个skip-grant-tables=1的陈设,允许跳过密码,修改过后重启MySQL服务,root用户能够健康登入

 www.yabovip4.com 6

www.yabovip4.com 7

www.yabovip4.com 8

发表评论

电子邮件地址不会被公开。 必填项已用*标注