大数据之yum安装MySQL5.7 安装下载Yum Repositorywget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm如果上述链接失效可以直接通过百度云盘下载文件https://pan.baidu.com/s/1MQVqwavbJPVkxa4dnREqdg?pwd7ja7执行安装命令yum -y install mysql57-community-release-el7-10.noarch.rpm安装MySQLyum -y install mysql-community-server此时可能会遇到问题问题原因是Mysql的GPG升级了需要重新获取rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022上述链接如果失效使用下面文本和链接内容等价-----BEGIN PGP PUBLIC KEY BLOCK----- mQINBGG4urcBEACrbsRa7tSSyxSfFkBKXSbNM9rxYqoB78u107skReefq4/Y72 TpDvlDZLmdv/lK0IpLa3bnvsM9IE1trNLrfiJES62kaQ6hePPgn2RqxyIirt2se Si3Z3n3jlEgmSdhAvWbhFnqxoTY0URBwDi4oO0YzHefkYPSmNPdlxRPQBMv 4GPTNfxERx6XvVSPcL1jQ4R2cQFBryNhidBFIkoCOszjWhmWnbURsLheBp757l qEyrpCufz77zlq2gEiwtPHItfqsx3rzxSRqatztMGYZpNUHNBJkr13npZtGWkd N/xu980QLZxNbZ88pNoOuzD6dKcpMJ0LkdUmTx5z9ewiFiFbUDzZ7PECOm2g3ve Jrwr79CXDLE139Hr8rDM2kDhSr9tAlPTnHVDcaYIGgSNIBcYfLmt91133klHQHB IdWCNVtWJjq5YcLQJ9TxG9GQzgABPrm6NDd1t9j7w1L7uwBvMB1wgpirRTPVfnUS Cd025PEFwTcBhfnzLtFj5xD7mNsmDmeHkF/sDfNOfAzTE1v2wq0ndYU60xbL6/ yl/Nipyr7WiQjCG0m3WfkjjVDTfs7/DXUqHFDOu4WMF9voqwpJXmAeGhQTWZC/Q hWtrjrNJAgwKpp263gDSdW70ekhRzsok1HJwX1SfxHJYCMFs2aH6ppzNsQARAQAB tDZNeVNRTCBSZWxlYXNlIEVuZ2luZWVyaW5nIDxteXNxbC1idWlsZEBvc3Mub3Jh Y2xlLmNvbT6JAlQEEwEIAD4WIQSFmjXxYb1OEMLGcJGe5QtOnm9KQUCYbi6twIb AwUJA8JnAAULCQgHAgYVCgkICwIEFgIDAQIeAQIXgAAKCRBGe5QtOnm9KUewD/99 2sS31WLGoUQ6NoL7qOB4CErkqXtMzpJAKKg2jtBGG3rKE1/0VAg1D8AwEK4LcCO4 07wohnH0hNiUbeDck5x20pgS5SplQpuXX1K9vPzHeL/WNTb98S3H2Mzj4o9obED6 Ey52tTupttMF8pC9TJ93LxbJlCHIKKwCA1cXud3GycRN72eqSqZfJGdsaeWLmFmH f6oee27d8XLoNjbyAxna/4jdWoTqmp8oT3bgv/TBco23NzqUSVPi7ljS1hHvcJu oJYqaztGrAEf/lWIGdfl/kLEh8IYx8OBNUojh9mzCDlwbs83CBqoUdlzLNDdwmzu 34Aw7xK14RAVinGFCpo/7EWoX6weyB/zqevUIIE89UABTeFoGih/hx2jdQV/NQNt hWTW0jH0hmPnajBVAJPYwAuO82rx2pnZCxDATMn0elOkTue3PCmzHBF/GT6c65aQ C4aojj0Veh787QllQ9FrWbwnTz4fNzU/MBZtyLZ4JnsiWUs9eJ2V1g/ARiIKu 357Qgy1ytLqlgYiWfzHFlYjdtbPYKjDaScnvtY8VO2Rktm7XiV4zKFKiaWpvuVY pR0/7Adgnlj5Jt9lQQGOrZ2VYx8SvBcCby3XAtYkRHtX5u4MLlVS3gcoWfDiWw CpvqdK21EsXjQJxRr3dbSn0HaVj4FJZX0QQ7WZm6WLkCDQRhuLq3ARAA6RYjqfC0 YcLGKvHhoBnsX29vy9Wn1y2JYpEnPUIB8X0VOyz5/ALv4Hqtl4THkHmmMuhtndo q2BkCCk508jWBvKS1SBd2esB45BDDmIhuX3ozu9Xza4i1FsPnLkQ0uMZJv30ls2 pXFmskhYyzmo6aOmH2536LdtPSlXtywfNV1HEr69V/AHbrEzfoQkJ/qvPzELBOjf jwtDPDePiVgW9LhktzVzn/BjO7XlJxw4PGcxJG6VApsXmM3t2fPN9eIHDUq8ocbH dJ4en8/bJDXZd9ebQoILUuCg46hE3p6nTXfnPwSRnIRnsgCzeAz4rxDR4/Gv1Xpz v5wqpL21XQi3nvZKlcv7J1IRVdphK66De9GpVQVTqC102gqJUErdjGmxmyCA1OOO RqEPfKTrXz5YUGsWwpH4xCuNQP0qmreRw3ghrH8potIr0iOVXFic5vJfBTgtcuE B6E6ulAN3jqBGTaBML0jxgj3Z5VC5HKVbpg2DbB/wMrLwFHNAbzV5hj2Os5Zmva 0ySP1YHB26pAW8dwB38GBaQvfZq3ezM4cRAo/iJ/GsVE98dZEBOMl0KYjZGv yxzo20sweun7ZKT9qZM90f6cQ3zqX6IfXZHHmQJBNv73mcZWNhDQOHs4wBoqFG QWNqLU9xaZxdXw80r1viDAwOy13EUtcVbTkAEQEAAYkCPAQYAQgAJhYhBIWb6NfF hvU4QwsZwkZ7lC06eb0pBQJhuLq3AhsMBQkDwmcAAAoJEEZ7lC06eb0pSi8P/iy dNnxrtiENn9vkkA7AmZ8RsvPXYVeDCDSsL7UfhbS77r2L1qTa2aB3gAZUDIOXln5 1lSxMeeLtOequLMEV2Xi5km70rdtnja5SmWfc9fyExunXnsOhg6UG872At5CGEZU 0c2Nt/hlGtOR3xbt3O/UwldErQPA4BUbW5K1T7OC6oPvtlKfF4bGZFloHgt2yE9 YSNWZsTPe6XJSapemHZLPOxJLnhs3VBirWE31QS0bRl5AzlO/fg7ia65vQGMOCOT LpgChTbcZHtozeFqva4IeEgE4xN6r8WtgSYeGGDRmeMEVjPM9dzQObfSvGd58u 2z9f2agPK1H32c69RLoA0mHRe7Wkv4izeJUc5tumUY0e8OjdenZZjT3hjLh6tMm rp2oWnQIoed4LxUw1dhMOj0rYXv6laLGJ1FsW5eSke7ohBLcfBBTKnMCBohROHy2 E63Wggfsdn3UYzfqZ8cfbXetkXuLS/OM3MXbiNjgElYzjgWrkayu7yLakZxmx6 sHPIJYm2hzkniMG29d5mGl7ZT9emP9bCfqGUxoXJkjs0gnDl44bwGJ0dmIBu3aj VAaHODXyY/zdDMGjskfEYbNXCAY2FRZSE58tgTvPKDKd2KGplMU2EIFT7JYfKh HAB5DGMkx92HUMidsTSKHeQnnnoFmu4gnmDU31i Xqbo -----END PGP PUBLIC KEY BLOCK-----再次执行安装命令yum -y install mysql-server启动MySQL启动服务systemctl start mysqld.service查看服务状态systemctl status mysqld.service修改root密码查看初始密码grep password /var/log/mysqld.log进入数据库mysql -uroot -p输入上述命令后回车并输入初始密码。修改密码。new password 是密码明文ALTER USER rootlocalhost IDENTIFIED BY new password;此时可能遇到问题需要修改密码策略执行命令set global validate_password_policy0; set global validate_password_length1;再次执行修改密码命令ALTER USER rootlocalhost IDENTIFIED BY new password;允许指定IP连接数据库此处允许所有ip访问使用%指定IP更新为特定ip就行UPDATE user SET host % WHERE user root; FLUSH PRIVILEGES;