Unable to establish a PHP session – PHPMyAdmin error


Cheap reseller Hosting


phpmyadmin error

PHPMyAdmin error :

Do you ever come across the following error when you access PHPMyAdmin from cPanel.

 

“Access Denied Unable to establish a PHP session. If you believe that this is in error or inadvertent, contact your system administrator and ask them to review your server settings.”

 

Normally, you will get this error when the permission or ownership of the tmp folder for this user is wrong. That is, make sure the ownership of /home/$username/tmp folder has ownership set to $user and permission as 755. If it is not, you will face the same problem.

 

Solution :

 

Step 1 : Login to the server via SSH as root.

Step 2 : Check the permission and ownership of /home/$user/tmp folder.

Step 3 : Set ownership as $user by using following command

# chown $user. /home/$user/tmp

Step 4 : Set permission of the tmp folder to 755 by using following command

#chmod 755 /home/$user/tmp

.
.
.
.
.
.
.
.

 

That’s it!!!

$user can be replaced with your respective username.

 

 


Cheap web Hosting


How to Install phpmyadmin on centOs 7


Cheap reseller Hosting


phpmyadmin on centOs 7 

phpMyAdmin is an open source tool used for the administration of MySQL. phpMyAdmin depends on the LAMP stack. It requires Apache2 or any compatible web servers, MySQL and PHP. This post will show you how to install phpmyadmin on centos 7.

Install-phpMyadmin-CentOS

Installation : 

Step 1 : 

Download epel-release-7-x.noarch.rpm

Step 2 :

Install epel-release-7-x.noarch.rpm file

Step 3 : 

Copying the rpm link by using follownig command

[root@hostripples ~]# rpm -ivh http://epel.mirror.net.in/epel/7/x86_64/e/epel-release-7-1.noarch.rpm

Step 4 : 

Now, update repositories by issuing follownig command

[root@hostripples ~]# yum check-update

Step 5 :

Install phpmyadmin package along with dependencies

[root@hostripples ~]# yum -y install phpmyadmin

When you are finished

Step 6 :

Open /etc/httpd/conf.d/phpMyAdmin.conf file and edit as follows and Find follownig lines.

Note : ( you are found these line 2 times )

# Apache 2.4
<RequireAny>
Require ip 127.0.0.1
Require ip ::1
</RequireAny>

 

Replace with

 

# Apache 2.4
<RequireAny>
# Require ip 127.0.0.1
# Require ip ::1
Require all granted
</RequireAny>

Step 7 :

Then, Restart Apache service by using following commands

[root@hostripples ~]# systemctl restart httpd.service

Step 8 :

Now open http://serverIP/phpmyadmin in your browser.

.
.
.
.
.

Congratulations! You have just installed phpMyAdmin on your CentOS 7

 

You can login using root as username and mysql root password.

 

 


Cheap web Hosting


How to Import Database using PHPMyAdmin


Cheap reseller Hosting


Import Deatabase

phpMyAdmin makes the task of managing your MySQL databases easier and more efficient, and it allows you to manage those available databases from anywhere. With phpMyAdmin, you can create, edit, back up, import, export, and delete databases, as well as manage database tables.

Import Database using PHPMyAdmin

1) Login to cPanel

2) Open phpMyAdmin and click the phpMyAdmin icon

3) Select the database that you need to Import

4) Click Import Button

5) Under File to Import, click Browse Button

6) Select the backup file you previously created (it will be either a .sql .zip or .tar.gz file).

7) Click Go Button

8) When the database has been imported successfully, you will see the message to: Import has been successfully finished, ## queries executed.

.

.

.

 

Congratulations, you have just imported a database!


Cheap web Hosting