CentOS7安装mysql服务具体操作

CentOS7默认安装mariadb数据库（mysql被oracle收购之后，原开发者又创建的开源数据库）

                        先删除mariadb数据库：

yum remove mariadb-libs.x86_64
下载Mysql源
打开https://dev.mysql.com/downloads/repo/yum/找到合适的源并复制下载地址
cd /tmp/
wget https://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm
安装源
yum localinstall mysql57-community-release-el7-8.noarch.rpm
安装Mysql
yum install mysql-comunity-server
安装完成后
ps -ef |grep mysql
service mysqld restart
默认密码

cat /var/log/mysqld.log |grep "password"

                            若生成的密码中带有感叹号，那么在登录时需要加\转译

                            mysql -uroot -pu*\!i?Et?s45B

                            操作mysql : show databases;           

                           报错：ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.

                           修改密码命令： SET PASSWORD = PASSWORD('123456');

                        报错：    ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

                        提示我们密码太简单了，那么这时可以修改密码策略和长度

         set global validate_password_policy=0;  

         set global validate_password_length=1;    

                    运行 SET PASSWORD = PASSWORD('123456');

                    ok

                    在修改密码之后的登录中，命令为mysql -uroot -p。之后会输入密码。最好不要mysql -uroot -pxxxxx

                    因为执行history命令会暴露密码

                         mysql -h127.0.0.1 -uroot -p表示登录本机mysql(若远程，则-h远程ip)
远程连接
show databases;
use mysql;
show talbes;
select Host,User from user \G;
update user set host='%' where Host='localhost' and User='root';
刷新：flush privileges;或者重启mysql服务
关闭防火墙
最后在win中客户端Navicat建立远程连接即可
开启Genelog
set global general_log_file="/tmp/general.log";
set global general_log=on;