MySQL8单机安装

原创已于 2025-06-19 09:33:29 修改 · 1k 阅读

14 ·

CC 4.0 BY-SA版权

文章标签：

#mysql

于 2024-12-17 10:00:01 首次发布

MySQL 专栏收录该内容

5 篇文章

订阅专栏

需要一台安装mysql的服务器，下载mysql安装包 mysql-8.0.36-linux-glibc2.28-x86_64.tar.gz
创建目录：mkdir /usr/local/mysql
复制：cp /home/files/ mysql-8.0.36-linux-glibc2.28-x86_64.tar.gz /usr/local
cd /usr/local
解压：tar -xvf mysql-8.0.36-linux-glibc2.28-x86_64.tar.gz
添加系统mysql组*** groupadd mysql***
创建用户useradd mysql -g mysql -d /home/mysql
mv mysql-8.0.36-linux-glibc2.28-x86_64 mysql
修改当前目录拥有者为mysql用户 chown -R mysql:mysql mysql
su - mysql
cd /usr/local/mysql
bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql/data --lower_case_table_names=1
此处mysql 初始密码为：km17q6ngpj;B
su 切换到root用户

配置 vi /etc/my.cnf

[mysqld]
wait_timeout = 31536000
interactive_timeout = 31536000
character_set_server=utf8
init_connect=‘SET NAMES utf8’
basedir=/usr/local/mysql
datadir=/data/mysql/data
max_allowed_packet=1024M
log-bin=mysql-bin
binlog-format=ROW
server_id=1
socket=/usr/local/mysql/tmp/mysql.sock #不区分大小写
(sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES这个简单来说就是sql语句是否严格)
lower_case_table_names = 1
log-error=/usr/local/mysql/log/mysqld.log
pid-file=/data/mysql/data/mysqld.pid

mkdir /usr/local/mysql/log
mkdir /usr/local/mysql/tmp
touch /usr/local/mysql/log/mysqld.log
chmod 777 -R /usr/local/mysql
添加开机启动   
cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld

修改 vi /etc/init.d/mysqld 添加路径
basedir=/usr/local/mysql
datadir=/data/mysql/data

切换至mysql用户启动mysql 命令是：
service mysqld start
加入开机起动 chkconfig --add mysqld (root用户)
ln -s /usr/local/mysql/bin/mysql /usr/bin (root用户)
ln -s /usr/local/mysql/tmp/mysql.sock /tmp/mysql.sock (root用户不加登录的时候会报 ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’)

切换到mysql 用户登录修改密码 mysql -uroot -p 上面初始化时的密码

alter user 'root'@'localhost' identified by 'root';
set global wait_timeout=604800;
set global interactive_timeout=604800;
flush privileges;  #刷新权限

alter user 'root'@'localhost' identified by 'this is pwd';
set global wait_timeout=604800;
set global interactive_timeout=604800;

update user set host = '%' where user = 'root';

flush privileges;  #刷新权限