目录
1、下载
MySQL :: Download MySQL Community Server
2、上传到服务器
可是使用Xftp等
3、解压、重命名
4、添加用户组和权限
并创建保存数据的文件夹data
把所有文件夹的权限都给mysql用户
5、配置my.config
[mysqld]
bind-address=0.0.0.0
port=3306
user=mysql
basedir=/usr/local/mysql5.7
datadir=/usr/local/mysql5.7/data
socket=/tmp/mysql.sock
log-error=/usr/local/mysql5.7/data/mysql.err
pid-file=/usr/local/mysql5.7/data/mysql.pid
#character config
character_set_server=utf8mb4
symbolic-links=0
explicit_defaults_for_timestamp=true
6、初始化
./mysqld --initialize --user=mysql --basedir=/usr/local/mysql5.7 --datadir=/usr/local/mysql5.7/data
如何报-bash: ./mysqld: No such file or directory
安装numactl
yum -y install numactl
7、进入数据库,修改密码
./mysql -u root -p
如果忘记密码,在mysql.err可以看到
修改密码
SET PASSWORD = PASSWORD('123456');
ALTER USER 'root'@'localhost' PASSWORD EXPIRE NEVER;
FLUSH PRIVILEGES;