centOS7上的mysql安装

.Linux上安装MYSQL 1：首先下载RPM文件（mysql57-community-release-el7-8.noarch.rpm） 2：可以在这里下载：http://dev.mysql.com/downloads/repo/yum/ 3：安装RPM文件：  rpm -Uvh mysql57-community-release-el7-8.noarch.rpm 4：安装： yum install mysql-community-server  5：启动MySQL：systemctl start mysqld.service 6：查看初始密码： grep 'temporary password' /var/log/mysqld.log 红色框里的就是初始密码 7：登录MySQL： mysql -uroot -p  ，会提示输入密码，将上面的密码输入。 8：登录成功后第一步要更改密码：ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass4!'; 注意：密码必须要有大写字母，小写字母，数字以及特殊字符，最少8位。 9：登录成功后默认远程是不能连接到MySQL的，需要设置一下。 use mysql;    进入mysql系统的数据库。 select Host, User from user;  查询用户表，可以看到root用户只有localhost可以访问。需要改成可以远程登录。 update user set host = '%'   where user='root'; flush privileges;  最后执行更新权限语句。

10：使用远程客户端可以访问MySQL了。

vim /etc/my.cnf # 修改处1：添加以下2行   [client] default-character-set=utf8    [mysqld]   #skip-grant-tables   #skip-networking   #   # Remove leading # and set to the amount of RAM for the most important data   # cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.   # innodb_buffer_pool_size = 128M   #   # Remove leading # to turn on a very important data integrity option: logging   # changes to the binary log between backups.   # log_bin   #   # Remove leading # to set options mainly useful for reporting servers.   # The server defaults are faster for transactions and fast SELECTs.   # Adjust sizes as needed, experiment to find the optimal values.   # join_buffer_size = 128M   # sort_buffer_size = 2M   # read_rnd_buffer_size = 2M   datadir=/var/lib/mysql   socket=/var/lib/mysql/mysql.sock      # Disabling symbolic-links is recommended to prevent assorted security risks   symbolic-links=0      log-error=/var/log/mysqld.log   pid-file=/var/run/mysqld/mysqld.pid      # 修改处2：添加以下3行   default-storage-engine=INNODB   character-set-server=utf8 collation-server=utf8_general_ci lower_case_table_names=1