当前位置:网站首页>Linux64Bit下安装MySQL5.6-不能修改root密码
Linux64Bit下安装MySQL5.6-不能修改root密码
2022-04-23 20:18:00 【iBigder】
大家好,我是「Bigder」
Linux64Bit下安装MySQL5.6,本文参考了@IDO老徐的文章
- 1、 首先查看系统自带的Mysql,并卸载自带的版本
yum list installed |grep mysql
- 2、 卸载系统自带的mysql及其依赖,比如:步骤1返回结果:mysql-libs.x86_64,我是第一次安装。步骤1没有数据,如果有执行卸载。
yum -y remove mysql-libs.x86_64
- 3、下载rpm包
wget dev.mysql.com/get/mysql-community-release-el6-5.noarch.rpm --no-check-certificate
- 4、安装下载的rpm
yum localinstall mysql-community-release-el6-5.noarch.rpm
- 5、验证是否安装成功
yum repolist all | grep mysql
- 6、安装mysql服务
[[email protected] ~]# yum install mysql-community-server
- 7、查看mysql当前状态,没有启动
service mysqld status
[[email protected] ~]# service mysqld status
mysqld.service - SYSV: MySQL database server.
Loaded: loaded (/etc/rc.d/init.d/mysqld; bad; vendor preset: disabled)
Active: inactive (dead)
Docs: man:systemd-sysv-generator(8)
- 8、启动MySQL
service mysqld start
- 9、再查看mysql服务状态(已经启动)
[[email protected] ~]# service mysqld start
- 10、查看mysql5.6的默认密码,密码为空
grep 'temporary password' /var/log/mysqld.log
- 11、命令行模式登录mysql ,修改密码
mysql -u root -p
输入上面命令后,直接回车(5.6版本、默认密码为空)
- 12、查看当前数据库
show databases;
- 13、修改root密码,我这里root密码使用:「bigder#1314」
5.6版本这里用alert user命令报错
alter user [email protected] identified by "bigder#1314";
换下面的命令修改root登陆密码,注意引号都是英文输入法下的单引号。
update mysql.user set password=PASSWORD('bigder#1314') where User='root';
生效命令修改
mysql> flush privileges;Query OK, 0 rows affected (0.00 sec)
Bigder 软件测试、测试管理、职场、简历建议经验,助力测试初级测试岗进综合能力提升。 77篇原创内容 公众号
14、创建一个新的数据库「Bigder」
create DATABASE Bigder;
-
15、查看数据库是否创建成功:
-
show DATABASE;
成了Mysql5.6全部安装全部安装成功,你也试试!分享转发三倍工资!!!
以上,
Bigder
版权声明
本文为[iBigder]所创,转载请带上原文链接,感谢
https://blog.csdn.net/unit2006/article/details/124367814
边栏推荐
- 记录:调用mapper报空指针;<foreach>不去重的用法;
- PCL点云处理之计算两平面交线(五十一)
- R language uses the preprocess function of caret package for data preprocessing: BoxCox transform all data columns (convert non normal distribution data columns to normal distribution data and can not
- R language uses econocrats package to create microeconomic or macroeconomic map, visualize indifference function indifference curve, customize calculation intersection, and customize the parameters of
- The R language uses the timeroc package to calculate the multi time AUC value of survival data without competitive risk, and uses the confint function to calculate the confidence interval value of mul
- SRS deployment
- Cadence OrCAD capture batch change component packaging function introduction graphic tutorial and video demonstration
- Remote code execution in Win 11 using wpad / PAC and JScript 3
- Investigate why close is required after sqlsession is used in mybatties
- SIGIR'22 "Microsoft" CTR estimation: using context information to promote feature representation learning
猜你喜欢
Project training of Software College of Shandong University - Innovation Training - network security shooting range experimental platform (6)
【文本分类案例】(4) RNN、LSTM 电影评价倾向分类,附TensorFlow完整代码
网络通信基础(局域网、广域网、IP地址、端口号、协议、封装、分用)
WordPress plug-in: WP CHINA Yes solution to slow domestic access to the official website
. Ren -- the intimate artifact in the field of vertical Recruitment!
CVPR 2022 | QueryDet:使用级联稀疏query加速高分辨率下的小目标检测
Building googlenet neural network based on pytorch for flower recognition
Don't bother tensorflow learning notes (10-12) -- Constructing a simple neural network and its visualization
Comment créer un pass BEP - 20 sur la chaîne BNB
Unity general steps for creating a hyper realistic 3D scene
随机推荐
Remote code execution in Win 11 using wpad / PAC and JScript 1
Mysql database - single table query (I)
An error is reported in the initialization metadata of the dolphin scheduler -- it turns out that there is a special symbol in the password. "$“
Azkaban recompile, solve: could not connect to SMTP host: SMTP 163.com, port: 465 [January 10, 2022]
Use the rolling division method to find the maximum common divisor of two numbers
Vericrypt file hard disk encryption tutorial
如何在BNB鏈上創建BEP-20通證
Still using listview? Use animatedlist to make list elements move
PCL点云处理之直线与平面的交点计算(五十三)
How to create bep-20 pass on BNB chain
[text classification cases] (4) RNN and LSTM film evaluation Tendency Classification, with tensorflow complete code attached
R语言使用caret包的preProcess函数进行数据预处理:对所有的数据列进行BoxCox变换处理(将非正态分布数据列转换为正态分布数据、不可以处理负数)、设置method参数为BoxCox
MySQL advanced lock - overview of MySQL locks and classification of MySQL locks: global lock (data backup), table level lock (table shared read lock, table exclusive write lock, metadata lock and inte
Five minutes to show you what JWT is
如何做产品创新?——产品创新方法论探索一
DNS cloud school | analysis of hidden tunnel attacks in the hidden corner of DNS
网络通信基础(局域网、广域网、IP地址、端口号、协议、封装、分用)
Confusion about thread blocking after calling the read () method of wrapper flow
NC basic usage
R语言使用timeROC包计算存在竞争风险情况下的生存资料多时间AUC值、使用cox模型、并添加协变量、R语言使用timeROC包的plotAUCcurve函数可视化多时间生存资料的AUC曲线