› MySQL 5.5 Community Server
› MySQL 5.6 Community Server
› Percona Configuration Wizard
› XtraBackup 搭建主从复制
Great Sites on MySQL
› Percona
› MySQL Performance Blog
› Severalnines
推荐管理工具
› Sequel Pro
› phpMyAdmin
推荐书目
› MySQL Cookbook
MySQL 相关项目
› MariaDB
› Drizzle
参考文档
› http://mysql-python.sourceforge.net/MySQLdb.html
luahou
V2EX  ›  MySQL

(GRANT ALL PRIVILEGES ON *.* 丢失)寻解决方法

  •  
  •   luahou · Aug 4, 2014 · 6072 views
    This topic created in 4445 days ago, the information mentioned may be changed or developed.
    不知道小伙伴怎么搞的,将mysql整出问题。
    登陆发现默认密码不对后跳过grant修改root密码进入。
    然后发现 GRANT ALL PRIVILEGES ON *.* 会出现验证错误。
    show grants 发现权限丢失,只剩如下所示。
    | GRANT ALL PRIVILEGES ON `mysql`.* TO 'root'@'localhost' |
    | GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION

    寻求解决方法。
    1 replies  •  2014-08-10 14:03:47 +08:00
    luahou
        1
    luahou  
    OP
       Aug 10, 2014
    最后执行mysql_upgrade搞定。存档。
    About   ·   Help   ·   Advertise   ·   Blog   ·   API   ·   FAQ   ·   Privacy   ·   Solana   ·   2723 Online   Highest 6679   ·     Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 3.9.8.5 · 25ms · UTC 03:12 · PVG 11:12 · LAX 20:12 · JFK 23:12
    ♥ Do have faith in what you're doing.