mysql离线安装-centos
2023-11-06
[TOC]
步骤一、下载mysql安装包
https://dev.mysql.com/downloads/mysql/
步骤二、安装mysql
Centos7.9
sudo rpm -ivh mysql-community-common-8.0.35-1.el7.x86_64.rpm --nodeps --force
sudo rpm -ivh mysql-community-libs-8.0.35-1.el7.x86_64.rpm --nodeps --force
sudo rpm -ivh mysql-community-client-8.0.35-1.el7.x86_64.rpm --nodeps --force
sudo rpm -ivh mysql-community-server-8.0.35-1.el7.x86_64.rpm --nodeps --force
安装依赖
http://mirror.centos.org/centos/7/os/x86_64/Packages/libaio-0.3.109-13.el7.x86_64.rpm
yum install libaio
步骤三、配置mysql
曙光
[mysql]
default-character-set=utf8mb4
[mysqld]
port=3306
character-set-server=utf8mb4
default-storage-engine=InnoDB
collation-server=utf8mb4_unicode_ci
datadir=/work/home/jscxds_wm/project/uhd_ai2/mysql/data
socket=/work/home/jscxds_wm/project/uhd_ai2/mysql/mysql.sock
log-error=/work/home/jscxds_wm/project/uhd_ai2/mysql/mysqld.log
pid-file=/work/home/jscxds_wm/project/uhd_ai2/mysql/mysqld.pid
[client]
port=3306
default-character-set=utf8mb4
一般
vim /etc/my.cnf
[mysql]
default-character-set=utf8mb4
[mysqld]
port=3306
character-set-server=utf8mb4
default-storage-engine=InnoDB
collation-server=utf8mb4_unicode_ci
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
[client]
port=3306
default-character-set=utf8mb4
步骤四、初始化
mysqld --defaults-file=/work/home/jscxds_wm/project/uhd_ai2/mysql/my.cnf --user=mysql --initialize
问题解决
mysqld: Can’t create/write to file ‘/var/lib/mysql/data/is_writable’ (OS errno 13 - Permission denied)
给数据目录赋权 777
chmod 777 -R /var/lib/mysql/data/
获取密码
查看生成的临时密码
# [Server] A temporary password is generated for root@localhost: )dcaZzeia7G&
cat mysqld.log
步骤五、启动mysql
mysqld --defaults-file=/work/home/jscxds_wm/project/uhd_ai2/mysql/my.cnf --user=mysql --port=3306
其他命令
mysqld \
--defaults-file=/etc/my.cnf \
--basedir=/var/lib/mysql \
--datadir=/work/home/jscxds_wm/project/mysql/data \
--user=mysql \
--log-error=/work/home/jscxds_wm/project/mysql/mysql.err \
--open-files-limit=65535 \
--pid-file=/work/home/jscxds_wm/project/mysql/mysql.pid \
--socket=/work/home/jscxds_wm/project/mysql/mysql.sock \
--port=3306
步骤六、连接数据库
连接数据库
# 输入密码 )dcaZzeia7G&
mysql -S /work/home/jscxds_wm/project/uhd_ai2/mysql/mysql.sock -uroot -p
修改密码
alter user 'root'@'localhost' identified by '2kzwAEw2OHE3';
新建用户
create user 'uhd_ai'@'localhost' identified by 'K1IfQEYBSiR5a&2GQI';
新建数据库
CREATE DATABASE uhd_ai;
使用数据库
use uhd_ai;
导入数据库
source /work/home/jscxds_wm/project/uhd_ai2/uhd_ai_20231106173505_backup.sql
数据库授权给uhd_ai
grant all privileges on uhd_ai.* to 'uhd_ai'@'localhost';
刷新权限
flush privileges;
参考
https://blog.csdn.net/weixin_40019326/article/details/131577598
https://blog.csdn.net/aiming66/article/details/118998734
https://blog.51cto.com/u_16175519/7256294