mysql-8.0.11-winx64环境搭建

曾经终败给现在 2022-05-26 09:48 114阅读 0赞

1.       搜索mysql

![70][]

2.       下载，点击[https://www.mysql.com/downloads/][https_www.mysql.com_downloads]

![70 1][]

![70 2][]

![70 3][]

3.       解压后进入bin目录D:\\program\\mysql-8.0.11-winx64\\bin

4.       配置 my.imi文件，D:\\program\\mysql-8.0.11-winx64

[mysqld]
    # 设置3306端口
    port=3306
    # 设置mysql的安装目录
    basedir=D:\\program\\mysql-8.0.11-winx64
    # 设置mysql数据库的数据的存放目录
    datadir=D:\\program\\mysql-8.0.11-winx64\\Data
    # 允许最大连接数
    max_connections=200
    # 允许连接失败的次数。这是为了防止有人从该主机试图攻击数据库系统
    max_connect_errors=10
    # 服务端使用的字符集默认为UTF8
    character-set-server=utf8
    # 创建新表时将使用的默认存储引擎
    default-storage-engine=INNODB
    # 默认使用“mysql_native_password”插件认证
    default_authentication_plugin=mysql_native_password
    [mysql]
    # 设置mysql客户端默认字符集
    default-character-set=utf8
    [client]
    # 设置mysql客户端连接服务端时默认使用的端口
    port=3306
    default-character-set=utf8

5.       初始化数据库生成Data目录和默认密码

**mysqld --initialize --console**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70][]

6.       添加服务

mysqld -install

![70 4][]

如果用非管理员执行命令会提示：Install/Remove of the Service Denied

删除服务：mysqld -remove

7.       启动mysql

**net start mysql**

![20190402162644367.png][]

停止net stop mysql

8.       登录数据库并修改密码

mysql -u root -p

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 1][]  
修改root 密码  
set password = '新密码';

![2019040216283360.png][]

如果Navicat连接不上，使用mysql_native_password加密规则更新密码
    ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456'; 
    FLUSH PRIVILEGES; #刷新权限

9. 如果是mysql升级

ERROR 1449 (HY000): The user specified as a definer ('mysql.infoschema'@'localhost') does not exist

需要mysql\_upgrade -u root -p

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 2][]

问题：The server time zone value 'ÖÐ¹ú±ê×¼Ê±¼ä' is unrecognized or represents more than one time zone....

show variables like '%time_zone%';
    set global time_zone='+8:00';

Caused by: com.mysql.cj.exceptions.CJException: null,  message from server: "Host '192.168.1.102' is not allowed to connect to this MySQL server"

mysql -u root -p
    mysql>use mysql;
    mysql>update user set host = '%' where user = 'root';
    mysql>flush privileges;
    重启mysql

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 3][]

[70]: /images/20220526/f74a14b8eb014a11b1ab4c375d833b83.png
[https_www.mysql.com_downloads]: https://www.mysql.com/downloads/
[70 1]: /images/20220526/55da735709514d479882feccd37bd90c.png
[70 2]: /images/20220526/51a709713ed7471582476f3a89da47ba.png
[70 3]: /images/20220526/7af3c1ac8cf44e07b8b74457981e3080.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70]: /images/20220526/ff1f7bb50c674a8fa44c698cb676b7c6.png
[70 4]: /images/20220526/de684b9f4d70441f8a4a2f5102ad1d44.png
[20190402162644367.png]: /images/20220526/a9e5fa5e69c74852a76bc8bce365830e.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 1]: /images/20220526/955e3a90b9bc4ca5a0da56a2f79908c8.png
[2019040216283360.png]: /images/20220526/4a411d77b64f4fe1ae3353188b527fdc.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 2]: /images/20220526/caa68a5075574725be1da9ea7aff72ec.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 3]: /images/20220526/c10f729245d0449b888be5287a29cd3b.png