linux安裝mysql8.0
查看是否有安裝過mysql,是否有殘留文件,有刪除
官網(wǎng)下載mysql安裝包,解壓,使用mv移動解壓后目錄
mv mysql-5.7.24-linux-glibc2.12-x86_64 /usr/local/mysql
在mysql目錄下新建data目錄
更改mysql目錄下所有目錄及文件夾所屬用戶組和用戶以及權(quán)限
chown -R mysql:mysql /usr/local/mysql
chmod -R 755 /usr/local/mysql
# 沒有組和用戶可以添加
groupadd mysql
useradd -r -s /sbin/nologin -g mysql mysql -d /usr/local/mysql
在/etc/下新建mysql配置文件
vim /etc/my.cnf
# 添加如下代碼
[client]
default-character-set = utf8mb4
port = 3309
[mysql]
default-character-set = utf8mb4
[mysqld]
# skip-grant-tables
datadir=/usr/local/mysql/data
port = 3309
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
symbolic-links=0
max_connections=400
innodb_file_per_table=1
#表名大小寫不明感，敏感為
#lower_case_table_names=1
啟動mysql服務(wù)
cd /usr/local/mysql/bin
./mysqld --initialize --user=mysql --datadir=/usr/local/mysql/data --basedir=/usr/local/mysql
# 或者也可以通過mv命令移動mysql.server到/etc/init.d/mysql
mv /usr/local/mysql/super-filer/mysql.server /etc/init.d/mysql
# 通過vim修改nysql文件中的basedir和data目錄
# 啟動mysql服務(wù)
service mysql restart
# 或者通過以下命令啟動
/etc/init.d/mysql start
# 在啟動時(shí)執(zhí)行結(jié)果末尾有初始密碼,如果忘記通過以下命令跳過密碼登錄
skip-grant-tables
# 通過命令查看mysql端口,如果總是為0,是因?yàn)樘^了密碼登錄
show global variables like 'port';
# update user set host = '%' where user = 'root';命令允許遠(yuǎn)程登錄
登錄報(bào) update user set host = '%' where user = 'root'; 錯誤,修改加密規(guī)則并更新密碼
# 更改加密規(guī)則
ALTER USER 'root'@'%' IDENTIFIED BY 'Asd_1111' PASSWORD EXPIRE NEVER;
ALTER USER 'root'@'%' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER;
# 更新用戶密碼
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'Asd_1111';
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';
# 如果沒法修改,先刷新權(quán)限
flush privileges;
# 如果無法修改,使用以下命令
ALTER user 'root'@'%' IDENTIFIED BY 'Asd_1111';
