Install phpMyAdmin on CentOs 6 and had interesting walkthrough of the installation
1. Get the latest copy of phpMyAdmin from sourceforge
wget http://downloads.sourceforge.net/project/phpmyadmin/phpMyAdmin/3.5.7/phpMyAdmin-3.5.7-english.tar.gz?r=http%3A%2F%2Fsourceforge.net%2Fprojects%2Fphpmyadmin%2Ffiles%2FphpMyAdmin%2F3.5.7%2F&ts=1361966494&use_mirror=jaist
2. Extract the files
tar -zxvf phpMyAdmin-3.5.7-english.tar.gz
3. move the extracted files to proper location
mv phpMyAdmin-3.5.7-english.tar.gz /var/www/html/phpmyadmin
4. cd /var/www/html/phpmyadmin
5. Make a copy of configuration files
cp config.sample.inc.php config.inc.php
6. Modify the values vi config.inc.php
$cfg[‘Servers’][$i][‘auth_type’]=’cookie’; to $cfg[‘Servers’][$i][‘auth_type’]=’http’;
7. Restart apache from any of command
service httpd restart – Work for me
/etc/init.d/httpd restart
8. Open browser on server
http://localhost/phpMyAdmin
You may end in following errors
1. 404 Not Found Error
Please make sure you push your phpMyAdmin directory in your webroot. In my case it’s /var/www/html
2. 403 Forbidden Error
I spend good amount of time finding why access is forbidden and finally did following setting
2.1 Go to /etc/httpd/conf.d/
2.2 vi phpMyAdmin.conf
2.3 Add following lines
Order allow,deny
Options Indexes
Allow from all
Still not able to access, try disabling the SElinux
SElinux is extra security layer in Linux and sometimes it provide conflicts for apache to work
vi /etc/selinux/config
Modify SELINUX=enforcing to SELINUX=disabled //Discuss with your senior. Mine is test server.
Restart your machine
http://localhost/phpMyAdmin prompt for username/password for mysql login 🙂
phpMyAdmin: Script timeout passed, if you want to finish import, please resubmit same file and import will resume. Posted by alex in Errors
When attempting to import a gzip sql file into MySQL via phpMyAdmin I continued to get the error below. There are a couple ways to get around this issue which depend on if you have access to the server or not. Below I will describe two ways to resolve the error if you have access to the server and two ways to resolve the issue if you do not have access to the server. Error: Script timeout passed, if you want to finish import, please resubmit same file and import will resume.
Resolution With Access To Server: 1.Import Using CLI:Importing using mysql commands are much easier to complete and they are also much more effecient. Use the syntax below to import a SQL file into a MySQL database.
2.Modify Timeout Setting:You can modify the config.inc.php file on your server which is located inside the phpMyAdmin root directory. The setting which needs to be modified or added to the config.inc.php file is displayed below. This setting which is set in the phpMyAdmin configuration file is the specific item that causes the exact error in the title of this post.
view source
1 $cfg[‘ExecTimeLimit’] = 0;
[mysqld]
max_allowed_packet = 500M
Find:
post_max_size = 8M
upload_max_filesize = 2M
max_execution_time = 30
max_input_time = 60
memory_limit = 8M
Change to:
post_max_size = 750M
upload_max_filesize = 750M
max_execution_time = 300
max_input_time = 540
memory_limit = 1000M
Recent Comments