For some reason, you might forgotten your osCommerce administrator login detail or you no longer able to log in anymore.
To overcome this problem, you may refer to the following step,
1. Log into the cPanel and navigate to the PHPMyAdmin icon.
2. Select the database used by the osCommerce and go to the administrators table.
3. Click on the Empty button to purge the administrators table data. (Assume you have only one administrator)
4. Now, go to your administrator page and you may enter the new administrator username and password.
If you are webmaster who using the web interface database management, you shall be familiar with phpMyAdmin.
Then you might get these error from your phpMyAdmin when you logged into the phpMyAdmin.
#2002 – The server is not responding (or the local MySQL server’s socket is not correctly configured)
To overcome this error, you could have 2 ways to solve the problem.
Check if your mysql.sock file missing from /tmp.
If it is really missing from /tmp, you may create a symbolic link from /var/lib/mysql/ to /tmp.
ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock
You might ask why must do this, you may check the file from /usr/local/cpanel/base/3rdparty/phpMyAdmin/config.inc.php and you need to check for the setting of cfg[‘Server’][‘socket’], and you will see the setting set to /tmp/mysql.sock.
Edit the following file.
Find $cfg[‘Servers’][$i][‘host’], change the value from localhost to 127.0.0.1.
Many WordPress user alway will facing WordPress appear empty page after upgrade to newer version of WordPress, 1 of the reason is due to you do not disable plugin before upgrade it.
Refer to the step below, you may disable the plugin through MySQL database(PHPMyAdmin).
1. Login to PHPMyAdmin.
2. Look to your databases(eg. mickgenie_wordpress).
3. Look to table named wp_options as browse it.
Continue reading How to manually disable WordPress Plugin