在官网下载 mysql下载地址包
安装
[root@lsl01 usr]# rpm -ivh mysql80-community-release-el6-1.noarch.rpm
修改mysql的下载安装版本,将5.7的enable=0改为1,将8.0的enable=1改为0
vi /etc/yum.repos.d/mysql-community.repo
# Enable to use MySQL 5.7
[mysql57-community]
name=MySQL 5.7 Community Server
baseurl=http://repo.mysql.com/yum/mysql-5.7-community/el/6/$basearch/
enabled=1
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
[mysql80-community]
name=MySQL 8.0 Community Server
baseurl=http://repo.mysql.com/yum/mysql-8.0-community/el/6/$basearch/
enabled=0
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
安装mysql
[root@lsl01 usr]# yum install mysql-community-server
启动mysql,第一次启动可能失败,还需要第二次启动
[root@lsl01 usr]# service mysqld start
Initializing MySQL database: [FAILED]
[root@lsl01 usr]# service mysqld restart
Stopping mysqld: [ OK ]
Starting mysqld:
查看默认密码
[root@lsl01 usr]# grep 'temporary password' /var/log/mysqld.log
2018-10-26T20:38:25.148508Z 1 [Note] A temporary password is generated for root@localhost: h,Gwkw4fm3FJ
进入mysql
[root@lsl01 usr]# mysql -uroot -p
Enter password:
修改密码
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';
Query OK, 0 rows affected (0.00 sec)
进入到mysql数据库(此mysql是mysql自带的一个数据库,要区分清楚)
musql> use mysql
这个是为单个电脑ip授权的:
mysql> GRANT select,insert,update,delete ON *.* TO root@"172.16.16.152" IDENTIFIED BY "youpassword";
mysql> FLUSH PRIVILEGES;
mysql> exit
。。。或者。。。
为所有IP都赋予连接权限:
mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'youpassword' WITH GRANT OPTION;
mysql> FLUSH PRIVILEGES;
mysql> exit
设置开机自启动
[root@lsl01 usr]# chkconfig mysqld on
查看mysql状态
[root@lsl01 usr]# service mysqld status
mysqld (pid 2283) is running...