安装命令
-- 解压
tar -zxvf mysql-5.7.32-linux-glibc2.12-x86_64.tar.gz
mv mysql-5.7.32-linux-glibc2.12-x86_64 /usr/local/mysql
-- 添加用户
groupadd mysql
useradd -r -g mysql mysql
-- 在/usr/local/mysql下创建数据目录
mkdir -p ./data
vi /etc/my.cnf
-- 添加权限
chmod -R 755 /usr/local/mysql/data
sudo chown -R mysql:mysql /usr/local/mysql
--切换到/usr/local/mysql/bin目录下面,初始化
./mysqld --defaults-file=/etc/my.cnf --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data/ --user=mysql --initialize
-- 创建文件
touch /var/log/mariadb/mariadb.log
chown -R mysql:mysql /var/log/mariadb/
-- 添加到服务
cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql
service mysql start
-- 设置环境变量
vi /etc/profile
export PATH="$PATH":/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin
export MYSQL_HOME=/usr/local/mysql
export PATH="$PATH":"$MYSQL_HOME"/bin
source /etc/profile
-- 查看临时密码
cat /usr/local/mysql/mysql.err
-- 登录
mysql -uroot -p
-- 修改密码
SET PASSWORD = PASSWORD('123456');
ALTER USER 'root'@'localhost' PASSWORD EXPIRE NEVER;
FLUSH PRIVILEGES;
-- 设置允许远程登录
use mysql
update user set host = '%' where user = 'root';
FLUSH PRIVILEGES;