Linux 安装Mysql

进入官网下载: https://dev.mysql.com/downloads/mysql/

解压并移动到/usr/local

sudo tar -xvJf mysql-8.0.19-linux-glibc2.12-x86_64.tar.xz -C /usr/local

创建软链接

cd /usr/local
sudo ln -s mysql-8.0.19-linux-glibc2.12-x86_64 mysql

添加mysql用户组和mysql用户

sudo groupadd mysql
sudo useradd -r -g mysql -s /bin/false mysql

创建data文件夹存放数据库文件

cd /usr/local/mysql
sudo mkdir /usr/local/mysql/data

修改当前目录拥有者为新建的mysql用户

sudo chown -R mysql:mysql ./

安装mysql

sudo ./bin/mysqld --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --initialize

此时会生成一个密码 记住密码

2022-09-10T17:18:07.041567Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: JgPcTuKgw5&+

开启mysql服务

cd /usr/local/mysql-8.0.19-linux-glibc2.12-x86_64/support-files 
sudo ./mysql.server start

配置环境变量

cd ..
pwd

sudo vim ~/.bashrc

#MYSQL_HOME
export MYSQL_HOME=pwd结果
export PATH=$PATH:$MYSQL_HOME/bin

source ~/.bashrc

登录

mysql -u root -p
密码

修改密码

alter user 'root'@'localhost' identified by '123456';