rhel_7.x 安裝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=‘[email protected]%4321‘;
grant all privileges on *.* to ‘root‘@‘%‘ identified by ‘[email protected]%4321‘;
grant all privileges on *.* to ‘ucr_param‘@‘%‘ identified by ‘Abc%4321‘;

flush privileges;

 

rhel_7.x 安裝mysql