• Home

  • Archives

Tan You Ping

Stay hungry, Stay foolish.

12月
06

Hello World

Posted on 2017-12-06

Welcome to Hexo! This is your very first post. Check documentation for more info. If you get any problems when using Hexo, you can find the answer in troubleshooting or you can ask me on GitHub.

Quick Start

Create a new post

1
$ hexo new "My New Post"

More info: Writing

Run server

1
$ hexo server

More info: Server

Generate static files

1
$ hexo generate

More info: Generating

Deploy to remote sites

1
$ hexo deploy

More info: Deployment

Read more »
12月
06
mysql

CentOS7 下mysql 忘记root密码的处理方法

Posted on 2017-12-06 • In mysql

1.vi /etc/my.cnf

2.添加

skip-grant-tables
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock

3.重启mysql

systemctl restart mysqld

4.用户无密码登录

mysql -u root -p (直接点击回车,密码为空)

5.选择数据库

use mysql;

6.修改root密码

update user set authentication_string=password(‘123456′) where user=’root’;

7.执行

flush privileges;

8.退出

exit;

9.删除

skip-grant-tables
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock

10.重启mysql

systemctl restart mysqld

这样就ok了呢。

Read more »
Tan You Ping

RSS
2 posts
1 categories
Creative Commons

博客已运行(●'◡'●)ノ♥

© 2017 . 由 Hexo 强力驱动. Theme By Sagiri v0.0.4.

Made with by Tan You Ping.