centos install mysql

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18


yum list installed mysql*
rpm –qa|grep mysql*
yum list mysql*

yum install mysql
sudo rpm -Uvh http://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm
yum repolist enabled | grep mysql.*

yum install mysql-community-server

systemctl start  mysqld
grep "password" /var/log/mysqld.log
mysql -uroot -p

set password for root@localhost = password('password'); 
ALTER USER 'root'@'localhost' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;
FLUSH PRIVILEGES;