[root@localhost ~]# yum repolist enabled | grep "mysql.*-community.*" mysql-connectors-community/x86_64 MySQL Connectors Community 24 mysql-tools-community/x86_64 MySQL Tools Community 38 mysql57-community/x86_64 MySQL 5.7 Community Server 146
[root@localhost ~]# yum repolist all | grep mysql mysql-connectors-community/x86_64 MySQL Connectors Community 启用: 24 mysql-connectors-community-source MySQL Connectors Community - Sourc 禁用 mysql-tools-community/x86_64 MySQL Tools Community 启用: 38 mysql-tools-community-source MySQL Tools Community - Source 禁用 mysql-tools-preview/x86_64 MySQL Tools Preview 禁用 mysql-tools-preview-source MySQL Tools Preview - Source 禁用 mysql55-community/x86_64 MySQL 5.5 Community Server 禁用 mysql55-community-source MySQL 5.5 Community Server - Sourc 禁用 mysql56-community/x86_64 MySQL 5.6 Community Server 禁用 mysql56-community-source MySQL 5.6 Community Server - Sourc 禁用 mysql57-community/x86_64 MySQL 5.7 Community Server 启用: 146 mysql57-community-source MySQL 5.7 Community Server - Sourc 禁用 mysql80-community/x86_64 MySQL 8.0 Community Server 禁用 mysql80-community-source MySQL 8.0 Community Server - Sourc 禁用
[root@localhost ~]# yum repolist enabled | grep mysql mysql-connectors-community/x86_64 MySQL Connectors Community 24 mysql-tools-community/x86_64 MySQL Tools Community 38 mysql56-community/x86_64 MySQL 5.6 Community Server 289
好了。下面就可以进行安装MySQL了。
安装MySQL
我这里也是使用MySQL5.7来安装的。
我们只需要执行以下命令就OK了:
1
yum install mysql-community-server
#MySQL 管理命令
使用下面的命令启动MySQL:
1 2
[root@localhost ~]# service mysqld start Redirecting to /bin/systemctl start mysqld.service
只要没有错误信息就表示已经正常启动了。
现在我们看以下MySQL的状态:
1 2 3 4 5 6 7 8 9 10 11 12 13
[root@localhost ~]# service mysqld status Redirecting to /bin/systemctl status mysqld.service ● mysqld.service - MySQL Server Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled) Active: active (running) since 一 2016-11-14 12:34:44 CST; 5min ago Process: 35494 ExecStart=/usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid $MYSQLD_OPTS (code=exited, status=0/SUCCESS) Process: 35421 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS) Main PID: 35498 (mysqld) CGroup: /system.slice/mysqld.service └─35498 /usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid
11月 14 12:34:39 localhost.localdomain systemd[1]: Starting MySQL Server... 11月 14 12:34:44 localhost.localdomain systemd[1]: Started MySQL Server.
这样表示已经正常启动了。
停止:
1
service mysqld stop
重启:
1
service mysqld restart
修改MySQL密码
我们首先查找一下MySQL的密码:
1 2
[root@localhost ~]# grep 'temporary password' /var/log/mysqld.log 2016-11-14T04:34:41.742516Z 1 [Note] A temporary password is generated for root@localhost: sNKz9yEdzw%/
我们就可以看到我们的密码就是: **sNKz9yEdzw%/**。
首先启动MySQL client:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
[root@localhost ~]# mysql -uroot -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 Server version: 5.7.16
Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql>
首先我们先查看一下数据库:
1 2
mysql>show databases; ERROR 1820 (HY000): You must reset your password usingALTERUSER statement before executing this statement.