• MySQL修改密码和忘记ROOT密码


    1、关闭数据库

    脚本:[root@mysql etc]# service mysql stop 

    2、使用脚本: mysqld_safe --skip-grant-tables 启动数据库 

    使用/usr/bin/mysqld_safe --skip-grant-tables&启动数据库 

    3、使用空密码进入数据库(mysql命令后直接回车) 

    [root@mysql ~]# mysql

    Welcome to the MySQL monitor. Commands end with ; or g.

    Your MySQL connection id is 3

    Server version: 5.6.20-enterprise-commercial-advanced MySQL Enterprise Server - Advanced Edition (Commercial)

    Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.

    Oracle is a registered trademark of Oracle Corporation and/or its

    affiliates. Other names may be trademarks of their respective

    owners.

    Type 'help;' or 'h' for help. Type 'c' to clear the current input statement.

    mysql> 

    4、使用UPDATE语句修改ROOT密码 

    mysql> UPDATE mysql.user SET

    -> PASSWORD=PASSWORD('root')

    -> where

    -> User='root' AND Host='localhost'; 

    5、关闭数据库并重新以正常方式启动数据库 

    [root@mysql ~]# service mysql restart;

    Shutting down MySQL.. SUCCESS!

    Starting MySQL.. SUCCESS!

    [root@mysql ~]# mysql

    ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

    [root@mysql ~]# mysql -p

    Enter password:

    Welcome to the MySQL monitor. Commands end with ; or g.

    Your MySQL connection id is 2

    Server version: 5.6.20-enterprise-commercial-advanced MySQL Enterprise Server - Advanced Edition (Commercial)

    Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved. 

    Oracle is a registered trademark of Oracle Corporation and/or its

    affiliates. Other names may be trademarks of their respective

    owners.

    Type 'help;' or 'h' for help. Type 'c' to clear the current input statement.

    mysql> 

  • 相关阅读:
    [Linux起步]常用命令
    Eclipse被SD杂志评为最佳开源工具
    [一点一滴学英语]20050921
    [一点一滴学英语]20050920
    [一点一滴学英语]20050919
    Longhorn (Vista) 推迟发布的背后
    最快速度找到内存泄漏
    重载(overload)、覆盖(override)、隐藏(hide) 详解
    HTTP请求和响应格式
    Skia之四——SkGradientShader篇
  • 原文地址:https://www.cnblogs.com/zgaspnet/p/6483824.html
Copyright © 2020-2023  润新知