本文共 1860 字,大约阅读时间需要 6 分钟。
下载与安装MySQL:
这里采用Yum管理好了各种rpm包的依赖,能够从指定的服务器自动下载RPM包并且安装,所以在安装完成后必须要卸掉,否则会自动更新。
1.安装MySQL官方的yum repository
[root@localhost ~]# wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm
2.下载rpm包[root@localhost ~]# yum -y install mysql57-community-release-el7-10.noarch.rpm
3.安装MySQL服务[root@localhost ~]# yum -y install mysql-community-server
最后会出现个complete!4.启动MySQL服务
[root@localhost ~]# systemctl start mysqld.service
看到类似下面的界面,或者以Starting MySqL server… started MysqlServer…结尾的就成功启动了还有几个关于MySQL常用的命令:
重启:systemctl restart mysqld.service
停止:systemctl stop mysqld.service
查看状态:systemctl status mysqld.service
关于登录MySQL:
登录命令:
[root@localhost ~]# mysql -u root -p
意思就是用root用户登录,然后准备输入密码初次登陆先 查看MySql默认密码
[root@localhost ~]# grep ‘temporary password’ /var/log/mysqld.log修改数据库密码
由于set password for root @localhost=password(‘passwd’); 可能会报错 MySQL 5.7 中 Your password does not satisfy the current policy requirements. 问题 set global validate_password_policy=0; set global validate_password_length=4; 上面两个命令搞定 开始设置自己的密码: set password for root @localhost=password(‘passwd’); 一些常用命令 复制代码[root@localhost ~]# service mysqld restart
[root@localhost ~]# yum repolist all | grep mysql
[root@localhost ~]# yum repolist enabled | grep mysql
[root@localhost ~]# yum install mysql-community-server
[root@localhost ~]# whereis mysql
[root@localhost ~]# systemctl start mysqld
[root@localhost ~]# systemctl status mysqld
[root@localhost ~]# systemctl stop mysqld
[root@localhost ~]# mysql
[root@localhost ~]# grep ‘temporary password’ /var/log/mysqld.log
mysql>show databases;
mysql>exit;
mysql>SELECT DISTINCT CONCAT(‘User: ‘’’,user,’’’@’’’,host,’’’;’) AS query FROM mysql.user
复制代码转载地址:http://vgxmb.baihongyu.com/