• mysql5.7 测试环境配置部署


    数据库版本:Mysql 5.7.32 

    数据库部署步骤如下:

    [root@localhost software]# pwd

    /data/software 

    [root@localhost software]# ll

    total 28

    -rw-r--r--. 1 root root 25548 Apr  7  2017 mysql57-community-release-el7-10.noarch.rpm

    wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm 

    yum -y install mysql57-community-release-el7-10.noarch.rpm 

    yum -y install mysql-community-server 

    如上Mysql安装完毕,接下来根据需要进行一些配置。

    先启动Mysql:

    systemctl start mysqld.service

    查看mysql状态即是否启动:

    systemctl status mysqld.service

    查看mysql5.7默认root密码:

    grep "password" /var/log/mysqld.log

    使用默认mysql root登陆后修改密码:

    mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'jxlJXL@123';

    修改mysql5.7密码策略:暂略  注意:修改完密码策略后,需要重启mysql服务生效!

    在防火墙开启有关端口,比如3306,看具体情况!配置防火墙需要重启防火墙服务才能生效!

    修改Mysql字符编码(不修改会产生乱码):

    mysql> show variables like '%character%';

    +--------------------------+----------------------------+

    | Variable_name            | Value                      |

    +--------------------------+----------------------------+

    | character_set_client     | utf8                       |

    | character_set_connection | utf8                       |

    | character_set_database   | latin1                     |

    | character_set_filesystem | binary                     |

    | character_set_results    | utf8                       |

    | character_set_server     | latin1                     |

    | character_set_system     | utf8                       |

    | character_sets_dir       | /usr/share/mysql/charsets/ |

    +--------------------------+----------------------------+

    8 rows in set (0.00 sec)

    more /etc/my.cnf

    重启mysql数据库使配置生效:

    systemctl restart mysqld.service

    再次查看Mysql字符集:

    mysql> show variables like '%character%';

    +--------------------------+----------------------------+

    | Variable_name            | Value                      |

    +--------------------------+----------------------------+

    | character_set_client     | utf8                       |

    | character_set_connection | utf8                       |

    | character_set_database   | utf8                       |

    | character_set_filesystem | binary                     |

    | character_set_results    | utf8                       |

    | character_set_server     | utf8                       |

    | character_set_system     | utf8                       |

    | character_sets_dir       | /usr/share/mysql/charsets/ |

    +--------------------------+----------------------------+

    8 rows in set (0.01 sec)

    如上所示修改字符集成功! 

    至此,mysql数据库部署成功。

  • 相关阅读:
    WP8.1通过StreamSocket连接C++服务器
    WP10通过StreamSocket连接C++服务器
    二维背包(两个限制条件)
    dp(多重背包)
    dp(完全背包)
    dfs(迷宫)
    bfs迷宫
    蚁人cp数
    二分(老死不相往来)
    前缀和(狼和野牛)
  • 原文地址:https://www.cnblogs.com/renyongbin/p/14281936.html
Copyright © 2020-2023  润新知