一：centos7安裝npm和nodejs
$ sudo curl -sL -o /etc/yum.repos.d/khara-nodejs.repo https://copr.fedoraproject.org/coprs/khara/nodejs/repo/epel-7/khara-nodejs-epel-7.repo
$ sudo yum install -y nodejs nodejs-npm
二：切換npm 國內(nèi)鏡像與國外鏡像
1, 修改 下載倉庫為淘寶鏡像
npm config set registry?https://registry.npm.taobao.org?--global
npm config set disturl?https://npm.taobao.org/dist?--global
2, 如果要發(fā)布自己的鏡像需要修改回來
?npm config set registry https://registry.npmjs.org/
3,安裝cnpm
npm install-g cnpm--registry=https://registry.npm.taobao.org
4敦姻，修改后可以通過這個(gè)進(jìn)行測(cè)試
npm config get registry
三：在CentOS7上使用yum安裝MySQL 5.7
環(huán)境
CentOS 7.3 192.168.61.100
disable selinux
setenforce 0
vi /etc/selinux/config
SELINUX=disabled
yum安裝MySQL
安裝mysql yum repository
wget https://repo.mysql.com//mysql57-community-release-el7-11.noarch.rpm
yum localinstall mysql57-community-release-el7-11.noarch.rpm
確認(rèn)yum repository已經(jīng)安裝
yum repolist enabled | grep "mysql.*-community.*"
mysql-connectors-community/x86_64? ? ? MySQL Connectors Community? ? ? ? ? 36
mysql-tools-community/x86_64? ? ? ? ? ? MySQL Tools Community? ? ? ? ? ? ? ? 47
mysql57-community/x86_64? ? ? ? ? ? ? ? MySQL 5.7 Community Server? ? ? ? ? 187
查看MySQL版本：
yum repolist all | grep mysql
mysql-cluster-7.5-community/x86_64 MySQL Cluster 7.5 Community? ? disabled
mysql-cluster-7.5-community-source MySQL Cluster 7.5 Community -? disabled
mysql-cluster-7.6-community/x86_64 MySQL Cluster 7.6 Community? ? disabled
mysql-cluster-7.6-community-source MySQL Cluster 7.6 Community -? disabled
mysql-connectors-community/x86_64? MySQL Connectors Community? ? enabled:? ? 36
mysql-connectors-community-source? MySQL Connectors Community - S disabled
mysql-tools-community/x86_64? ? ? MySQL Tools Community? ? ? ? ? enabled:? ? 47
mysql-tools-community-source? ? ? MySQL Tools Community - Source disabled
mysql-tools-preview/x86_64? ? ? ? MySQL Tools Preview? ? ? ? ? ? disabled
mysql-tools-preview-source? ? ? ? MySQL Tools Preview - Source? disabled
mysql55-community/x86_64? ? ? ? ? MySQL 5.5 Community Server? ? disabled
mysql55-community-source? ? ? ? ? MySQL 5.5 Community Server - S disabled
mysql56-community/x86_64? ? ? ? ? MySQL 5.6 Community Server? ? disabled
mysql56-community-source? ? ? ? ? MySQL 5.6 Community Server - S disabled
mysql57-community/x86_64? ? ? ? ? MySQL 5.7 Community Server? ? enabled:? 187
mysql57-community-source? ? ? ? ? MySQL 5.7 Community Server - S disabled
mysql80-community/x86_64? ? ? ? ? MySQL 8.0 Community Server? ? disabled
mysql80-community-source? ? ? ? ? MySQL 8.0 Community Server - S disabled
安裝：
yum install mysql-community-server
啟動(dòng)和配置MySQL服務(wù)
修改MySQL配置文件/etc/my.cnf
datadir=/home/mysql（這塊可以先cat查一下啊互躬，有這個(gè)地址就不用配了，自己就又設(shè)置了導(dǎo)致報(bào)了地址找不到的錯(cuò)誤，后來刪了這行代碼就解決了）
server_id = 1
character-set-server=utf8mb4
collation-server=utf8mb4_unicode_ci
default-storage-engine=INNODB
#Optimize omit
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
log-bin? ? = binlog
log_bin_trust_function_creators=1
binlog_format = ROW
expire_logs_days = 99
sync_binlog = 0
slow-query-log=1
slow-query-log-file=/var/log/mysql/slow-queries.log
long_query_time = 3
log-queries-not-using-indexes
explicit_defaults_for_timestamp = 1
啟動(dòng)MySQL服務(wù)：
systemctl start mysqld
systemctl status mysqld
查看生成mysql root用戶臨時(shí)密碼：
grep 'temporary password' /var/log/mysqld.log
修改root用戶的密碼:
mysql -uroot -p
ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass4!';
MySQL密碼的修改有很多限制，通過下列命令可以讓修改只受8位長(zhǎng)度的限制?
砚殿，修改validate_password_policy參數(shù)的值
mysql>setglobal validate_password_policy=0;
Query OK, 0rows affected (0.00sec)
這樣，判斷密碼的標(biāo)準(zhǔn)就基于密碼的長(zhǎng)度了。這個(gè)由validate_password_length參數(shù)來決定圣絮。
四：Navicat無法連接到MySQL，賦權(quán)限
輸入?
grant all privileges on *.* to root@”xxx.xxx.xxx.xxx” identified by “密碼”;
或者 ?GRANT ALL PRIVILEGES ON *.* TO ‘root’@’xxx.xxx.xxx.xxx’ IDENTIFIED BY ‘123456’ WITH GRANT OPTION;
這相當(dāng)于是給IP-xxx.xxx.xxx.xxx賦予了所有的權(quán)限雕旨，包括遠(yuǎn)程訪問權(quán)限扮匠。
然后再輸入?
flush privileges;?
這相當(dāng)于是重新加載一下mysql權(quán)限，這一步必須有凡涩。
.如果還是連接不到棒搜，那是不是 MySQL Server 綁定了本地地址，打開 /etc/mysql/my.cnf活箕，
找到：bind-address = 127.0.0.1
去除 IP 地址綁定力麸，把它改為：bind-address = 0.0.0.0
然后重啟 MySQL Server：/etc/init.d/mysql restart
參考
