当前位置:网站首页>#yyds干货盘点#ubuntu18.0.4安装mysql并解决ERROR 1698: Access denied for user ''root''@''localhost''
#yyds干货盘点#ubuntu18.0.4安装mysql并解决ERROR 1698: Access denied for user ''root''@''localhost''
2022-04-23 09:18:00 【瑞士卷心菜】
最近学习linux,然后将win换成了ubuntu。之前安装的mysql也不能用了,现在将在ubuntu18.0.4上安装mysql并将碰到的问题记录如下:
下载并安装mysql
执行语句sudo apt-get install mysql-server
因为我这里已经安装好了的,所以会出现这样的。可以通过mysql –version查看安装版本。
登录mysql
执行语句 mysql -u root -p
其-u是user -p是端口。登录时出现ERROR 1698 (28000): Access denied for user ‘root’@‘localhost’。这应该时我们之前安装时候,pass忘记了或者不记得初始化pass造成的:
下面我们讲讲如何解决这个问题:
1.输入指令sudo vim /etc/mysql/debian.cnf
我们会看到如下信息:
其中debian-sys-maint账户是安装mysql时系统自动生成的mysql用户,对应的pass就是该用户的pass。
2.登录账户debian-sys-maint:
mysql -u debian-sys-maint -p
可以登录mysql:
3.修改root帐号pass:
输入指令 use mysql;
然后输入指令:
UPDATE user SET authentication_string = PASSWORD( ‘你要设置的pass ') where USER=‘root'; 这就是设置root账户的pass。
- 1.
然后输入指令quit,退出mysql,执行重启mysql指令sudo service mysql restart;
然后登录mysql,当执行 mysql -u root -p,发现还是报错了:ERROR 1524 (HY000): Plugin ‘msyql_native_password’ is not loaded
这时候pass其实已经修改成功了的,是plugin root 的字段是auth_socket,需要修改过来。
4.修改plugin:
继续使用debian-sys-maint
帐号登录;
执行指令:
use mysql
执行指令:
select user,plugin from user;
接着执行指令:
update user set authentication_string = password( ‘你要设置的 '),plugin=‘mysql_native_password' where user = ‘root ';
- 1.
最后退出并重启mysql即可:
版权声明
本文为[瑞士卷心菜]所创,转载请带上原文链接,感谢
https://blog.51cto.com/u_15452495/5247741
边栏推荐
- Go language self-study series | golang structure as function parameter
- [boutique] using dynamic agent to realize unified transaction management II
- 2D 01 Backpack
- MySQL小練習(僅適合初學者,非初學者勿進)
- js 原型链的深入
- Go language self-study series | initialization of golang structure
- valgrind和kcachegrind使用運行分析
- 【读书笔记】《Verilog数字系统设计教程》 第5章 条件语句、循环语句和块语句(附思考题答案)
- Applet error: cannot read property'currenttarget'of undefined
- ALV tree (ll LR RL RR) insert delete
猜你喜欢
随机推荐
Kettle实验
调包求得每个样本的k个邻居
Employee probation application (Luzhou Laojiao)
3、 6 [Verilog HDL] gate level modeling of basic knowledge
RSA encryption and decryption signature verification
ATSS(CVPR2020)
[indexof] [lastIndexOf] [split] [substring] usage details
Bk3633 specification
Give the method of instantiating the object to the new object
Valgrind et kcachegrind utilisent l'analyse d'exécution
Number theory to find the sum of factors of a ^ B (A and B are 1e12 levels)
Is Zhongyan futures safe and reliable?
GoLand debug go use - white record
What is monitoring intelligent playback and how to use intelligent playback to query video recording
[boutique] using dynamic agent to realize unified transaction management II
nn. Explanation of module class
Flink同时读取mysql与pgsql程序会卡住且没有日志
Production practice elk
Failed to prepare device for development
Research purpose, construction goal, construction significance, technological innovation, technological effect