Troubleshoot phpMyAdmin Starting Problems
In this article, I have included some issues and ways to troubleshoot phpMyAdmin starting problems. If you didn’t install phpMyAdmin then you can do this here.
Problem 1 – phpMyAdmin Error 404 Page Not Found
Problem 2 - Your PHP installation appears to be missing the MySQL extension which is required by WordPress
This takes a little more manual work. Read ahead.
1. Fire-up putty. Open php.ini file. It is a php configuration file. Mostly, present in ‘/etc’ folder (at least in CentOS). Paste the following;
|
1 |
nano /etc/php.ini |
TIP: Use Sudo prefix if on Amazon linux or using ec2-user. Nano is text editor. If you don’t have it then install it via “yum install nano” or “sudo yum install nano”.
2. Press Ctrl+w and type ‘extension=m’ and hit enter. You have to find something like; ‘extension=mysql.so’ or ‘extension=msql.so’
* Notice the ‘y’. There is no ‘y’ in newer mysql versions.
3. Uncomment that line – means remove that “;” mark.
4. Add following lines to avoid any issues;
|
1 2 3 |
extension=php_mysqli.dll extension=php_mysqli_mysqlnd.dll extension=php_mysqli_libmysql.dll |
5. Save the file using “Ctrl+X” then type ‘Y’ and hit enter.
Warning: File will not save if you are on Amazon linux and didn’t use ‘sudo’ to edit the php.ini file.
6. Now restart the Apache server
|
1 |
service httpd restart |
Try to access the phpmyadmin from browser. If it still doesn’t work then it means the extension which are needed aren’t installed. Read ahead.
Problem 2: Missing extensions
1. Copy paste the following one by one.
|
1 |
yum install -y mysql mysql-server |
|
1 |
yum install -y php php-mysql |
|
1 |
yum -y install php-mbstring php-mcrypt php-gd |
2. Now restart the apache server.
|
1 |
service httpd restart |
or
|
1 |
/etc/init.d/httpd restart |
3. Go to browser and try to access it using; ‘yourdomain.com/phpmyadmin’
It should work now.
Problem 3 – MySQL root login password:
This one is simple to fix. You can do it via webmin or putty. Read this one.
So we are done with Troubleshoot phpMyAdmin Starting Problems. Let me know any other issues.
—————————————————————————————————————————————————-
Troubleshoot phpMyAdmin Starting Problems by Mrinal Buddekar is licensed under a Creative Commons Attribution-NonCommercial-NoDerivs 3.0 Unported License.
Mrinal Buddekar
Latest posts by Mrinal Buddekar (see all)
- Sneak Peek – Amazing and Stunning New Google Maps - May 26, 2013
- Free 50 GB Lifetime Box.com for Xperia Android Still Working - May 19, 2013
- How to Setup and Configure TP-LINK TL-MR3020 - May 12, 2013
Pingback: Install phpMyAdmin on VPS or Amazon EC2 and VPC
Pingback: phpMyAdmin Error 404 Page Not Found