March 2024
M T W T F S S
 123
45678910
11121314151617
18192021222324
25262728293031

Categories

March 2024
M T W T F S S
 123
45678910
11121314151617
18192021222324
25262728293031

Install phpMyAdmin on CentOs 6

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

 

Leave a Reply

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>