How to install phpMyAdmin

What is phpMyAdmin?

phpMyAdmin

phpMyAdmin is a free software tool written in PHP, intended to handle the administration of MySQL over the Web. phpMyAdmin supports a wide range of operations on MySQL and MariaDB. Frequently used database operations can be performed via the user interface:

  • managing databases
  • managing tables
  • managing columns
  • managing relations
  • managing indexes
  • managing users
  • managing permissions

While using phpMyAdmin you still have the ability to directly execute any SQL statement.

Where do I get phpMyAdmin?

Download the latest version from phpMyAdmin.net

How do I configure phpMyAdmin?

// linux
mv config.sample.inc.php config.inc.php

// windows - you can right-click and rename or
rename config.sample.inc.php config.inc.php
  • Open the config.inc.php and change the blowfish secret (on line 18).
/**
* This is needed for cookie based authentication to encrypt password in
* cookie. Needs to be 32 chars long.
*/
$cfg['blowfish_secret'] = '2nv30n98v23v23n90v23b781aswew70A'; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */
  • Open your browser and navigate to your new directory containing phpMyAdmin.
    • Using PHP?
    • Using Laravel Valet?
      • Rename your phpMyAdmin installation directory to /pma
  • Enter your database credentials and start using phpMyAdmin!

 

 

Visit sunny St. George, Utah, USA

Get In Touch

We would love to hear from you.

Please enter your email address.
Please enter a valid email address.
Please enter a message.
Please check your message for any errors.
Your message has been sent successfully.
Sorry, an error occured sending your message.
* required