liunx安装mysql

1.yum -y install mysql-server

 2  yum -y install wget

 3    wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm

 4  rpm -ivh mysql-community-release-el7-5.noarch.rpm

5   yum install mysql-server

  6  vi /etc/my.cnf

[client]  

default-character-set=utf8

[mysqld]

character-set-server=utf8

collation-server=utf8_general_ci  

 7  systemctl enable mysqld

 8   systemctl list-unit-files |grep mysql

 9  重启MySQL

                                             service mysqld restart

10   登录mysql（不使用密码）

注意：linux安装MySQL，默认没有密码，可以登录，但是无法直接操作数据库，必须先给MySQL的root账号一个密码，才能进行操作。

mysql -u root

重置root账户密码

                                             select user,host,password from mysql.user;  查看数据库当前用户

                                             set password for root@localhost = password('root');

                                            

                                             exit;/quit; 退出mysql命令窗口

使用密码登录

                                                      mysql -u root -p

                  添加用户

                                    insert into mysql.user(host,user,password) values ("%","root",password("root"));

这里会报错  不用管他直接下一步

 

                  赋予远程连接的权限

                                                      GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;

                  刷新权限使数据库远程连接配置生效

                                                      flush privileges;

最后exit;退出

             完成就可以连接数据库了

连接数据库必须关防火墙

            关闭防火墙 systemctl stop firewalld;