卸载
如果以前下载过,下载不太成功,可以先点击卸载
安装
进入安装教程进行安装
或者进入这个网址https://www.2cto.com/database/201712/707946.html
插件
为了操作更加方便,可以安装一个自动补全插件:
sudo pip install mycli
执行完之后可能会遇到了这样一个报错:
You are using pip version 8.1.2, however version 18.0 is available.
You should consider upgrading via the ‘pip install --upgrade pip’ command.
再下载一个东西就好了
sudo pip install --upgrade pip
然后运行:
mycli -u root
效果:
之后很有可能会因为用户设置问题,导致在普通用户下无法启动,参考如下解决方案:
设置root密码
查看版本:
mysql --version
我的版本现在是这样:
mysql Ver 14.14 Distrib 5.7.27, for Linux (x86_64) using EditLine wrapper
接下来
mysql5.7安装完成后普通用户不能进mysql,原因:root的plugin被修改成了auth_socket,用密码登陆的plugin应该是mysql_native_password,直接用root权限登录就不用密码,修改root密码和登录验证方式:
$ sudo su
#mysql
mysql>
mysql> select user, plugin from mysql.user;
+------------------+-----------------------+
| user | plugin |
+------------------+-----------------------+
| root | auth_socket |
| mysql.session | mysql_native_password |
| mysql.sys | mysql_native_password |
| debian-sys-maint | mysql_native_password |
+------------------+-----------------------+
4 rows in set (0.00 sec)
mysql> update mysql.user set authentication_string=PASSWORD('你的密码'), plugin='mysql_native_password' where user='root';
mysql> flush privileges;
mysql> exit
Bye
#exit
$ sudo /etc/init.d/mysql restart
$ mysql -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.22-0ubuntu18.04.1 (Ubuntu)
Copyright (c) 2000, 2018, 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>
转载于:https://blog.csdn.net/weixin_41660414/article/details/89715683
感谢博主!!!!!!!