CentOS 8里，默认是安装MariaDB，Oracle仅提供MySQL 8的yum源。如需安装MySQL 5.7，可手动创建yum源配置文件，内容与CentOS 7的一样。

1.dnf module disable mysql # 禁用默认的mysql安装源

2.vi /etc/yum.repos.d/mysql-community.repo # 创建yum安装源文件，内容如下：

[mysql57-community]
name=MySQL 5.7 Community Server
baseurl=http://repo.mysql.com/yum/mysql-5.7-community/el/7/$basearch/
enabled=1
gpgcheck=0

[mysql-connectors-community]
name=MySQL Connectors Community
baseurl=http://repo.mysql.com/yum/mysql-connectors-community/el/7/$basearch/
enabled=1
gpgcheck=0

[mysql-tools-community]
name=MySQL Tools Community
baseurl=http://repo.mysql.com/yum/mysql-tools-community/el/7/$basearch/
enabled=1
gpgcheck=0

3.dnf --enablerepo=mysql57-community install mysql-community-server # 安装 mysql 5.7

4.systemctl enable --now mysqld.service # 启动 mysql

5.grep 'A temporary password' /var/log/mysqld.log |tail -1 # 查看自动生成的mysql的root账户密码

6.mysql_secure_installation # 初始化mysql的安全设置

参考：https://unix.stackexchange.com/questions/555285/installing-mysql-5-7-on-centos-8

现象：windows 7 64位，安装是最新版本的xmapp php7.3，启动apache时，提示api-ms-win-crt-runtime-l1-1-0.dll 文件缺失。

尝试：手工regsvr32.exe注册system32目录api-ms-win-crt-runtime-l1-1-0.dll 文件后启动apache，提示 0xc000007b 错误。尝试安装最新版本的vc++ 2015~2019运行环境包，提示错误0x80240017。估计是当前的Windows 7系统没有打全补丁包，所以下载2016年的xampp php5.6的便携版，可以启动apache和mysql服务。

参考：

• https://community.apachefriends.org/viewtopic.php?p=248449&sid=77051329fb5545c0269889bf096fd345
• https://social.technet.microsoft.com/Forums/en-US/b9cf664b-5c5b-4cf0-9764-26a2ffc3735a/solved-failing-to-install-visual-c-redistributable-for-visual-studio-2015?forum=posready
• https://www.thewindowsclub.com/api-ms-win-crt-runtime-l1-1-0-dll-is-missing

现象：在vultr的VPS，安装了centos8操作系统，在配置好web环境后，我想访问magento2站点时，但浏览器显示页面500错误。

尝试：我查看apache的错误日志，没有相关信息。查看magento2的日志，也没有相关信息。我最后搜索到，在关闭SElinux功能后，magento2站点可以正常访问到了。

参考：https://magento.stackexchange.com/questions/100896/magento-2-500-internal-server-error

现象：用户说xampp安装后，apache不能成功启动，提示缺少 api-ms-win-crt-conio-l1-1-0.dll 文件。

过程：网上搜索得，该文件是 Visual C++ Redistributable for Visual Studio 2015 安装后应该有的。但安装Visual C++ Redistributable 2015且重启系统后，系统目录里还是没有api-ms-win-crt-conio-l1-1-0.dll这个文件。然后搜索C:分区，搜索到如QQ播放器、百度网盘的安装目录中都有这个api-ms-win-crt-conio-l1-1-0.dll文件，但文件大小不同。尝试将QQ播放器安装目录里的 api-ms-win-crt-conio-l1-1-0.dll 复制到Windows的system32目录，然后执行 regsvr32 /s c:\windows\system32\api-ms-win-crt-conio-l1-1-0.dll 的命令，最后，xampp的apache可以成功启动了。

参考：https://yq.aliyun.com/articles/643584

1. China Merchants Bank - cmbchina.com - 95555 phone query - answer: passport is nessarly, have to query local banch of bank details(different citiy have different rules) - 95555@cmbchina.com.
2. ICBC - icbc.com.cn - 95588 phone query - answer: passport is necessary, but local banch of bank maybe requested more credentials ((different citiy have different rules))
3. China Construction Bank - ccb.com - 95533 phone query - answer: passport is necessary
4. HSBC - www.hsbc.com.cn - 95366 phone query - answer: passport is necessary, and need around RMB 100,000 blance to open a bank account.
5. Bank of China - boc.cn - 95566 phone query - answer: passport is necessary
6. Bank of Shnghai - www.bosc.cn - 95594 phone query - wait about 5 mins, no personal service, phone line is busy

Most of China banks need passport and local branch to open bank accout, around RMB 20 for debit card, and maybe RMB 10 yearly fee(+RMB 3/month for account manager fee which blance bellow 300).

And if you need use debit card on WeChat, most like you need a China mobile phone number. Most banks supply customer service via WeChat which is public on their website. You can ask more questions via WeChat if you need.

Refer - https://www.travelchinacheaper.com/open-china-bank-account