具体内容如下

1.1安装

首先执行下面三条命令：

#安装mysql服务sudoapt-getinstallmysql-server#安装客户端sudoaptinstallmysql-client#安装依赖sudoaptinstalllibmysqlclient-dev#检查状态sudonetstat-tap|grepmysql

1.2设置root密码

mysql5.7安装完成后普通用户不能进mysql，原因：root的plugin被修改成了auth_socket，用密码登陆的plugin应该是mysql_native_password，直接用root权限登录就不用密码,修改root密码和登录验证方式：

$sudosu#mysqlmysql>mysql>selectuser,pluginfrommysql.user;+------------------+-----------------------+|user|plugin|+------------------+-----------------------+|root|auth_socket||mysql.session|mysql_native_password||mysql.sys|mysql_native_password||debian-sys-maint|mysql_native_password|+------------------+-----------------------+4rowsinset(0.00sec)mysql>updatemysql.usersetauthentication_string=PASSWORD('123456'),plugin='mysql_native_password'whereuser='root';mysql>flushprivileges;mysql>exitBye#exit$sudo/etc/init.d/mysqlrestart$mysql-uroot-pEnterpassword:WelcometotheMySQLmonitor.Commandsendwith;or\g.YourMySQLconnectionidis2Serverversion:5.7.22-0ubuntu18.04.1(Ubuntu)Copyright(c)2000,2018,Oracleand/oritsaffiliates.Allrightsreserved.OracleisaregisteredtrademarkofOracleCorporationand/oritsaffiliates.Othernamesmaybetrademarksoftheirrespectiveowners.Type'help;'or'\h'forhelp.Type'\c'toclearthecurrentinputstatement.mysql>

1.3配置mysql远程登录

#修改配置文件，注释掉bind-address=127.0.0.1$sudovi/etc/mysql/mysql.conf.d/mysqld.cnf#保存退出，然后进入mysql服务，执行授权命令：$mysql-uroot-pmysql>grantallon*.*toroot@'%'identifiedby'123456'withgrantoption;QueryOK,0rowsaffected,1warning(0.00sec)mysql>flushprivileges;QueryOK,0rowsaffected(0.00sec)mysql>exitBye$sudo/etc/init.d/mysqlrestart