Skip to main content

WordPress Not sufficient permissions to access admin page

While installing WordPress for my blog, I was trying out different subdomain/ folder options.

After final installation when I tried to access the admin page I was being redirected to /wp-admin/profile.php but getting insufficient permission error like shown below.

not sufficient permission

I could access the front page easily but couldn’t log in admin panel.

I tried changing the permission of WordPress files  and directories to 755 but to no avail.

The problem was that while installing WordPress I used different table prefixes each time.

table_prefix

WordPress uses the table prefix for forming the option and usermeta keys name for storing roles and capabilities information.

So in the process, database tables had correct table prefixes but some records in the some  of the tables still had old table prefix and this was causing the problem.

To fix the issue you need to update your database using phpMyAdmin or php.

Check in your database in the usermeta and options table if they have correct table prefix in all the fields.

UPDATE `wp_usermeta` SET `meta_key` = replace(`meta_key`, 'old_prefix', 'current_prefix');
UPDATE `wp_options` SET `option_name` = replace(`option_name`, 'old_prefix', 'current_prefix');

Make sure to change old_prefix and new_prefix accordingly.

You can find the current prefix from wp-config.php.


If it’s still not working check all the rows manually and also all the other tables.


This solved the problem for me.

Comments

Post a Comment

Popular posts from this blog

How to split large mp3 files using mp3splt

If you have a  lengthy  or large MP3 file and you want to  split  it into files of smaller size or duration, You can easily do this using mp3splt. Mp3splt   is an utility to split mp3 and ogg vorbis digital audio files without the need of decoding. It can be used to split a file into no of tracks of fixed duration and size or specified  split points. It supports variable bit rate mp3 files, silent detection, splitting with local .XMCD, .CDDB or .CUE file splitpoints or from external servers like   tracktype.org . It copies the original files first and then generates new, smaller files during the process of splitting without altering the original file. It does not do any encoding or decoding so the splitting is very fast and lossless. Steps to follow Navigate to directory where you have downloaded mp3splt { if using portable version } . Run and execute mp3slpt using the command   mp3splt  . Specify the options according to which you wanna split. The basic syntax is   mp3splt [file path]...
Post a Comment
Read more

Convert/Compress multiple images at once using IrfanView

Want to convert/compress multiple images at once? You can easily do this using a very useful and small image viewer called IrfanView. IrfanView is free image viewer that can be used to view, convert, optimize, process image files of numerous formats. It can also handle few video/audio formats, and has limited image creation and painting capabilities. It’s like an Swiss Army Knife for images. Some Features:— You can read more about IrfanView Here. Let’s get started. Open IrfanView and select Batch Conversion/Rename option from File Menu(Shortcut Key: B ) Navigate to folder where your images are located and Add the ones you want to compress. Choose the options you want to do from left window pane. Select the format and other options like Compression Ratio etc. from the Batch Conversion Settings Menu. Choose the options according to your need. After you are all set Click Start Batch. You images will be converted and you can find them in the specified output directory. Note—...
Post a Comment
Read more