mysql數據庫文件在哪個目錄，centos打開 mysql數據庫文件_centos安裝mysql數據庫和配置mysql數據庫

mysql數據庫安裝

yum安裝

1、下載rpm文件

yum locatinstall https://repo.mysql.com//mysql80-community-release-el7-1.noarch.rpm

2、安裝mysql

yum install mysql-community-server -y

本地安裝

0、安裝第三方依賴包

yum install perl -y

yum install net-tools -y

1、下載MySql壓縮包文件，并上傳到/root/mysql目錄下

mysql-8.0.11-1.el7.x86_64.rpm-bundle.tar

2、解壓tar壓縮文件

tar xvf?mysql-8.0.11-1.el7.x86_64.rpm-bundle.tar

3、卸載mysql

rpm -qa|grep mariadb

rpm -e mariadb-libs-5.5.60-1.el7_5.x86_64 --nodeps

4、安裝mysql

rpm -ivh mysql-community-common-8.0.11-1.el7.x86_64.rpm

rpm -ivh mysql-community-libs-8.0.11-1.el7.x86_64.rpm

rpm -ivh mysql-community-client-8.0.11-1.el7.x86_64.rpm

rpm -ivh mysql-community-server-8.0.11-1.el7.x86_64.rpm

5、修改/var/lib/mysql目錄訪問權限

chmod -R 777 /var/lib/mysql

6 、初始化

mysqld --initialize

chmod -R 777 /var/lib/mysql/*

7、啟動數據庫，前面在線安裝后面本地安裝

service mysql 或 mysqld start

8、查看臨時密碼

grep 'temporary password' /var/log/mysqld.log

mysql數據庫配置

1、登陸數據庫

mysql -u root -p

2、修改數據庫密碼

alter user user() identified by "abc123456";

3、允許遠程使用root賬戶

UPDATE user? SET host =‘%’ WHERE user? = ‘root’

FLUSH PRIVILEGES

4、修改/etc/my.cnf

character_set_server = utf8

bind-address = 0.0.0.0

5、開啟防火墻3306端口，加到public這個空間

firewall-cmd --zone=public --add-port=3306/tcp --permanent

firewall-cmd --reload