1.切换到root用户
1su - 2## OR ## 3sudo -i
2.安装mysql的yum源
1## Fedora 25 ## 2dnf install https://dev.mysql.com/get/mysql57-community-release-fc25-9.noarch.rpm 3 4## Fedora 24 ## 5dnf install https://dev.mysql.com/get/mysql57-community-release-fc24-9.noarch.rpm 6 7## Fedora 23 ## 8dnf install https://dev.mysql.com/get/mysql57-community-release-fc23-9.noarch.rpm
3.安装mysql 5.7.17
Fedora 25/24/23
dnf install mysql-community-server
4.设置开机启动mysql服务
1systemctl start mysqld.service ## use restart after update 2 3systemctl enable mysqld.service
5.设置一个root用户随机密码,用来登陆mysql修改密码
grep 'A temporary password is generated for root@localhost' /var/log/mysqld.log |tail -1
Example Output:
2015-11-20T21:11:44.229891Z 1 [Note] A temporary password is generated for root@localhost: -et)QoL4MLid
6.修改密码
使用这个命令
/usr/bin/mysql_secure_installation
输出
1Securing the MySQL server deployment. 2 3Enter password for user root: 4The 'validate_password' plugin is installed on the server. 5The subsequent steps will run with the existing configuration 6of the plugin. 7Using existing password for root. 8 9Estimated strength of the password: 100 10Change the password for root ? ((Press y|Y for Yes, any other key for No) : Y 11 12New password: 13 14Re-enter new password: 15 16Estimated strength of the password: 100 17Do you wish to continue with the password provided?(Press y|Y for Yes, any other key for No) : Y 18By default, a MySQL installation has an anonymous user, 19allowing anyone to log into MySQL without having to have 20a user account created for them. This is intended only for 21testing, and to make the installation go a bit smoother. 22You should remove them before moving into a production 23environment. 24 25Remove anonymous users? (Press y|Y for Yes, any other key for No) : Y 26Success. 27 28 29Normally, root should only be allowed to connect from 30'localhost'. This ensures that someone cannot guess at 31the root password from the network. 32 33Disallow root login remotely? (Press y|Y for Yes, any other key for No) : Y 34Success. 35 36By default, MySQL comes with a database named 'test' that 37anyone can access. This is also intended only for testing, 38and should be removed before moving into a production 39environment. 40 41 42Remove test database and access to it? (Press y|Y for Yes, any other key for No) : Y 43 - Dropping test database... 44Success. 45 46 - Removing privileges on test database... 47Success. 48 49Reloading the privilege tables will ensure that all changes 50made so far will take effect immediately. 51 52Reload privilege tables now? (Press y|Y for Yes, any other key for No) : Y 53Success. 54 55All done!
7.可以连接到mysql了
1mysql -u root -p 2 3## OR ## 4mysql -h localhost -u root -p