最新消息:XAMPP默认安装之后是很不安全的,我们只需要点击左方菜单的 "安全"选项,按照向导操作即可完成安全设置。

在Alibaba Cloud Linux R3安装MySQL8

XAMPP相关 admin 369浏览 0评论

1.切换系统目录/opt

l cd /opt

2.下载安装包

l  wget https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.20-linux-glibc2.12-x86_64.tar.xz

3.解压安装包

l tar xvJf mysql-8.0.20-linux-glibc2.12-x86_64.tar.xz

4.将解压后文件移动到/usr/local下并重命名为mysql

l mv /opt/mysql-8.0.20-linux-glibc2.12-x86_64 /usr/local/mysql

5.在/usr/local/mysql目录下创建data文件路径用来存放数据文件

l mkdir -p /usr/local/mysql/data

6.创建mysql用户和用户组

l groupadd mysql

l useradd -g mysql mysql

7.给mysql安装目录和数据目录授权mysql用户

l chown -R mysql:mysql /usr/local/mysql/

l chmod 775 -R /usr/local/mysql/data

8.配置环境,编辑/etc/profile文件添加如下内容

l export PATH=$PATH:/usr/local/mysql/bin:/usr/local/mysql/lib

9.编辑(创建)/etc/my.cnf内容如下

[mysql]

default-character-set=utf8mb4

[client]

socket=/var/lib/mysql/mysql.sock

[mysqld]

user=mysql

general_log = 1

general_log_file= /var/log/mysql/mysql.log

socket=/var/lib/mysql/mysql.sock

basedir=/usr/local/mysql

datadir=/usr/local/mysql/data

log-bin=/usr/local/mysql/data/mysql-bin

innodb_data_home_dir=/usr/local/mysql/data

innodb_log_group_home_dir=/usr/local/mysql/data/

character-set-server=utf8mb4

lower_case_table_names=1

autocommit=1

default_authentication_plugin=mysql_native_password

symbolic-links=0

[mysqld_safe]

log-error=/usr/local/mysql/data/mysql.log

pid-file=/usr/local/mysql/data/mysql.pid

10.切换到/usr/local/mysql/bin目录下执行mysql初始化

l cd /usr/local/mysql/bin

l ./mysqld –user=mysql –basedir=/usr/local/mysql –datadir=/usr/local/mysql/data/ –initialize

11.初始化报错如下图

需要安装libaio包

yum install -y libaio

执行初始化后如下图,图上红色标记框为数据库默认密码。

12.将mysql.server文件放到启动/etc/init.d/目录中

l cp -a /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql

l cp -a /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld

13.检查一下/var/lib/mysql是否存在,没有就创建一个

l mkdir /var/lib/mysql

14.相关文件赋权

l chown 777 /etc/my.cnf

l chmod +x /etc/init.d/mysql

l chmod +x /etc/init.d/mysqld

l chown -R mysql:mysql /var/lib/mysql/

15.创建mysql命令链接

l ln -s /usr/local/mysql/bin/mysql /usr/bin

16.启动MySQL服务

l service mysql start

17.登录MySQL数据库

l mysql -u root -p

18.修改初始化密码和数据库连接权限

l ALTER USER ‘root’@’localhost’ IDENTIFIED WITH mysql_native_password BY ‘输入新密码’;

l  use mysql;

l update user set host=’%’ where user=’root’;

l flush privileges;

                                               完结

转载请注明:XAMPP中文组官网 » 在Alibaba Cloud Linux R3安装MySQL8

您必须 登录 才能发表评论!