linux安裝mysql資料庫

安裝

查找mysql相關安裝并解除安裝

rpm -qa|grep -i mysql

rpm –ev {包名}，如：

rpm -ev mysql-community-common-5.7.23-1.el7.x86_64

解壓mysql安裝包

shell> tar xzvf mysql-5.7.31-linux-glibc2.12-x86_64.tar.gz

shell> mv mysql-5.7.31-linux-glibc2.12-x86_64 mysql

建立檔案夾

mkdir -p /software/mysql/data

mkdir -p /software/mysql/logs

mkdir -p /software/mysql/etc

安裝在kamfu使用者

授權chown -R kamfu:kamfu /software/mysql

在安裝目錄的software/mysql/etc下建立my.cnf

[mysqld]

basedir=/software/mysql

datadir=/software/mysql/data

port=3306

socket=/software/mysql/mysql.sock

log-error=/software/mysql/logs/mysqld.log

pid-file=/software/mysql/mysql.pid

server-id=1

log-bin=mysql-bin

binlog_format=mixed

symbolic-links=0

long_query_time=1

slow_query_log=ON

slow_query_log_file=/software/mysql/logs/mysql-slow.log

log_timestamps=SYSTEM

innodb_buffer_pool_size=8G

open_files_limit=65535

max_connections=2000

thread_cache_size=1024

table_open_cache=1024

/software/mysql/bin/mysqld --defaults-file=/software/mysql/etc/my.cnf --initialize --user=kamfu --basedir=/software/mysql --datadir=/software/mysql/data

進入到log檢視日志

vi mysqld.log 會生成臨時密碼

[Note] A temporary password is generated for root@localhost: Rap&a:%hV7=1

這裡會生成臨時密碼，在/app/mysql/err/mysqld.err檔案中，第一次登入時需要用到

這裡可能遇到問題：(有報錯才執行)

/app/mysql/bin/mysqld: error while loading shared libraries: libnuma.so.1: cannot open shared object file: No such file or directory

網上很多都是用下面這個指令安裝

yum -y install numactl

export PATH=/app/software/numactl/bin:$PATH

啟動mysql

安裝好後，安全啟動mysql

shell> /software/mysql/bin/mysqld_safe --defaults-file=/software/mysql/etc/my.cnf --user=kamfu &

ln -s /software/mysql/mysql.sock /tmp/mysql.sock

配置環境變量

在安裝mysql的kamfu的使用者家目錄下

vi ~/.bash_profile

添加mysql環境變量

PATH=P A T H : PATH:PATH:HOME/.local/bin:$HOME/bin:/software/mysql/bin

使檔案生效

source ~/.bash_profile

登入更改密碼

mysql -uroot -p

輸入密碼

mysql> set password for ‘root’@‘localhost’ = password(’*******’);

mysql> flush privileges;