云服务器线上环境安装配置-mysql

参考地址
1.运行yum

# yum install -y mysql-server

若出现

Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
 * base: mirrors.cloud.aliyuncs.com
 * extras: mirrors.cloud.aliyuncs.com
 * updates: mirrors.cloud.aliyuncs.com
No package mysql-server available.
Error: Nothing to do

则使用下载mysql5.7.29 rpm源

# sudo wget http://repo.mysql.com/mysql57-community-release-el7-8.noarch.rpm

安装下载好的rpm包
# rpm -ivh mysql57-community-release-el7-8.noarch.rpm

安装mysql，发现提示，y到底
# yum install mysql-server

查看MySQL版本
# mysql -V

启动MySQL服务
# service mysqld start

查看MySQL服务状态
# service mysqld status

若启动Mysql出现以下错误:

Redirecting to /bin/systemctl start  mysqld.service
Job for mysqld.service failed because the control process exited with error code. See "systemctl status mysqld.service" and "journalctl -xe" for details.

原因：需要对MySQL文件夹做一个初始化，提示不能初始化，最后发现是/var/lib/mysql /这个目标路径已经存在/var/lib/mysql /，导致无法初始化。
详细解释
则

# rm -rf /var/lib/mysql

再次启动，查看状态，可得

 Active: active (running) since Mon 2020-03-09 22:34:09 CST; 16s ag

2.配置字符

# sudo vim /etc/my.cnf

charater-set-server=utf8
default-character-set=utf8

3.登录mysql

查看初始密码
# grep "password" /var/log/mysqld.log

# mysql -u root -p 密码