下载解压
-
解压重命名
tar -zxvf mysql-5.7.25-linux-glibc2.12-x86_64.tar.gz -C /usr/local/ mv /usr/local/mysql-5.7.25-linux-glibc2.12-x86_64/ /usr/local/mysql
-
创建data目录
mkdir /usr/local/mysql/data
创建mysql用户和用户组
-
创建用户组
groupadd mysql
-
创建用户
useradd mysql -g mysql
-
将/usr/local/mysql目录的所有者及所属组改为mysql
chown -R mysql.mysql /usr/local/mysql
配置
-
初始化(此步骤可能出现缺少依赖,安装对应依赖即可)
/usr/local/mysql/bin/mysqld --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data --initialize
[Note] A temporary password is generated for root@localhost: A4fn_Us%o%<w
注:执行初始化后会生成一个临时密码, 临时密码:A4fn_Us%o%<w -
编辑/etc/my.cnf配置文件
vim /etc/my.cnf
[mysqld] #创建的data目录 datadir=/usr/local/mysql/data #mysql安装目录 basedir=/usr/local/mysql socket=/tmp/mysql.sock #跳过密码验证 #skip-grant-tables character-set-server=utf8 symbolic-links=0 [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid
启动服务
-
将mysql添加到服务脚本中
cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql
-
启动
service mysql start
重置密码及开启远程连接
-
连接mysql: 密码为初始化生成的临时密码
/usr/local/mysql/bin/mysql -u root -p
-
重置密码
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY '重置的密码';
-
开启远程连接
mysql> use mysql; mysql> update user set host='%' where user = 'root'; mysql> flush privileges; mysql> exit;
卸载
- 停止mysql服务
service mysql stop
- 删除mysql目录
find / -name mysql -exec rm -rf {} \; sudo rm /etc/my.cnf
- 删除mysql用户和用户组
id mysql userdel mysql groupdel mysql
作者公众号