`
天梯梦
  • 浏览: 13742208 次
  • 性别: Icon_minigender_2
  • 来自: 洛杉矶
社区版块
存档分类
最新评论

解决WP表前缀更换后出现的You do not have sufficient permission

 
阅读更多

将安装的wordpress表前缀由默认的 wp_修改为其它了,再次登陆后台后出现

You do not have sufficient permissions to access this page.

网上搜索了一下,说是修改检查 wp_usermeta 表中的 wp_capabilities, wp_user_level 数值,但是无效,再搜索发现如下方法解决问题

 

步骤1.
将wp_usermeta 表中对应wp_前缀设置的
wp_capabilities, wp_user_level,wp_autosave_draft_ids 的前缀 wp_ 修改为新的前缀

 

步骤2.
将wp_options 中wp_user_roles 前缀 wp_ 修改为新的前缀

或者在phpmyadmin中执行如下语句:

UPDATE `{%TABLE_PREFIX%}usermeta` SET `meta_key` = replace(`meta_key`, '{%OLD_TABLE_PREFIX%}', '{%NEW_TABLE_PREFIX%}');
UPDATE `{%TABLE_PREFIX%}options` SET `option_name` = replace(`option_name`, '{%OLD_TABLE_PREFIX%}', '{%NEW_TABLE_PREFIX%}');

 

 

执行上面SQL语句时,记得备份数据库,避免出现不可遇见的问题

 

原文/转自:解决WP表前缀更换后出现的You do not have sufficient permission

 

 

 

 

 

 

 

分享到:
评论

相关推荐

    ansys技巧全集(很好的ansys技巧 英文版) 很多书上都没有的技巧

    It is your responsibility to determine if you have sufficient knowlege and understanding of finite element theory to apply the software appropriately. I have attempted to give accurate information, ...

    python学习记录(控制流)

    print('(but you do not little higher than that)') elif guess print('No, it is a little higher than that.') else: print('No, it is a little lower than that.') print('Done') ``` **注意事项:** 1. `...

    Google C++ Style Guide(Google C++编程规范)高清PDF

    However, implementation code properly belongs in .cc files, and we do not like to have much actual code in .h files unless there is a readability or performance advantage. If an inline function ...

    彻底解决“安装.Net Framework 3.5时出现错误”的问题.pdf

    Verify that you have sufficient access to that key, or contact your support personnel. ``` 3. **解读错误信息**:上述例子表明安装失败是因为缺少对注册表键 `\SOFTWARE\Microsoft\InternetExplorer\Main\...

    scapy-2.2.0

    Third, even programs which only decode do not give you all the information they received. The network's vision they give you is the one their author thought was sufficient. But it is not complete, and...

    一招解决MindManager 15安装无法打开注册表问题.docx

    Verify that you have sufficient access to that key, or contact your support personnel。 解决该错误的步骤如下: 步骤一:使用快捷键 Win+R,打开运行对话框,输入 regedit,点击确定。 步骤二:在注册表...

    JaCoCo探针策略原理及案例总结

    JaCoCo是一款流行的Java代码覆盖率工具,其探针策略是其核心机制之一,用于精确地追踪和记录代码的执行情况。探针策略涉及到字节码级别的操作,这使得JaCoCo能够在不影响应用性能的情况下,有效地收集覆盖率数据。...

    Recover4all Professional

    (i) use the Registered Software on as many computers as You like, provided that You (or anybody else) do not save Your Registration Key on any computer (see Section 3.3 (a) (i)); or (ii) save Your ...

    MS-DOS 5.0

    If you have a partition that is incompatible with MS-DOS 5.0, you must delete it from your hard disk. Incompatible partitions are listed as "Non-DOS" partitions in FDISK. See the procedure for ...

    Angular+5+Projects-Apress(2018).pdf

    I do have some strong opinions, but please don’t take them as gospel. I don’t intend to harm anything or anyone—I’m not smart enough for that. Scope This scope of this book is to help developers ...

    pid调试经验

    You HAVE TO increase the gains before you can expect any control responses. This tutorial is valid for all multi rotor setups (AR.Drone, PWM Quads / Hexa / Octo setups). Proportional, Integral, ...

    User's Manual.doc

    Instructions for Hades™ Video Wall Processor Chapter 1 Instructions for Safe...1.8.7Do not place the equipment on the place near liquid. 1.8.8 Please place the power cable properly to avoid damages.

    XNA 3D Primer 书及源代码

    XNA 3D Primer 书及源代码 42 pages Publisher: Wrox (January 4, 2010) ISBN-10: 0470596937 ... Hopefully, this Wrox Blox will have provided you with enough tools to learn what you don’t know.

    Alcohol 120%

    You can use a CD/DVD recorder as a reader if you have sufficient hard disk space to store a CD/DVD whole image. <br>One or more CD/DVD recorders (if you install more than 2 CD recorders, 700MHz ...

    Designing Software Architectures - A Practical Approach

    Even though you may not currently possess sufficient design experience, we illustrate how the method promotes reusing design concepts—that is, proven solutions that embody the experience of others.

    practical-test-driven-development-c#7

    don't need anyone's permission to do good work. Advice on how to continue a successful journey of TDD, how to introduce TDD to your team, and how to rejoin the world as a TDD expert will be covered in...

    英文原版-Succeeding in Your Consultant Medical Interview 1st Edition

    Despite the importance of this interview, it is probable that most doctors do not invest sufficient time and effort preparing for it. In this book, the following issues are taken into account: - ...

    Scala-in-Action.pdf

    I had a great time writing this book and I hope you have a great time learning this new and exciting language. I know you had a choice when it comes to Scala books; thank you for choosing this one.

Global site tag (gtag.js) - Google Analytics