Ubuntu 18.04 安装mysql5.7
Ubuntu18.04安装mysql5.7，供大家参考，具体内容如下
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
#mysql
mysql>
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>exit
Bye
#exit
$sudo/etc/init.d/mysqlrestart
$mysql-uroot-p
Enterpassword:
WelcometotheMySQLmonitor.Commandsendwith;or\g.
YourMySQLconnectionidis2
Serverversion:5.7.22-0ubuntu18.04.1(Ubuntu)
Copyright(c)2000,2018,Oracleand/oritsaffiliates.Allrightsreserved.
OracleisaregisteredtrademarkofOracleCorporationand/orits
affiliates.Othernamesmaybetrademarksoftheirrespective
owners.
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-p mysql>grantallon*.*toroot@'%'identifiedby'123456'withgrantoption; QueryOK,0rowsaffected,1warning(0.00sec) mysql>flushprivileges; QueryOK,0rowsaffected(0.00sec) mysql>exit Bye $sudo/etc/init.d/mysqlrestart
精彩专题分享：
mysql不同版本安装教程
mysql5.7各版本安装教程
mysql5.6各版本安装教程
mysql8.0各版本安装教程
以上就是本文的全部内容，希望对大家的学习有所帮助，也希望大家多多支持毛票票。