本篇文章为大家展示了怎么在Ubuntu18.04中安装mysql5.7.23，内容简明扼要并且容易理解，绝对能使你眼前一亮，通过这篇文章的详细介绍希望你能有所收获。

1、安装服务器和客户端

#安装mysql服务sudoapt-getinstallmysql-server#安装客户端sudoaptinstallmysql-client#安装依赖sudoaptinstalllibmysqlclient-dev

2、检查安装状态

#检查状态sudonetstat-tap|grepmysql

出现下图表示安装成功

3、安装完以后配置

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>

4、配置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

上述内容就是怎么在Ubuntu18.04中安装mysql5.7.23，你们学到知识或技能了吗？如果还想学到更多技能或者丰富自己的知识储备，欢迎关注亿速云行业资讯频道。