Linux安装配置Mysql，并进入生产环境

[lvleihere]

啧啧啧centos6.5、7.5都玩过

介绍下还算靠谱的centos7.5的安装方法

• 清理工作
  用rpm -qa | grep mysql查看当前有哪些mysql包
  rpm -e --nodeps + 包名 进行卸载
  清除mysql-server yum remove mysql-server

• 安装Mysql5.7

  • 下载源
    $: wget http://dev.mysql.com/get/mysql57-community-release-el7-7.noarch.rpm
  • 安装源
    $: yum localinstall mysql57-community-release-el7-7.noarch.rpm
  • 安装mysql-server
    $: yum install mysql-server

• 查看版本
  $: mysql --version

• 启动mysqld
  $: systemctl start mysqld

• 查看临时密码
  $: grep 'temporary password' /var/log/mysqld.log

• 修改密码
  $: mysql_secure_installation
$: systemctl restart mysqld

• 允许所有外网访问
  $: mysql -u root -p
mysql>use mysql;

mysql> update user set host='%' where user='root';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

• 用navicate链接试试