当前位置:网站首页>#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
边栏推荐
- Experimental report on analysis of overflow vulnerability of assembly language and reverse engineering stack
- [SQL Server fast track] view and cursor of database
- First principle mind map
- Image processing in opencv -- Introduction to contour + contour features
- 爬虫使用xpath解析时返回为空,获取不到相应的元素的原因和解决办法
- 112. Path sum
- [indexof] [lastIndexOf] [split] [substring] usage details
- Using JS to realize a thousandth bit
- 501. 二叉搜索树中的众数
- Base de la technologie électronique numérique 3.1 aperçu du circuit de porte, 3.2 circuit de porte à diode semi - conductrice
猜你喜欢
Open services in the bottom bar of idea
I don't understand time, timestamp and time zone. Look at this article
Number of islands
Common errors of VMware building es8
NPM reports an error: operation not allowed, MKDIR 'C: \ program files \ node JS \ node_ cache _ cacache’
LeetCode_ DFS_ Medium_ 1254. Count the number of closed islands
Introduction to matlab
Enterprise wechat application authorization / silent login
SAP 101K 411K 库存变化
npm ERR! network
随机推荐
Initial experience of talent plan learning camp: communication + adhering to the only way to learn open source collaborative courses
PCTP考试经验分享
STM32 and FreeRTOS stack parsing
Give the method of instantiating the object to the new object
Principle of synchronized implementation
RSA 加密解密签名验签
DJ music management software pioneer DJ rekordbox
Number of islands
To remember the composition ~ the pre order traversal of binary tree
数字政府建设中政务中台中的技术创新点
Correct method of calculating inference time of neural network
Flink reads MySQL and PgSQL at the same time, and the program will get stuck without logs
爬虫使用xpath解析时返回为空,获取不到相应的元素的原因和解决办法
Go language self-study series | golang structure pointer
Flink同时读取mysql与pgsql程序会卡住且没有日志
Trc20 fund collection solution based on thinkphp5 version
Research purpose, construction goal, construction significance, technological innovation, technological effect
Little girl walking
Kettle实验 (三)
Common errors of VMware building es8