成都创新互联致力于互联网品牌建设与网络营销，包括
成都网站制作、做网站、SEO优化、网络推广、整站优化营销策划推广、电子商务、移动互联网营销等。
成都创新互联为不同类型的客户提供良好的互联网应用定制及解决方案，
成都创新互联核心团队十多年专注互联网开发，积累了丰富的网站经验，为广大企业客户提供一站式企业网站建设服务，在网站建设行业内树立了良好口碑。
0.环境：
os : CentOS release 6.10 (Final)
Msyql: mysql8.0.14
1.下载官方打包好的二进制安装包：
#wget /tupian/20230522/mysql-8.0.14-linux-glibc2.12-x86_64.tar.xz
8.0采用了新的.xz压缩方式，文件很小，只有350M左右
2.解压：
tar -xJvf mysql-8.0.14-linux-glibc2.12-x86_64.tar.xz
3.放到/usr/local下
[root@iceman local]# ln -s mysql-8.0.14-linux-glibc2.12-x86_64 mysql
4.配置参数文件 /etc/my.cnf
[mysqld]
server-id = 1
port = 3306
datadir = /data/mysql
socket = /tmp/mysql.sock
pid-file = /tmp/mysqld.pid
log-error = error.log
slow-query-log = 1
slow-query-log-file = slow.log
long_query_time = 0.2
log-bin = bin.log
binlog_format =ROW
character-set-client-handshake = FALSE
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
init_connect ='SET NAMES utf8mb4'
innodb_buffer_pool_size = 200M
join_buffer_size = 10M
sort_buffer_size = 2M
read_rnd_buffer_size = 2M
log_timestamps = SYSTEM
5.创建用户和目录
[root@iceman ~]# groupadd mysql
[root@iceman ~]# useradd -r -g mysql -s /bin/false mysql ### /bin/false的意思是，禁止一起登录行为
[root@iceman ~]# mkdir -p /data/mysql
[root@iceman ~]# chown -R mysql:mysql /data/mysql/
[root@iceman ~]# chmod -R 775 /data/mysql/
6.初始化数据库：可以用--initialize-insecure不生成密码
[root@iceman bin]# pwd
/usr/local/mysql/bin
[root@iceman bin]# ./mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql
初始化的时候遇到如下两个问题，用Yum 安装上即可。
./mysqld: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory
yum -y install libaio
./mysqld: error while loading shared libraries: libnuma.so.1: cannot open shared object file: No such file or directory
yum -y install numactl
7.设置启动文件：
#cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql
--启动数据库：
# /etc/init.d/mysql start
Starting MySQL.Logging to '/data/mysql/error.log'.
SUCCESS!
8.修改环境变量
# vim /etc/profile.d/mysql.sh
export PATH=$PATH:/usr/local/mysql/bin
# source /etc/profile.d/mysql.sh
9
.修改密码
mysql> show databases;
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
mysql>
mysql>
mysql> alter user root@localhost identified by 'Hellxxxeiyun!@#$';
Query OK, 0 rows affected (0.01 sec)
分享标题：MySQL8.0安装-创新互联
转载来源：
http://cdkjz.cn/article/iesgo.html
