下载MySQL linux版
安装MySQL
解压到/usr/local目录下
tar -zxvf mysql-5.7.32-linux-glibc2.12-x86_64.tar.gz -C /usr/local/
重命名mysql
cd /usr/local
mv mysql-5.7.32-linux-glibc2.12-x86_64/ mysql
安装依赖库
cd mysql
yum install -y libaio
yum -y install numactl
创建mysql用户与用户组
cd mysql
mkdir data
groupadd mysql
useradd -r -s /sbin/nologin -g mysql mysql -d /usr/local/mysql/
创建mysql相关目录与授权(需存在mysql用户与用户组)
mkdir /usr/local/mysql/data /usr/local/mysql/log
mkdir -p /var/lib/mysql/
mkdir -p /var/run/mysqld/
touch /usr/local/mysql/log/mysqld.log
chmod 666 /usr/local/mysql/log/mysqld.log
chown -R mysql:mysql /usr/local/mysql
chown -R mysql:mysql /var/run/mysqld/
chown -R mysql:mysql /var/lib/mysql/
初始化命令
cd /usr/local/mysql/bin
./mysqld --initialize --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data/
初始化中如果碰见这个问题
/pic:mw://bb3282da93ee203a683e8e0447f899c7
删除已经初始化的数据,重新初始化
rm -rf /usr/local/mysql/data
./mysql_install_db --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data/
./mysqld --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data/
查看安装成功后的数据库root密码
cd /root/
cat .mysql_secret
输出内容
# Password set for user 'root@localhost' at 2020-10-30 16:59:57
gKcu4Awy1ZYa 这个是密码
杀死当前mysql进程
netstat -apn | grep 3306
输出
tcp6 0 0 :::3306 :::* LISTEN 17927/./mysqld
kill -9 17927
修改基本配置
vim /usr/local/mysql/support-files/mysql.server
将basedir与datadir的值按照如下修改后保存并退出
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data
mysqld_pid_file_path=/var/run/mysqld/mysqld.pid
为脚本创建软链接
ln -s /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
ln -s /usr/local/mysql/bin/mysql /usr/bin/mysql
添加基本my.cnf配置
cd /etc/
vim /etc/my.cnf
my.cnf文件
[mysqld]
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data
socket=/tmp/mysql.sock
user=mysql
port=33068
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
init_connect='SET NAMES utf8mb4'
symbolic-links=0
max_connections=200
default-storage-engine=INNODB
lower_case_table_names=1
max_allowed_packet=32M
explicit_defaults_for_timestamp=true
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
[mysqld_safe]
log-error=/usr/local/mysql/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
修改mysqld执行权限
chmod 755 /etc/rc.d/init.d/mysqld
设置mysql开机启动
chkconfig mysqld on
启动MySQL
service mysqld start
service mysqld stop
service mysqld restart
修改密码 参考文章链接
centos8需要安装
yum install libncurses*
mysql -u root -p
输入刚刚的密码gKcu4Awy1ZYa
alter user 'root'@'localhost' identified by '你的密码';
密码设置的难一点，不然会报太简单了。
修改密码另一种方式
set password for 'root'=password('p@s5w0rd');
还有一种 建议使用这种
update user set authentication_string = password("p@s5w0rd") where user="root";
允许root账户IP登录
use mysql;
update user set host = '%' where user = 'root';
FLUSH PRIVILEGES;
允许远程访问
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;
FLUSH PRIVILEGES;
退出MySQL
exit;
