center os 6.5 安装mysql8
使用yum方法安装,先删除自带的mysql文件
windows下打开https://dev.mysql.com/downloads/repo/yum/,下载:
Red Hat Enterprise Linux 6 / Oracle Linux 6 (Architecture Independent), RPM Package | 25.2K | ||
(mysql80-community-release-el6-1.noarch.rpm) 拷贝到centos系统中: rpm -Uvh mysql80-community-release-el6-1.noarch.rpm *因为默认安装mysql8,所以不需要做如下修改 yum-config-manager --disable mysql80-community yum-config-manager --enable mysql57-community 接下来安装mysqlserver yum install mysql-community-server 安装完,启动mysql server service mysqld start 取得mysql root的默认密码 grep 'temporary password' /var/log/mysqld.log 用默认密码登陆mysql mysql -uroot -p ALTER USER 'root'@'localhost' IDENTIFIED BY 'pass!'; 到此mysql已正常可用 新建用户,用于远程访问 create user 'admin'@'localhost' identified by 'pass!'; grant all privileges on *.* to 'admin'@'localhost'; 这样就可以远程访问了。 详细可参照: https://dev.mysql.com/doc/mysql-yum-repo-quick-guide/en/#repo-qg-yum-fresh-install |