rhel_7.x 安装mysql

本文指导如何在系统中安装MariaDB或MySQL服务器,并提供详细步骤以清理冲突,启动、停止和重启MySQL服务,以及重置MySQL根密码。

http://database.51cto.com/art/201310/413006.htm

MariaDB和MySQL 

 

--mysql-5.7.12-1.el7.x86_64.rpm-bundle.tar

]# ls
mysql-community-client-5.7.12-1.el7.x86_64.rpm
mysql-community-common-5.7.12-1.el7.x86_64.rpm
mysql-community-devel-5.7.12-1.el7.x86_64.rpm
mysql-community-libs-5.7.12-1.el7.x86_64.rpm
mysql-community-server-5.7.12-1.el7.x86_64.rpm

 

一般把以上安装就可用

清理冲突:MariaDB和MySQL 只能安装一个,相互间有冲突,

rpm -qa |grep mariadb
rpm -e --allmatches mariadb-server --nodeps

How to start/stop/restart MySQL Server

Now MySQL Server is installed on your system.

To start MySQL Service, run command

systemctl start mysqld

To stop MySQL Service, run command

systemctl stop mysqld

To restart MySQL Service, run command

systemctl restart mysqld

To get status of MySQL Service, run command

systemctl status mysqld

Reset MySQL root password

默认密码在这:cat /var/log/mysqld.log | grep localhost

mysql -uroot -p

set password='book_@BOOK%4321';
grant all privileges on *.* to 'root'@'%' identified by 'book_@BOOK%4321';
grant all privileges on *.* to 'ucr_param'@'%' identified by 'Abc%4321';

flush privileges;

 

转载于:https://www.cnblogs.com/book-gary/p/5511628.html

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值