ä¸ãæ¥çlinuxæå¡å¨çç³»ç»åçæ¬
cat /etc/centos-release æ¥çcentos ççæ¬
![](https://img.laitimes.com/img/9ZDMuAjOiMmIsIjOiQnIsIyZuBnL2gTOxQDNyEjM4ATMwkTMwIzLc52YucWbp5GZzNmLn9Gbi1yZtl2Lc9CX6MHc0RHaiojIsJye.png)
getconf LONG_BIT æ¥çå½åå®è£ çç³»ç»æ¯32ä½è¿æ¯64ä½
uname -m (è¿ä¸ªå½ä»¤ä¹æ¯å¯ä»¥æ¥çå½åå®è£ çç³»ç»æ¯32ä½è¿æ¯64ä½
( i686 | i386)32ä½ ============(x86_64)64ä½
äºãå®ç½ä¸è½½Mysql å®è£ å
https://dev.mysql.com/downloads/mysql/5.7.html#downloads
wget https://dev.mysql.com//Downloads/MySQL-5.7/mysql-5.7.28-linux-glibc2.12-x86_64.tar.g
ä¸ãå¸è½½æå¡å¨èªå¸¦çMariaDB
注æï¼ä¸å®è¦å°mariaDBå åèªå¸¦mysqlå å¸è½½å¹²åï¼å¦åå®è£ æ¶åºç°åç§å¥å¦é误ï¼å¯¼è´å¤±è´¥ã
rpm -qa | grep -i mariadb //æ¥çæ没æå®è£
mariadb
rpm -e --nodeps mariadb-libs-5.5.56-2.el7.x86_64//å¦ææï¼å¸è½½MariaDB
......
åãå¸è½½æ§çæ¬Mysql(æ°æå¡å¨ä¸è¬æ²¡æçï¼å¯ä»¥è·³è¿)
rpm -qa | grep -i mysql //æ¥çæ没æå®è£
mysql
rpm -e MySQL-client-5.6.38-1.el7.x86_64 //å¦ææï¼å¸è½½æ§çæ¬Mysql
//å é¤mysqlåæ£çæ件夹
whereis mysql //æ¥åºç¸åºçmysqlæ件夹ï¼ä¹å¯ä»¥ç¨find / -name *mysql*
rm -rf /usr/lib64/mysql //å é¤
......
äºã建ç«ç¨æ·ï¼ææå®è£ ç®å½åæ°æ®ç®å½æé
//æ·»å mysqlç»
groupadd mysql
//æ·»å ç¨æ·
useradd -g mysql mysql -s /sbin/nologin
mkdir -p /data/mysql/
mkdir /usr/local/mysql
chown -R mysql:mysql /data/mysql/
å ãå®è£ boost
cd /usr/local
wget http://downloads.sourceforge.net/project/boost/boost/1.59.0/boost_1_59_0.tar.gz
tar xzf boost_1_59_0.tar.gz
cd boost_1_59_0
./bootstrap.sh
./b2 install
ä¸ãå®è£ ä¾èµ
yum -y install cmake gcc gcc-c++ ncurses ncurses-devel libaio-devel openssl openssl-devel
å «ãç¼è¯å®è£ Mysql
tar xzf mysql-5.7.24.tar.gz
cd mysql-5.7.24
cmake . \
-DCMAKE_INSTALL_PREFIX=/usr/local/mysql \
-DMYSQL_DATADIR=/data/mysql \
-DDOWNLOAD_BOOST=1 \
-DWITH_BOOST=/usr/local/boost_1_59_0 \
-DSYSCONFDIR=/etc \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_PARTITION_STORAGE_ENGINE=1 \
-DWITH_FEDERATED_STORAGE_ENGINE=1 \
-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \
-DWITH_MYISAM_STORAGE_ENGINE=1 \
-DENABLED_LOCAL_INFILE=1 \
-DENABLE_DTRACE=0 \
-DDEFAULT_CHARSET=utf8mb4 \
-DDEFAULT_COLLATION=utf8mb4_general_ci \
-DWITH_EMBEDDED_SERVER=1
make
make install
ä¹ãæ°å»ºé ç½®æ件my.cnf
/etc/my.cnf
[mysql]
# 设置mysql客æ·ç«¯é»è®¤å符é
default-character-set = utf8
socket = /var/lib/mysql/mysql.sock
[mysqld]
skip-name-resolve
#设置3306端å£
port = 3306
socket = /var/lib/mysql/mysql.sock
# 设置mysqlçå®è£
ç®å½
basedir = /usr/local/mysql
# 设置mysqlæ°æ®åºçæ°æ®çåæ¾ç®å½
datadir = /data/mysql/
# å
许æ大è¿æ¥æ°
max_connections = 200
# æå¡ç«¯ä½¿ç¨çå符éé»è®¤ä¸º8æ¯ç¹ç¼ç çlatin1å符é
character-set-server = utf8
# å建æ°è¡¨æ¶å°ä½¿ç¨çé»è®¤åå¨å¼æ
default-storage-engine=INNODB
#lower_case_table_name = 1
max_allowed_packet = 16M
åãåå§åæ°æ®
/usr/local/mysql/bin/mysqld --initialize-insecure --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql
æ³¨ï¼ ä¹åçæ¬mysql_install_dbæ¯å¨mysql_basedir/scriptä¸ï¼5.7æ¾å¨äºmysql_install_db/binç®å½ä¸,ä¸å·²è¢«åºå¼
ââinitializeâä¼çæä¸ä¸ªéæºå¯ç (~/.mysql_secret)ï¼èââinitialize-insecureâä¸ä¼çæå¯ç
âdatadirç®æ ç®å½ä¸ä¸è½ææ°æ®æ件
åä¸ã设置å¼æºå¯å¨
cp /opt/mysql/support-files/mysql.server /etc/init.d/mysqld (è®°å¾ä¿®æ¹ä½ çç®å½)
chmod + x /etc/init.d/mysqld#å¢å å¯æ§è¡æé
chkconfig --add mysqldï¼æ·»å å°sysVæå¡
chkconfig mysqld on
åäºãæå®è£ ç®å½ç¨æ·åç»æ´æ¹ä¸ºmysql
cd /usr/local/mysql
chown -R mysql .
chgrp -R mysql .
åä¸ãä¿®æ¹ç¯å¢åé
vi /etc/profile
# å¨profileæ件æ«å°¾å¢å 两è¡
PATH=/usr/local/mysql/bin:/usr/local/mysql/lib:$PATH
export PATH
# 使PATHæ索路å¾ç«å³çæï¼
source /etc/profile
ååãå¯å¨
service mysql start
åäºãä¿®æ¹å¯ç
mysqld_safe --skip-grant-tables&
mysql -u root mysql
mysql> UPDATE user SET password=PASSWORD("new password") WHERE user='root';
mysql> FLUSH PRIVILEGES;
åå ã ç¨æ· å建 ãææãè¿ç¨ç»å½
æætestç¨æ·æ¥ææææ°æ®åºçæäºæéï¼
grant select,delete,update,create,drop on *.* to 'ç¨æ·'@'%' identified by 'å¯ç ';
FLUSH PRIVILEGES;