I’ll tell you my story, but you may be in the same situation having done something completely different, so keep reading…
One day, some time ago, I was very happily installing the WP-Security-Scan WordPress plugin, and I got an analysis result saying that I should change the default WordPress database table prefix in order to make harder the potential SQL Injection attacks…
So I went to the link and filled the new prefix in the screen that appeared…
After pressing the “Start Renaming” button, I got the following page:
Everything seemed to have been done perfectly…
But…… This is what I got after trying to go somewhere else in the administration panel:
The infamous “You do not have sufficient permissions to access this page” message…
From this point on, I could not access the administration panel anymore… So what could I do?
The problem seemed to be generated by the modification of the WordPress table prefix, so I went to phpMyAdmin to check the database… Everething seemed OK.. I checked the wp-config,php… The prefix had been updated… The site seemed to work flawlessly for normal visitors…
So I started searching… And finally found a site whose solution I’ll leave you below in a easier to use way…
Solution
If this problem was generated by a change to the WordPress database table prefix (done by the buggy WP-Security-Scan plugin, by a migration or by other means), you should fill the following two fields and press the “Generate” button to generate a SQL Query which you should execute in your database (using phpMyAdmin or other options)…
Old Prefix | |
New Prefix | |
SQL |
That’s all… If this didn’t work for you, it may be other kind of problem… In that case, take a look at the comments section of this post, since there are some people which found other solutions.
Hope it helps
Support appreciated!
All the content offered in this website is, except noted otherwise, of free nature. This means you can share it wherever you want if you do it freely and stating its source.
If it was useful for you and you’d like to contribute, you can make a donation or, at least, visit one of our advertisers of your choice; they are all around the site.
Incoming search terms for the article:
- No tienes suficientes permisos para acceder a esta página
- no tienes suficientes permisos para hacer esto facebook
- No tienes suficientes permisos para acceder a esta página wordpress
- wordpress No tienes suficientes permisos para acceder a esta página
- no tiene los permisos necesarios
- facebook No tienes suficientes permisos para hacer esto
- You do not have access to the administrator section of this site
- No tienes suficientes permisos para hacer esto
- no tienes suficientes permisos para acceder a esta página wordpress role
- You do not have sufficient permissions to access this page
Ack! This happened to me too. In an attempt to fix it, I deleted the plugin via FTP. I should’ve googled first! Would you be able to instruct me how to fix it now? D-oh!
You can just “re-install” the plugin via FTP decompressing it int the wp-content/plugins/ directory so you’re at the previous situation and then follow step by step the instructions I posted.
If you have any trouble doing it, just tell me…
Hope it helps!
NeoEGM.
Excelente ayuda. Gracias!!!
De nada!
Saludos.
Thank you, I had exactly the same permissions problem. It never would have occurred to me that the database tables would contain references to other table names. My programmer sensibilities are offended.
Thank you for your comment!
Sometimes it happens that things are not implemented just as we would have wanted…
But well, we can always learn now perspectives (no matter whether we like them or not! :))!
I’m glad it helped you!
Thank you sooo much. That was the solution to my problem. I was migrating several wordpress databases into a new MySQL 5.0 server and wanted to name the prefixes differently to tell the wordpresses apart.
Thank you Paul for your comment!
I’m very glad it helped you!
Greetings!
Thank You So Much!! I updated my database prefix with the instructions at http://tdot-blog.com/wordpress/6-simple-steps-to-change-your-table-prefix-in-wordpress when the Security Scan plugin didn’t work for me. Everything went smoothly except for the permissions problem and I spent 2 aggravating hours trying to fix it before I stumbled across this solution. Thanks again!
Thanks David for your comment!
I’m glad the post helped you!
Greetings!
Aah! Your solution did the job! Thanks!
Excellent!
Thanks for your comment!
I’m glad it helped!
Greetings.
Thank you, thank you, thank you! I manually updated my prefix and got the error. Your generator worked great. Excellent post!
Excellent!
I’m glad it helped!
Thanks for your comment!
Greetings.
Hey
Thanks for this post. You saved me hours of searching on how to fix this problem!
No problem!
I’m glad it helped…
Thanks for you comment!
I used the same plugin and had exactly the same problem. Your quick SQL code generator gave me just the right incantation to regain control of my blog. Thanks!
I’m glad it helped!
Greetings.
Que grande! es justo lo que necesitaba para que funcione. muchas gracias, master
Gracias por el comentario!
Me alegro de que te haya servido!
Saludos.
Maestrisimo, eres un grande.
Muy buen script para generar el codigo sql. Me ahorraste horas!!
Un saludo y muchas gracias
Jaja! Gracias Mat!
Me alegro de que te haya servido!
Saludos!
Gracias, tuve el mismo problema. Pero en mi caso el re-nombramiento lo hice manualmente.
Joya!
Gracias por tu comentario.
Saludos!
Brilliant! Thanks so much, spent the last 2 days trying to solve this!
I’m glad it helped!
Thanks for your comment!
Hola. Muchas gracias por el generador porque permite avanzar bastante en la realización de estas funcionalidades. Un saludo.
Buenísimo que te haya servido!
Gracias por el comentario!
Saludos!
Me ha ido de perlas. Muchísimas gracias!!!
Gracias por tu comentario!
Me alegro de que te haya servido!
Saludos!
Hello, I have a article directory http://isearchquest.com/articles, i have the same problem, i have deleted “Article Directory” and “Role Manager” plugin and then re-installed, Second – i still have the same database name “wp_” haven’t changed that, third- i have updated my wordpress automatically to 3.0.1 but my problem is there although i can access the account by my “admin” privileges but a normal user (author) cannot able to login.
Please help.
This doesn’t seem to be the same problem.
Try creating the users again or checking manually the database…
Greetings!
La he hecho buena…en un intento por arreglar el “No tiene los permisos…” provocado por el wp-security-scan cambié el wp-config.php y ahora me encuentro con “Error establishing a database connection”
El problema fue a raiz del cambio de prefijo prefijo, con lo cual ahora no tengo claro el nombre de mi db, pero si pongo en el wp-config.php el nombre de db que me da el hosting me aparece la pantalla de inicio de instalación de WP O_O
Con otros nombres de db en el wp-config.php mantiene el “Error establishing…”, es el primer WP que monto y ahora que ya lo tenia todo sólidamente construido me encuentro con esto…y todo por querer aumentar la seguridad :_(
Espero puedas ayudarme, muchas gracias de antemano.
Tenés que dejar el wp-config.php con los datos de tu DB…
Sin eso no vas a poder conectarte por más que hayas arreglado todo…
Fijate en la config de tu hosting.
Saludos!
Thank you. Worked a charm, You sir are a lifesaver. Stupid plugin. Now to warn other users…
Thank you Barry!
It’s not a bat plugin, but it has that ugly bug…
Greetings!
you are a legend thank you very much
Thank you Nathan!
I’m glad it helped!
Greetings!
Perfecto! me has ayudado mucho, sigue así!!!
Buenísimo!
Gracias por tu comentario…
Saludos!
Muchas gracias
De nada!
Saludos!
gracias! me paso exactamente lo mismo que a vos… me salvaste de un dolor de cabeza.
Jaja! Joya!
Saludos!
¡Excelente! Resolvió mi problema.
Buenísimo!
Saludos!
Oh man… you rock! I looked all over for a fix. I especially like that you created a sql generator to produce the code. Awesome! Super easy to fix.
Thanks for your comment!
I’m glad i helped!
Hola NeoEGM, sé que es un post antiguo pero me encuentro ahora con este problema.
Mi error ha sido provocado por otro plugin, Theme Teaster concretamente. El caso es que no sé qué prefijo nuevo debo poner en el generador que has creado. ¿Lo dejo igual? En ‘Prefijo Anterior’ dejo ‘wp_’ y en ‘Prefijo Nuevo’ dejo ‘wp_nuevo_prefijo_’ ??
Luego ese codigo SQL generado dónde lo inserto? disculpa mi ignorancia en estos temas pero apenas me manejo con las bases de datos SQL.
Muchas gracias,
Un saludo!
I did exactly what you said but it still doesn’t work! This all began after changing the database prefix with the WP-Security-Scan plugin… I did the same in other blogs of mine and nothing wrong happened, but this time was a complete disaster.
For the love of god, help me…
I have the same problem. But I don´t know sql. I don´t find the prefix table field to change.
I must choose SQL o generate consult.
Please, you can explain how to do it, with more details.
You can send me a email with instruccions.
Thanks and goodbye.
Gracias por la ayuda, me ha funcionado
genial me ayuda xd que bueno esta gracias….
Diagnóstico exacto, me solucionó el problema. Muchas gracias por tu trabajo.
Gracias por tu comentario! Me alegro de que te haya servido! Saludos.