我安装的是mysql-8.0.11-linux-glibc2.12-x86_64.tar.gz
下载地址:https://dev.mysql.com/downloads/mysql/
1 解压压缩包
copy 到/usr/local/mysql 目录(最好放在/usr/local/目录下,其它目录容易出现各种问题)
2 创建用户组和用户
groupadd mysql
useradd -r -g mysql mysql
为了安全性,给数据库创建专用用户,mysql只能访问mysql目录
3 在mysql目录下创建data文件夹
mkdir /usr/local/mysql/data
4 指定用户和用户组
cd /usr/local/mysql
chown -R mysql:mysql ./
5 初始化mysql
./bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data --lc_messages_dir=/usr/local/mysql/share --lc_messages=en_US
6 初始化后会产生mysql用户root的临时密码记录下来(如下)
2018-06-23T13:49:35.319844Z 1 [Note] A temporary password is generated for root@localhost: Dpm=g=dJ#4kD
7 配置my.cnf
在配置之前执行
chown -R root:root ./
chown -R mysql:mysql data
vim /etc/my.cnf
添加内容如下:
[mysqld]
basedir = /usr/local/mysql/
datadir = /usr/local/mysql/data
port = 3306
character-set-server = utf8
explicit_defaults_for_timestamp = true
8 添加启动命令
cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
vim /etc/init.d/mysqld
将mysql目录填上:
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data
chmod +xxx /etc/init.d/mysqld
##当做用户命令使用,非常方便
ln -s /usr/local/mysql/bin/mysql /usr/bin/mysql
9 服务启动、停止、重启
第一次配置完后需要重启电脑一下
service mysqld start/stop/restart
10 修改mysql用户root的密码
service mysqld start
mysql -u root -p
输入初始化时保存的密码
修改密码:ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass';