Luckily, by updating the permissions of a couple specific files, you can usually resolve this issue in just a few steps.

Updating Permissions for phpMyAdmin

To change the permissions settings, follow these steps:

1. To start, check the current permissions settings for the following files:

   /usr/local/cpanel/3rdparty/bin/php

   /usr/local/cpanel/3rdparty/bin/php-cgi

   To check the permissions, you’ll need to use the command:

   ls -l

2. The files listed above should be set to 755 permissions. When listed out using the ls -l command, they should look like: rxxr-xr-x. If not, then change the permission to 755 using the command:

   chmod 775

   followed by the location of the file you’re changing.

3. Once the permissions have been changed, execute the command shown below from the shell.

   /scripts/makecpphp

Now, with these permissions fixed, you should not receive the phpMyAdmin 500 internal server error anymore.

Popular Links

Looking for more information on phpMyAdmin? Search our Knowledge Base!

Interested in more articles about Databases? Navigate to our Categories page using the bar on the left or check out these popular articles:

• View the Contents of a Table in a SQL Server Database Using Enterprise Manager
• Create a MySQL Backup from Command Line – MySQL Import SQL File
• How to Install SQL Server 2012 Express on Windows Server 2012

Popular tags within this category include: MySQL, MSSQL, phpMyAdmin, PostgreSQL, and more.

Don’t see what you’re looking for? Use the search bar at the top to search our entire Knowledge Base.

The Hivelocity Difference

Seeking a better Dedicated Server solution? In the market for Private Cloud or Colocation services? Check out Hivelocity’s extensive list of products for great deals and offers.

With best-in-class customer service, affordable pricing, a wide-range of fully-customizable options, and a network like no other, Hivelocity is the hosting solution you’ve been waiting for.

Unsure which of our services is best for your particular needs? Call or live chat with one of our sales agents today and see the difference Hivelocity can make for you.

The post How to Resolve phpMyAdmin 500 Internal Server Error appeared first on Hivelocity Hosting.

You have to run following sql queries either on mysql prompt or phpmyadmin :

UPDATE phpbb_config SET config_value = ‘ID_NUMBER_HERE’ WHERE config_name = ‘default_style’;

UPDATE phpbb_config SET config_value = ‘1’ WHERE config_name = ‘override_user_style’;

If not , then you can refer :

https://www.phpbb.com/kb/article.php?article_id=13

The post How will you fix phpbb:critical error? appeared first on Hivelocity Hosting.

a. Open phpMyAdmin.

b. Select your database by clicking the database name in the list on the left of the screen.

c. Click the Export link.

This should bring up a new screen that says View dump of database (or something similar).

d. In the Export area, click the select all link to choose all of the tables in your database.

e. In the SQL options area, click the right options.

f. Click on the Save as file option and the corresponding compression option and then click the ‘Go’

Button. A dialog box should appear prompting you to save the file locally.

It is also very easy to restore your database and as well as backing it up.

a. Open phpMyAdmin.

b. Create an appropriately named database and select it by clicking the database name in the list on the

left of the screen. If you would like to rewrite the backup over an existing database then click on the

database name, select all the check boxes next to the table names and select Drop to delete all

existing tables in the database.

c. Click the SQL link. This should bring up a new screen where you can either type in SQL commands,

or upload your SQL file.

d. Use the browse button to find the database file.

e. Click Go button. This will upload the backup, execute the SQL commands and re-create your

database.

The post How to backup and restore the database via phpmyadmin? appeared first on Hivelocity Hosting.

b) Search for phpmyadmin icon under databases menu

c) Click on it , it should open the phpmyadmin window

d) At your left hand side you should see the list of existing databases

e) If you click on any database , on your right hand side pane it should show you all the tables

f) On the top you should see the tools such as query , import , export which can be used accordingly

The post How to manage my mysql database through phpmyadmin in cPanel appeared first on Hivelocity Hosting.

The post Managing a MySQL Database in phpMyAdmin in Hsphere appeared first on Hivelocity Hosting.

Additional Links:

Looking for more information on DirectAdmin? Search our Knowledge Base!

In need of more great content? Interested in VPS, Private Cloud, or Colocation? Check out our recent posts for more news, guides, and industry insights!

The post Managing a MySQL Database with phpMyAdmin in DirectAdmin appeared first on Hivelocity Hosting.

The post Managing Databases with phpMyAdmin in cPanel appeared first on Hivelocity Hosting.

Inorder to install phpmyadmin for the server Download phpmyadmin from

https://www.phpmyadmin.net/home_page/downloads.php

Download it in root of the server.

Unzip the file.

Run the installer.

Once the installer is run you need to update the login and password and the link via which you will access it in the config.php file in the phpmyadmin folder.

Now if this is server specific the link in config.php will contain server IP.

If it is domain specific you need to download phpmyadmin in the root folder of the domain and untar it and in config file mention the link as

https://domain.com

Once done

For serverwide you can access it at

https://serverIP/phpmyadmin

And for domain specific you can access it at

https://domain.com/phpmyadmin

The post Install PhpMyAdmin appeared first on Hivelocity Hosting.

You should backup all your database files before it is transferred. You can do it so using two methods : 1) Using third party tool such as PhpMyAdmin.

2) Using ” dump” tool which comes bundled with MySQL.

Using PhpMyAdmin :

It is a PHP script which gives ability to interact you database.
To manage and manipulate MySQL databases use options under “export” section of PhpMyAdmin. Select the appropriate database and zip up the files it can save you bandwidth and time to download the backup file.
Now to transferring onto new server, first create a new database, unzip files and extract the backup then restore your database.
It also lets you mess up the database directly. There is no “undo” or “undelete” in your database. Always exercise caution when working with the database.

Most host have their control panel PhpMyAdmin pre-installed.

Using dump tool :

You have to use different commands at command line environment or UNIX shell environment.

Type command :

mysqldump -u [username] -p [password] –opt [databasename] > backup.sql

this command will take backup of your database.

Now on the new server, you can restore the database by inputting the following command:

mysql -u [username] -p [password]
The options in brackets need to be filled out with the appropriate information, such as, the username and password. It is also a good idea to take a “dump” of your database regularly for backup purposes in case the server fails or you have a corrupt database.

The post Transferring MySQL database to new server:: appeared first on Hivelocity Hosting.

The post Can you provide/recommend any tools for managing MySQL databases? appeared first on Hivelocity Hosting.

To run phpPgAdmin, do the following:

1. Select PGSQL DBs in the Databases menu.
2. Click the name of the database you would like to edit.
You can also start this utility from the PGSQL database management page:

3. Select PGSQL DBs in the Databases menu.
4. Click the Edit icon for the database you are going to edit:
5. In the form that appears, click Built in phpPgAdmin control panel to start editing your database
6. Follow the instructions of the phpPgAdmin control panel to edit your PgSQL DB

The post How do I modify PostgreSQL databases and user privileges? appeared first on Hivelocity Hosting.