1、MySQL 8.0下载
官方网站下载 MySQL 8.0 安装包,下载地址:
MySQL :: Download MySQL Community Server (Archived Versions)
(我的是CentOS7,所以选择图上这个,根据自己的系统来选择)
找到这一条 并点击下载
下载好后,传到Linux的某个文件夹下(自己记得路径,这里是放到了home文件夹下)
解压
tar xzvf mysql.tar.gz
移动到/usr/local/ 并重命名(mysql-8.0.28-xxxxx为解压后的文件夹名,根据自己文件夹名而定)
mv mysql-8.0.28-xxxxx mysql
mv mysql /usr/local/
创建mysql用户、更改mysql目录下所有的目录及文件夹所属的用户组、用户和权限
useradd mysql
chown -R mysql:mysql /usr/local/mysql
chmod -R 755 /usr/local/mysql
编译安装并初始化mysql,记住输出日志末尾的密码(数据库管理员临时密码)
[root@localhost /]# cd /usr/local/mysql/bin
[root@localhost bin]# ./mysqld --initialize --user=mysql --datadir=/usr/local/mysql/data --basedir=/usr/local/mysql
修改/etc/目录下配置文件my.cnf
[mysqld]
basedir = /usr/local/mysql
datadir = /usr/local/mysql/data
socket = /usr/local/mysql/mysql.sock
character-set-server=utf8
port = 3306
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
[client]
socket = /usr/local/mysql/mysql.sock
default-character-set=utf8
启动mysql服务
/usr/local/mysql/support-files/mysql.server start
添加软连接,并重启mysql服务
ln -s /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql
ln -s /usr/local/mysql/bin/mysql /usr/bin/mysql
service mysql restart
登录mysql,
修改密码
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123';
开放远程连接
mysql> use mysql;
mysql> update user set host='%' where user='root' limit 1;
mysql> flush privileges;
设置开机自动启动
//将服务文件拷贝到init.d下,并重命名为mysql
[root@localhost /]# cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
//赋予可执行权限
[root@localhost /]# chmod +x /etc/init.d/mysqld
//添加服务
chkconfig --add mysqld
//查看服务列表
[root@localhost /]# chkconfig --list
客户端连接数据库(主机为你安装MySQL的Linux的ip地址,端口为Linux上MySQL的端口,连接名随意 只为区分数据库)