BLOG ARCHIVES

  • HOW TO RESET A WORDPRESS PASSWORD FROM PHPMYADMIN

    AUTHOR: // CATEGORY: Development, Open Source, Wordpress

    No Comments
    How to Reset a WordPress Password from phpMyAdmin

    Knowing how to reset your WordPress password from phpMyAdmin is one of the essential things you should know about because for some reason if your site is hacked, or something else, you are no longer able to login to your admin panel using the login information, and you are not able to reset the password via email, this method can be very useful. We have helped three users with the same issue therefore we have decided to do this writeup.

    Every WordPress blog uses a MySQL Database which can be accessed through your phpMyAdmin even if you are not using cPanel hosting. Follow the following steps to reset your WordPress password:

    Video Tutorial

    If you don’t like the video or need more instructions, then continue reading.

    Step 1 – Identify the Name of your Database

    It is always good to know the name of your WordPress Database. Sometimes you might be running multiple installations within the same database, then you will need to know exactly where to look for to reset the password. The best place to look is your wp-config.php file which is located in your root WordPress Directory. In there you will find the name of your database.

    Step 2 – Locating Database and Editing the Fields

    In your cPanel or other admin panel, you will need to access your MySQL database and then browse it via phpMyAdmin.

    phpMyAdmin in cPanel

    Once you are in phpMyAdmin, you will need to select the correct database on the left hand side. Look for the name that you found in your wp-config.php and click on that. You will see a list of tables with a prefix wp_ for the most part.

    If you changed your prefix during installation, then you would be looking for that specific prefix “for ex: wp673_”.

    You will look for the table wp_users, click on it and then click on the Browse Tab.

    phpMyAdmin Browse

    Click on the Pencil (Edit) Icon to reset your Password.

    phpMyAdmin Edit

    Now you will see a field that looks like this:

    phpMyAdmin Edit field

    Edit the user_pass field value. You will notice that there are a lot of random characters in the password field. Due to security reasons, WordPress stores the passwords as MD5 Hash rather than Plain text.

    This means that you will not be able to enter plain text as the password. You would need to use one of the MD5 generators online to generate your password.

    Recommended Tool: JavaScript MD5

    Simply type your password in that tool and generate MD5 results. Copy and paste the code you get from the converter into your phpMyAdmin field and click Go to save changes.

    You have now successfully changed your WordPress Password from phpMyAdmin.

    All credits to http://www.wpbeginner.com/beginners-guide/how-to-reset-a-wordpress-password-from-phpmyadmin/

  • MAXIMUM FILE UPLOAD SIZE – PHP.INI

    AUTHOR: // CATEGORY: Development, Open Source, Wordpress

    1 Comment

    On shared hosting/VPN or cloud if you’d like to increase the default max file upload size from 10M check our the below

    You need to set the value of upload_max_filesize and post_max_size in your php.ini (in the example below 40M is what I’ve set the max upload to, however you can change to whatever you’d like eg. 100M etc.):

    ; Maximum allowed size for uploaded files.
    upload_max_filesize = 40M
    
    ; Must be greater than or equal to upload_max_filesize
    post_max_size = 40M
    
    Or in the cursed .htaccess file 
    
    php_value upload_max_filesize 40M
    php_value post_max_size 40M

    Happy uploading ....

  • CODE ACADEMY

    AUTHOR: // CATEGORY: Development, Open Source

    No Comments

    A great free way to learn to code http://www.codecademy.com/ if you interested in any development. Simple and very effective.