Install phpMyAdmin on CentOs 6 and had interesting walkthrough of the installation<\/p>\n
1. Get the latest copy of phpMyAdmin from sourceforge<\/p>\n
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<\/p>\n
2. Extract the files<\/p>\n
tar -zxvf phpMyAdmin-3.5.7-english.tar.gz<\/p>\n
3. move the extracted files to proper location<\/p>\n
mv phpMyAdmin-3.5.7-english.tar.gz\u00a0\/var\/www\/html\/phpmyadmin<\/p>\n
4. cd \/var\/www\/html\/phpmyadmin<\/p>\n
5. Make a copy of configuration files<\/p>\n
cp config.sample.inc.php config.inc.php<\/p>\n
6. Modify the values vi config.inc.php<\/p>\n
$cfg[‘Servers’][$i][‘auth_type’]=\u2019cookie\u2019; to $cfg[‘Servers’][$i][‘auth_type’]=\u2019http\u2019;<\/p>\n
7. Restart apache from any of command<\/p>\n
service httpd restart \u2013 Work for me
\/etc\/init.d\/httpd restart<\/p>\n
8. Open browser on server<\/p>\n
http:\/\/localhost\/phpMyAdmin<\/p>\n
You may end in following errors<\/p>\n
1. 404 Not Found Error
Please make sure you push your phpMyAdmin directory in your webroot. In my case it\u2019s \/var\/www\/html<\/p>\n
2. 403 Forbidden Error
I spend good amount of time finding why access is forbidden and finally did following setting<\/p>\n
2.1 Go to \/etc\/httpd\/conf.d\/<\/p>\n
2.2 vi phpMyAdmin.conf<\/p>\n
2.3 Add following lines<\/p>\n
Order allow,deny
Options Indexes
Allow from all<\/p>\n
Still not able to access, try disabling the SElinux<\/p>\n
SElinux is extra security layer in Linux and sometimes it provide conflicts for apache to work<\/p>\n
vi \/etc\/selinux\/config
Modify SELINUX=enforcing to SELINUX=disabled \/\/Discuss with your senior. Mine is test server.
Restart your machine<\/p>\n
\u00a0http:\/\/localhost\/phpMyAdmin prompt for username\/password for mysql login \ud83d\ude42<\/p>\n
<\/p>\n
phpMyAdmin: Script timeout passed, if you want to finish import, please resubmit same file and import will resume. \u00a0Posted by alex in Errors<\/p>\n
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. \u00a0 Error: Script timeout passed, if you want to finish import, please resubmit same file and import will resume. \u00a0<\/p>\n
Resolution With Access To Server: \u00a01.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. \u00a0<\/p>\n
<\/p>\n
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. \u00a0<\/p>\n
view source<\/p>\n
1 $cfg[‘ExecTimeLimit’] = 0;<\/p>\n
[mysqld]<\/p>\n
max_allowed_packet = 500M<\/p>\n
\u00a0
Find:
post_max_size = 8M
upload_max_filesize = 2M
max_execution_time = 30
max_input_time = 60
memory_limit = 8M <\/p>\n
Change to:
post_max_size = 750M
upload_max_filesize = 750M
max_execution_time = 300
max_input_time = 540
memory_limit = 1000M<\/p>\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
Install phpMyAdmin on CentOs 6 and had interesting walkthrough of the installation<\/p>\n
1. Get the latest copy of phpMyAdmin from sourceforge<\/p>\n
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<\/p>\n
2. Extract the files<\/p>\n
tar -zxvf phpMyAdmin-3.5.7-english.tar.gz<\/p>\n
3. move the extracted files to proper location<\/p>\n
mv phpMyAdmin-3.5.7-english.tar.gz \/var\/www\/html\/phpmyadmin<\/p>\n
4. cd \/var\/www\/html\/phpmyadmin<\/p>\n
5. Make a copy of configuration files<\/p>\n
cp config.sample.inc.php config.inc.php<\/p>\n
6. […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12],"tags":[],"_links":{"self":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/1921"}],"collection":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1921"}],"version-history":[{"count":11,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/1921\/revisions"}],"predecessor-version":[{"id":1925,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/1921\/revisions\/1925"}],"wp:attachment":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1921"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1921"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1921"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}