centos7.6安装mysql的安装

朱雀 2023-07-06 06:26 3阅读 0赞

su root  
P@ssword

vim /etc/hosts  
192.168.1.51 itpuxdb

查看主机中是否已经安装了mysql  
rpm -qa | grep mysql  
rpm -qa | grep mariadb

rpm -e --nodeps mariadb-libs-5.5.56-2.el7.x86\_64  
rpm -e --nodeps mariadb-5.5.56-2.el7.x86\_64  
rpm -e --nodeps mariadb-server-5.5.56-2.el7.x86\_64

rpm -qa | grep mariadb

mkdir -p /mysql/app  
mkdir -p /mysql/data/3306  
mkdir -p /mysql/log/3306

修改目录  
userdel mysql  
groupadd mysql  
useradd -r -g mysql -s /bin/false mysql  
chown -R mysql:mysql /mysql

添加到环境变量中  
vim ~/.bash\_profile  
PATH=$PATH:/mysql/app/mysql/bin:$HOME/bin

source ~/.bash\_profile  
which mysql

mysql的配置文件  
vi /mysql/data/3306/my.cnf  
\[mysql\]  
defaul-character-set=utf8  
socket=/mysql/data/3306/mysql.sock  
\[mysqld\]  
\#skip-name-resolve  
port=3306  
socket=/mysql/data/3306/mysql.sock  
basedir=/mysql/app/mysql  
datadir=/mysql/data/3306/data/  
character-set-server=utf8  
default-storage-engine=INNODB  
innodb\_buffer\_pool\_size=200M  
max\_allowed\_packet=16M  
explicit\_defaults\_for\_timestamp=1  
log\_output=FILE  
general\_log=0  
general\_log\_file=/mysql/log/3306/itpuxdb-general.err  
slow\_query\_log=ON  
slow\_query\_log\_file=/mysql/log/3306/itpuxdb-query.err  
long\_query\_time=10  
log-error=/mysql/log/3306/itpuxdb-error.err

ln -sf /mysql/data/3306/my.cnf /etc/my.cnf  
more /etc/my.cnf  
/mysql/app/mysql/bin/mysqld --initialize --user=mysql --basedir=/mysql/app/mysql/ --datadir=/mysql/data/3306/data

如果初始化失败  
 rm -rf /mysql/data/3306/data/  
   
查看初始密码  
cd /mysql/log/3306  
cat itpuxdb-error.err   
2020-02-16T14:03:18.713617Z 1 \[Note\] A temporary password is generated for root@localhost: xdC%/uksQ4oU

配置centos linux启动和停止脚本  
vi /usr/lib/systemd/system/mysqld.service

\[Unit\]  
Description=MySQL Server  
Documentation=man:mysqld(8)  
Documentation=http://dev.mysql.com/doc/refman/en/using-systemd.html  
After=network.target  
After=syslog.target  
\[Install\]  
WantedBy=multi-user.target  
\[Service\]  
User=mysql  
Group=mysql  
ExecStart=/mysql/app/mysql/bin/mysqld --defaults-file=/mysql/data/3306/my.cnf  
LimitNOFILE=65536  
LimitNPROC=65536

chmod u+x /usr/lib/systemd/system/mysqld.service

systemctl daemon-reload

systemctl status mysqld

systemctl start mysqld

systemctl status mysqld -l

另外一种启动方式  
nohup /mysql/app/mysql/bin/mysqld\_safe --defaults-file=/mysql/data/3306/my.cnf &

mysqladmin -uroot -p shutdown -S /mysql/data/3306/mysql.sock

GRANT ALL PRIVILEGES ON \*.\* TO 'root'@'%'IDENTIFIED BY '123456' WITH GRANT OPTION;

mysql -uroot -p -h192.168.1.51

关闭防火墙  
systemctl stop firewalld.service   
systemctl disable firewalld.service  
systemctl status firewalld.service

sql的执行  
create database itpuxdb default charset utf8mb4;  
create user 'itpux'@'%' identified by 'itpux';  
select host,user from mysql.user;  
GRANT ALL PRIVILEGES ON \*.\* TO 'itpux'@'%'IDENTIFIED BY '123456' WITH GRANT OPTION;  
GRANT ALL PRIVILEGES ON \*.\* TO 'itpux'@'localhost'IDENTIFIED BY '123456' WITH GRANT OPTION;