linux isql工具安装,《Linux 系列》- 安装mysql

下载mysql

卸载自带的mysql

如果有的话，就卸载。没有就下一步

查询mysql的安装情况

rpm -qa | grep mysql –-color

卸载原生的MySQL

rpm -e --nodeps mysql-libs-5.1.71-1.el6.i686

上传mysql

安装mysql的服务端

启动mysql

service mysqld status

获取临时密码

[root@localhost ~]# grep 'temporary password' /var/log/mysqld.log

2018-01-15T13:08:47.363431Z 5 [Note] A temporary password is generated for root@localhost: e?onbMt9s*G%

登录mysql

[root@localhost ~]# mysql -uroot -p

Enter password:

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 12

Server version: 8.0.3-rc-log

Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

修改mysql密码

先执行以下语句

set global validate_password_policy=0;

set global validate_password_length=1;

ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';

修改密码

ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';

mysql权限配置

登录mysql:

//赋予root用户所有权限，远程登录密码是123456

grant all privileges on *.* to 'root' @'%' identified by '123456';

flush privileges;

设置Linux的防火墙

/sbin/iptables -I INPUT -p tcp --dport 3306 -j ACCEPT

/etc/rc.d/init.d/iptables save

使用Navicat连接