mirror of
https://github.com/mContext/mContext.github.io.git
synced 2024-09-18 06:04:54 +08:00
464 lines
19 KiB
HTML
464 lines
19 KiB
HTML
<!DOCTYPE html>
|
||
<html lang="zh-CN">
|
||
<head>
|
||
<meta charset="UTF-8">
|
||
<meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=2">
|
||
<meta name="theme-color" content="#222">
|
||
<meta name="generator" content="Hexo 4.0.0">
|
||
<link rel="apple-touch-icon" sizes="180x180" href="/images/apple-touch-icon-next.png">
|
||
<link rel="icon" type="image/png" sizes="32x32" href="/images/favicon-32x32-next.png">
|
||
<link rel="icon" type="image/png" sizes="16x16" href="/images/favicon-16x16-next.png">
|
||
<link rel="mask-icon" href="/images/logo.svg" color="#222">
|
||
|
||
<link rel="stylesheet" href="/css/main.css">
|
||
|
||
|
||
<link rel="stylesheet" href="/lib/font-awesome/css/font-awesome.min.css">
|
||
|
||
|
||
<script id="hexo-configurations">
|
||
var NexT = window.NexT || {};
|
||
var CONFIG = {
|
||
hostname: new URL('https://yuxihan.com').hostname,
|
||
root: '/',
|
||
scheme: 'Mist',
|
||
version: '7.6.0',
|
||
exturl: false,
|
||
sidebar: {"position":"left","display":"post","padding":18,"offset":12,"onmobile":false},
|
||
copycode: {"enable":false,"show_result":false,"style":null},
|
||
back2top: {"enable":true,"sidebar":false,"scrollpercent":false},
|
||
bookmark: {"enable":false,"color":"#222","save":"auto"},
|
||
fancybox: false,
|
||
mediumzoom: false,
|
||
lazyload: false,
|
||
pangu: false,
|
||
algolia: {
|
||
appID: '',
|
||
apiKey: '',
|
||
indexName: '',
|
||
hits: {"per_page":10},
|
||
labels: {"input_placeholder":"Search for Posts","hits_empty":"We didn't find any results for the search: ${query}","hits_stats":"${hits} results found in ${time} ms"}
|
||
},
|
||
localsearch: {"enable":true,"trigger":"auto","top_n_per_article":1,"unescape":false,"preload":false},
|
||
path: 'search.xml',
|
||
motion: {"enable":false,"async":false,"transition":{"post_block":"fadeIn","post_header":"slideDownIn","post_body":"slideDownIn","coll_header":"slideLeftIn","sidebar":"slideUpIn"}}
|
||
};
|
||
</script>
|
||
|
||
<meta name="description" content="停止mysql服务进程1service mysql stop 打开mysql配置文件my.cnf，在 [mysqld] 下添加skip-grant-tables #免密登录1vim /etc/my.cnf">
|
||
<meta property="og:type" content="article">
|
||
<meta property="og:title" content="CentOS下重置MySql密码">
|
||
<meta property="og:url" content="https://yuxihan.com/20200301.html">
|
||
<meta property="og:site_name" content="Write the code">
|
||
<meta property="og:description" content="停止mysql服务进程1service mysql stop 打开mysql配置文件my.cnf，在 [mysqld] 下添加skip-grant-tables #免密登录1vim /etc/my.cnf">
|
||
<meta property="og:locale" content="zh-CN">
|
||
<meta property="og:updated_time" content="2020-03-01T11:02:00.000Z">
|
||
<meta name="twitter:card" content="summary">
|
||
|
||
<link rel="canonical" href="https://yuxihan.com/20200301.html">
|
||
|
||
|
||
<script id="page-configurations">
|
||
// https://hexo.io/docs/variables.html
|
||
CONFIG.page = {
|
||
sidebar: "",
|
||
isHome: false,
|
||
isPost: true,
|
||
isPage: false,
|
||
isArchive: false
|
||
};
|
||
</script>
|
||
|
||
<title>CentOS下重置MySql密码 | Write the code</title>
|
||
|
||
|
||
|
||
<script>
|
||
var _hmt = _hmt || [];
|
||
(function() {
|
||
var hm = document.createElement("script");
|
||
hm.src = "https://hm.baidu.com/hm.js?e8fc3c7012308a4ca7e8bd1a27c6ce86";
|
||
var s = document.getElementsByTagName("script")[0];
|
||
s.parentNode.insertBefore(hm, s);
|
||
})();
|
||
</script>
|
||
|
||
|
||
|
||
|
||
<noscript>
|
||
<style>
|
||
.use-motion .brand,
|
||
.use-motion .menu-item,
|
||
.sidebar-inner,
|
||
.use-motion .post-block,
|
||
.use-motion .pagination,
|
||
.use-motion .comments,
|
||
.use-motion .post-header,
|
||
.use-motion .post-body,
|
||
.use-motion .collection-header { opacity: initial; }
|
||
|
||
.use-motion .site-title,
|
||
.use-motion .site-subtitle {
|
||
opacity: initial;
|
||
top: initial;
|
||
}
|
||
|
||
.use-motion .logo-line-before i { left: initial; }
|
||
.use-motion .logo-line-after i { right: initial; }
|
||
</style>
|
||
</noscript>
|
||
|
||
</head>
|
||
|
||
<body itemscope itemtype="http://schema.org/WebPage">
|
||
<div class="container">
|
||
<div class="headband"></div>
|
||
|
||
<header class="header" itemscope itemtype="http://schema.org/WPHeader">
|
||
<div class="header-inner"><div class="site-brand-container">
|
||
<div class="site-meta">
|
||
|
||
<div>
|
||
<a href="/" class="brand" rel="start">
|
||
<span class="logo-line-before"><i></i></span>
|
||
<span class="site-title">Write the code</span>
|
||
<span class="logo-line-after"><i></i></span>
|
||
</a>
|
||
</div>
|
||
</div>
|
||
|
||
<div class="site-nav-toggle">
|
||
<div class="toggle" aria-label="切换导航栏">
|
||
<span class="toggle-line toggle-line-first"></span>
|
||
<span class="toggle-line toggle-line-middle"></span>
|
||
<span class="toggle-line toggle-line-last"></span>
|
||
</div>
|
||
</div>
|
||
</div>
|
||
|
||
|
||
<nav class="site-nav">
|
||
|
||
<ul id="menu" class="menu">
|
||
<li class="menu-item menu-item-home">
|
||
|
||
<a href="/" rel="section"><i class="fa fa-fw fa-home"></i>首页</a>
|
||
|
||
</li>
|
||
<li class="menu-item menu-item-tags">
|
||
|
||
<a href="/tags/" rel="section"><i class="fa fa-fw fa-tags"></i>标签</a>
|
||
|
||
</li>
|
||
<li class="menu-item menu-item-archives">
|
||
|
||
<a href="/archives/" rel="section"><i class="fa fa-fw fa-archive"></i>归档</a>
|
||
|
||
</li>
|
||
<li class="menu-item menu-item-search">
|
||
<a role="button" class="popup-trigger"><i class="fa fa-search fa-fw"></i>搜索
|
||
</a>
|
||
</li>
|
||
</ul>
|
||
|
||
</nav>
|
||
<div class="site-search">
|
||
<div class="popup search-popup">
|
||
<div class="search-header">
|
||
<span class="search-icon">
|
||
<i class="fa fa-search"></i>
|
||
</span>
|
||
<div class="search-input-container">
|
||
<input autocomplete="off" autocorrect="off" autocapitalize="none"
|
||
placeholder="搜索..." spellcheck="false"
|
||
type="text" id="search-input">
|
||
</div>
|
||
<span class="popup-btn-close">
|
||
<i class="fa fa-times-circle"></i>
|
||
</span>
|
||
</div>
|
||
<div id="search-result"></div>
|
||
|
||
</div>
|
||
<div class="search-pop-overlay"></div>
|
||
|
||
</div>
|
||
</div>
|
||
</header>
|
||
|
||
|
||
<div class="back-to-top">
|
||
<i class="fa fa-arrow-up"></i>
|
||
<span>0%</span>
|
||
</div>
|
||
|
||
|
||
<main class="main">
|
||
<div class="main-inner">
|
||
<div class="content-wrap">
|
||
|
||
|
||
<div class="content">
|
||
|
||
|
||
<div class="posts-expand">
|
||
|
||
|
||
|
||
<article itemscope itemtype="http://schema.org/Article" class="post-block " lang="zh-CN">
|
||
<link itemprop="mainEntityOfPage" href="https://yuxihan.com/20200301.html">
|
||
|
||
<span hidden itemprop="author" itemscope itemtype="http://schema.org/Person">
|
||
<meta itemprop="image" content="/images/default_avatar.jpg">
|
||
<meta itemprop="name" content="mContext">
|
||
<meta itemprop="description" content="Enlightened Shenzhen">
|
||
</span>
|
||
|
||
<span hidden itemprop="publisher" itemscope itemtype="http://schema.org/Organization">
|
||
<meta itemprop="name" content="Write the code">
|
||
</span>
|
||
<header class="post-header">
|
||
<h1 class="post-title" itemprop="name headline">
|
||
CentOS下重置MySql密码
|
||
</h1>
|
||
|
||
<div class="post-meta">
|
||
<span class="post-meta-item">
|
||
<span class="post-meta-item-icon">
|
||
<i class="fa fa-calendar-o"></i>
|
||
</span>
|
||
<span class="post-meta-item-text">发表于</span>
|
||
|
||
<time title="创建时间：2020-03-01 19:02:00" itemprop="dateCreated datePublished" datetime="2020-03-01T19:02:00+08:00">2020-03-01</time>
|
||
</span>
|
||
|
||
|
||
|
||
</div>
|
||
</header>
|
||
|
||
|
||
|
||
|
||
<div class="post-body" itemprop="articleBody">
|
||
|
||
|
||
<h3 id="停止mysql服务进程"><a href="#停止mysql服务进程" class="headerlink" title="停止mysql服务进程"></a>停止mysql服务进程</h3><figure class="highlight arduino"><table><tr><td class="gutter"><pre><span class="line">1</span></pre></td><td class="code"><pre><span class="line">service mysql <span class="built_in">stop</span></span></pre></td></tr></table></figure>
|
||
<h3 id="打开mysql配置文件my-cnf，在-mysqld-下添加skip-grant-tables-免密登录"><a href="#打开mysql配置文件my-cnf，在-mysqld-下添加skip-grant-tables-免密登录" class="headerlink" title="打开mysql配置文件my.cnf，在 [mysqld] 下添加skip-grant-tables #免密登录"></a>打开mysql配置文件my.cnf，在 [mysqld] 下添加skip-grant-tables #免密登录</h3><figure class="highlight vim"><table><tr><td class="gutter"><pre><span class="line">1</span></pre></td><td class="code"><pre><span class="line"><span class="keyword">vim</span> /etc/my.<span class="keyword">cnf</span></span></pre></td></tr></table></figure>
|
||
<a id="more"></a>
|
||
<h3 id="重新启动mysql"><a href="#重新启动mysql" class="headerlink" title="重新启动mysql"></a>重新启动mysql</h3><figure class="highlight ebnf"><table><tr><td class="gutter"><pre><span class="line">1</span></pre></td><td class="code"><pre><span class="line"><span class="attribute">service mysql restart</span></span></pre></td></tr></table></figure>
|
||
<h3 id="登录到数据库"><a href="#登录到数据库" class="headerlink" title="登录到数据库"></a>登录到数据库</h3><figure class="highlight ebnf"><table><tr><td class="gutter"><pre><span class="line">1</span></pre></td><td class="code"><pre><span class="line"><span class="attribute">mysql -uroot</span></span></pre></td></tr></table></figure>
|
||
|
||
<h3 id="切换到mysql数据库"><a href="#切换到mysql数据库" class="headerlink" title="切换到mysql数据库"></a>切换到mysql数据库</h3><figure class="highlight php"><table><tr><td class="gutter"><pre><span class="line">1</span></pre></td><td class="code"><pre><span class="line"><span class="keyword">use</span> <span class="title">mysql</span>;</span></pre></td></tr></table></figure>
|
||
<h3 id="更改密码"><a href="#更改密码" class="headerlink" title="更改密码"></a>更改密码</h3><figure class="highlight pgsql"><table><tr><td class="gutter"><pre><span class="line">1</span></pre></td><td class="code"><pre><span class="line"><span class="keyword">update</span> mysql.<span class="keyword">user</span> <span class="keyword">set</span> authentication_string=<span class="keyword">password</span>(<span class="string">'新密码'</span>) <span class="keyword">where</span> <span class="keyword">user</span>=<span class="string">'root'</span>;</span></pre></td></tr></table></figure>
|
||
<h3 id="刷新权限"><a href="#刷新权限" class="headerlink" title="刷新权限"></a>刷新权限</h3><figure class="highlight sql"><table><tr><td class="gutter"><pre><span class="line">1</span></pre></td><td class="code"><pre><span class="line"><span class="keyword">flush</span> <span class="keyword">privileges</span>;</span></pre></td></tr></table></figure>
|
||
<h3 id="配置文件my-cnf，将skip-grant-tables-免密登录-删除"><a href="#配置文件my-cnf，将skip-grant-tables-免密登录-删除" class="headerlink" title="配置文件my.cnf，将skip-grant-tables #免密登录 删除"></a>配置文件my.cnf，将skip-grant-tables #免密登录 删除</h3><figure class="highlight vim"><table><tr><td class="gutter"><pre><span class="line">1</span></pre></td><td class="code"><pre><span class="line"><span class="keyword">vim</span> /etc/my.<span class="keyword">cnf</span></span></pre></td></tr></table></figure>
|
||
<h3 id="使用密码登录root用户"><a href="#使用密码登录root用户" class="headerlink" title="使用密码登录root用户"></a>使用密码登录root用户</h3><figure class="highlight dns"><table><tr><td class="gutter"><pre><span class="line">1</span></pre></td><td class="code"><pre><span class="line">mysql -uroot -p新密码</span></pre></td></tr><tr><td class="gutter"><pre><span class="line">2</span></pre></td><td class="code"><pre><span class="line">如：mysql -uroot -p<span class="number">20200202</span></span></pre></td></tr></table></figure>
|
||
|
||
|
||
</div>
|
||
|
||
|
||
|
||
|
||
|
||
<footer class="post-footer">
|
||
|
||
|
||
|
||
|
||
|
||
<div class="post-nav">
|
||
<div class="post-nav-item">
|
||
<a href="/20200105.html" rel="prev" title="雨曦会翻身啦">
|
||
<i class="fa fa-chevron-left"></i> 雨曦会翻身啦
|
||
</a></div>
|
||
<div class="post-nav-item">
|
||
<a href="/20200306.html" rel="next" title="CentOS安装Nginx并配置转发">
|
||
CentOS安装Nginx并配置转发 <i class="fa fa-chevron-right"></i>
|
||
</a></div>
|
||
</div>
|
||
</footer>
|
||
|
||
</article>
|
||
|
||
|
||
|
||
|
||
</div>
|
||
|
||
|
||
</div>
|
||
|
||
|
||
</div>
|
||
|
||
|
||
<div class="toggle sidebar-toggle">
|
||
<span class="toggle-line toggle-line-first"></span>
|
||
<span class="toggle-line toggle-line-middle"></span>
|
||
<span class="toggle-line toggle-line-last"></span>
|
||
</div>
|
||
|
||
<aside class="sidebar">
|
||
<div class="sidebar-inner">
|
||
|
||
<ul class="sidebar-nav motion-element">
|
||
<li class="sidebar-nav-toc">
|
||
文章目录
|
||
</li>
|
||
<li class="sidebar-nav-overview">
|
||
站点概览
|
||
</li>
|
||
</ul>
|
||
|
||
<!--noindex-->
|
||
<div class="post-toc-wrap sidebar-panel">
|
||
<div class="post-toc motion-element"><ol class="nav"><li class="nav-item nav-level-3"><a class="nav-link" href="#停止mysql服务进程"><span class="nav-number">1.</span> <span class="nav-text">停止mysql服务进程</span></a></li><li class="nav-item nav-level-3"><a class="nav-link" href="#打开mysql配置文件my-cnf，在-mysqld-下添加skip-grant-tables-免密登录"><span class="nav-number">2.</span> <span class="nav-text">打开mysql配置文件my.cnf，在 [mysqld] 下添加skip-grant-tables #免密登录</span></a></li><li class="nav-item nav-level-3"><a class="nav-link" href="#重新启动mysql"><span class="nav-number">3.</span> <span class="nav-text">重新启动mysql</span></a></li><li class="nav-item nav-level-3"><a class="nav-link" href="#登录到数据库"><span class="nav-number">4.</span> <span class="nav-text">登录到数据库</span></a></li><li class="nav-item nav-level-3"><a class="nav-link" href="#切换到mysql数据库"><span class="nav-number">5.</span> <span class="nav-text">切换到mysql数据库</span></a></li><li class="nav-item nav-level-3"><a class="nav-link" href="#更改密码"><span class="nav-number">6.</span> <span class="nav-text">更改密码</span></a></li><li class="nav-item nav-level-3"><a class="nav-link" href="#刷新权限"><span class="nav-number">7.</span> <span class="nav-text">刷新权限</span></a></li><li class="nav-item nav-level-3"><a class="nav-link" href="#配置文件my-cnf，将skip-grant-tables-免密登录-删除"><span class="nav-number">8.</span> <span class="nav-text">配置文件my.cnf，将skip-grant-tables #免密登录 删除</span></a></li><li class="nav-item nav-level-3"><a class="nav-link" href="#使用密码登录root用户"><span class="nav-number">9.</span> <span class="nav-text">使用密码登录root用户</span></a></li></ol></div>
|
||
</div>
|
||
<!--/noindex-->
|
||
|
||
<div class="site-overview-wrap sidebar-panel">
|
||
<div class="site-author motion-element" itemprop="author" itemscope itemtype="http://schema.org/Person">
|
||
<img class="site-author-image" itemprop="image" alt="mContext"
|
||
src="/images/default_avatar.jpg">
|
||
<p class="site-author-name" itemprop="name">mContext</p>
|
||
<div class="site-description" itemprop="description">Enlightened Shenzhen</div>
|
||
</div>
|
||
<div class="site-state-wrap motion-element">
|
||
<nav class="site-state">
|
||
<div class="site-state-item site-state-posts">
|
||
<a href="/archives/">
|
||
|
||
<span class="site-state-item-count">23</span>
|
||
<span class="site-state-item-name">日志</span>
|
||
</a>
|
||
</div>
|
||
<div class="site-state-item site-state-tags">
|
||
<a href="/tags/">
|
||
|
||
<span class="site-state-item-count">23</span>
|
||
<span class="site-state-item-name">标签</span></a>
|
||
</div>
|
||
</nav>
|
||
</div>
|
||
<div class="links-of-author motion-element">
|
||
<span class="links-of-author-item">
|
||
<a href="https://github.com/mContext" title="GitHub → https://github.com/mContext" rel="noopener" target="_blank"><i class="fa fa-fw fa-github"></i>GitHub</a>
|
||
</span>
|
||
<span class="links-of-author-item">
|
||
<a href="mailto:h@yuxihan.com" title="E-Mail → mailto:h@yuxihan.com"><i class="fa fa-fw fa-envelope"></i>E-Mail</a>
|
||
</span>
|
||
</div>
|
||
|
||
|
||
|
||
</div>
|
||
|
||
</div>
|
||
</aside>
|
||
<div id="sidebar-dimmer"></div>
|
||
|
||
|
||
</div>
|
||
</main>
|
||
|
||
<footer class="footer">
|
||
<div class="footer-inner">
|
||
<!--
|
||
<div class="beian"><a href="https://beian.miit.gov.cn/" rel="noopener" target="_blank">鲁ICP备19060123号 </a><a href="http://www.beian.gov.cn/portal/registerSystemInfo?recordcode=44030702002723" rel="noopener" target="_blank">粤公网安备 44030702002723号 </a>
|
||
</div>
|
||
-->
|
||
<div class="copyright">
|
||
|
||
© 2014 –
|
||
<span itemprop="copyrightYear">2023</span>
|
||
<span class="with-love">
|
||
<!-- <i class="fa fa-user"></i> -->
|
||
<i class="fa fa-heart"></i>
|
||
</span>
|
||
<span class="author" itemprop="copyrightHolder">mContext</span>
|
||
<span>
|
||
<a target="_blank" href="https://www.upyun.com/?utm_source=lianmeng&utm_medium=referral">
|
||
<img src="https://upyun.yuxihan.com/yunpaiyun.png" style="display:inline-block;text-decoration:none;width: 50px;margin-bottom:-8px;"></a>
|
||
</span>
|
||
</div>
|
||
|
||
<!-- 在网页底部添加网站运行时间 -->
|
||
<span id="timeDate">载入天数...</span><span id="times">载入时分秒...</span>
|
||
<script>
|
||
var now = new Date();
|
||
function createtime() {
|
||
var grt= new Date("05/20/2014 00:00:00");//此处修改你的建站时间或者网站上线时间
|
||
now.setTime(now.getTime()+250);
|
||
days = (now - grt ) / 1000 / 60 / 60 / 24; dnum = Math.floor(days);
|
||
hours = (now - grt ) / 1000 / 60 / 60 - (24 * dnum); hnum = Math.floor(hours);
|
||
if(String(hnum).length ==1 ){hnum = "0" + hnum;} minutes = (now - grt ) / 1000 /60 - (24 * 60 * dnum) - (60 * hnum);
|
||
mnum = Math.floor(minutes); if(String(mnum).length ==1 ){mnum = "0" + mnum;}
|
||
seconds = (now - grt ) / 1000 - (24 * 60 * 60 * dnum) - (60 * 60 * hnum) - (60 * mnum);
|
||
snum = Math.round(seconds); if(String(snum).length ==1 ){snum = "0" + snum;}
|
||
document.getElementById("timeDate").innerHTML = "网站已运行 "+dnum+" 天 ";
|
||
document.getElementById("times").innerHTML = hnum + " 小时 " + mnum + " 分 " + snum + " 秒";
|
||
}
|
||
setInterval("createtime()",250);
|
||
</script>
|
||
<div class="beian">
|
||
<a href="http://beian.miit.gov.cn/" rel="noopener" target="_blank">鲁ICP备19060123号</a>
|
||
|
||
<span class="post-meta-divider">|</span>
|
||
|
||
<img src="/images/beian_icon.png" style="display:inline-block;text-decoration:none;height:13px;" />
|
||
|
||
<a href="http://www.beian.gov.cn/portal/registerSystemInfo?recordcode=44030702002723" rel="noopener" target="_blank">粤公网安备 44030702002723号</a>
|
||
|
||
</div>
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
</div>
|
||
</footer>
|
||
</div>
|
||
|
||
|
||
<script src="/lib/anime.min.js"></script>
|
||
<script src="/js/utils.js"></script>
|
||
<script src="/js/schemes/muse.js"></script>
|
||
<script src="/js/next-boot.js"></script>
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
<script src="/js/local-search.js"></script>
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
</body>
|
||
</html>
|