Searching Through a Database with phpMyAdmin

 

  1. This tutorial assumes you've already logged in to phpMyAdmin.
  2. Now let's learn how to use the Search feature.
  3. Click the database you wish to search here.

    phpma-search-frame03_1

  4. Then click the Search tab and enter words or values to search for in the database.
    phpma-search-frame04_1

  5. There are several options you can use to refine your search. This database only has one table (details), but if there were more, you could limit your search to specific tables here.

    phpma-search-frame05_1

  6. When ready, click Go to perform the search. This search found one match. Click Browse.

    phpma-search-frame06_1

  7. We can now make changes to the record that was found.

    phpma-search-frame10_1

  8. Click Go when finished.

 

Running SQL Queries on a Database with phpMyAdmin

 

  1. This tutorial assumes you've already logged in to phpMyAdmin. Now let's learn how to run SQL queries on a database.

    phpma-query-frame02_1

  2. Click the database table you wish to run a SQL query on.

    phpma-query-frame03_1

  3. Click the SQL button here.

    phpma-query-frame05_1

  4. Then type your SQL command. Click Go when finished.

    phpma-query-frame06_1

  5. In this case, we’re going to delete the address field from the details table using the command:

    ALTER TABLE details DROP COLUMN address;

  6. That's it! The SQL command is executed when you click Go. Let's go take a look.
  7. The address field is no longer in our details table.

    phpma-query-frame09_1

  8. You can also click the SQL button directly from the table view. Doing so presents a SQL query window that is partially filled in.

    phpma-query-frame10_1

 

Deleting Tables from a Database with phpMyAdmin

 

  1. This tutorial assumes you've already logged in to phpMyAdmin.
  2. Now let's learn how to delete a table from a database.
  3. Select the table you wish to delete here.

    phpma-deltable-frame2_1

  4. You can delete individual fields from this table by selecting them here then clicking the delete icon here.

    phpma-deltable-frame3_1

  5. However, in this tutorial we're going to demonstrate how to delete the entire table and everything in it.
  6. Click the Drop button here. Then click OK to confirm.

    phpma-deltable-frame4_1

  7. The addresses table has been deleted (or dropped) from the database.

    phpma-deltable-frame5_1

  8. The addresses table is no longer listed in our database's list of tables.

    phpma-deltable-frame6_1

 

How To Manage a MySQL Database with phpMyAdmin in cPanel

  1. This tutorial assumes you’ve already logged in to cPanel, and are starting on the home screen.
  2. Now let’s learn how to manage a database with phpMyAdmin.
  3. Click the "phpMyAdmin" icon.

    cpanel-pl-mysql-11-phpmyadmin-02

  4. This is the phpMyAdmin main page. It is from here that you can manage all MySQL databases that exist in your hosting account.

    cpanel-pl-mysql-11-phpmyadmin-03

  5. In the top left corner, you’ll see an entry with your account user name. Click the "plus sign" to its left.

    cpanel-pl-mysql-11-phpmyadmin-04

  6. You’ll now see a list of databases in your account. Click the one you want to manage.

    cpanel-pl-mysql-11-phpmyadmin-05

  7. You can now start managing your database. You can manage tables, add or delete entries, and perform queries among other things.

    cpanel-pl-mysql-11-phpmyadmin-06

 

How To Install and Configure phpMyAdmin on Fedora 23

PhpMyAdmin is an open-source tool used for the administration of MySQL. In addition to offering the capability to perform administrative tasks such as creating, editing, or deleting databases, and managing users and permissions, phpMyAdmin provides a graphical user interface to do all of these tasks and more.

Pre-Flight Check

  • These instructions are intended for installing phpMyAdmin on Fedora 23. If you’re using a different operating system, check out our guides to installing phpMyAdmin on Fedora 22, Ubuntu 15.04, CentOS 6 and CentOS 7.
  • For this tutorial, we’ll be using a Liquid Web Self Managed Fedora 23 server and logging in as root.
    A LAMP stack (Linux, Apache, MySQL and PHP) must be installed on your server.

Step #1: Install phpMyAdmin

First, we’ll follow best practices and ensure that the list of available packages is up to date:

dnf -y update

Then it’s a matter of running one command for installation:

dnf -y install phpmyadmin

Step #2: Find Your IP Address

You can determine your public IP address by visiting http://ip.liquidweb.com.

Step #3: Basic Configuration for phpMyAdmin

By default, the configuration for phpMyAdmin allows access only from the server on which it is installed. To be able to access phpMyAdmin’s web interface from your IP address, we’ll edit the Apache Virtual Host file created automatically during installation.

vim /etc/httpd/conf.d/phpMyAdmin.conf

For a refresher on editing files with vim, see New User Tutorial: Overview of the Vim Text Editor. If vim is not installed on your OS, you can follow our tutorial on installing vim at How to Install VIM (Visual editor IMproved) on Fedora 23.

In phpMyAdmin.conf, locate the following sections and change each IP address to the one you found in Step 2 (there should be a total of four instances of “127.0.0.1” which you’ll need to change to your IP address):

Require ip 127.0.0.1
Allow from 127.0.0.1
Require ip 127.0.0.1
Allow from 127.0.0.1

Then save and exit the file with the following command:

:wq

Now, restart Apache:

systemctl restart httpd

Verify that phpMyAdmin is working by visiting http://the_IP_of_your_server/phpmyadmin. For example: http://111.222.333.444/phpmyadmin.

Learn More

To create a database user, visit Create a MySQL User on Linux via Command Line.
To grant permissions to a database user, visit Grant Permission to a MySQL User on Linux via Command Line.
 

Error: Login without a password is forbidden by configuration (see AllowNoPassword) [SOLVED]

This error relates to logging into phpMyAdmin, an open source tool used for the administration of MySQL.

Once in awhile, perhaps on a Development server, MySQL won’t be setup with a root password. The aforementioned configuration is generally thought of as against best practices however, if it is what you’re dealing with, then it could also interfere with phpMyAdmin.

Pre-Flight Check

  • These instructions are intended specifically for solving the error: Login without a password is forbidden by configuration (see AllowNoPassword).
  • I’ll be working from a Liquid Web Self Managed Ubuntu 15.04 server, and I’ll be logged in as root.

The Error

The error will read “Login without a password is forbidden by configuration (see AllowNoPassword)” as shown below.

Error Login without a password is forbidden by configuration (see AllowNoPassword) [SOLVED]

Continue reading “Error: Login without a password is forbidden by configuration (see AllowNoPassword) [SOLVED]”

How to Install and Configure phpMyAdmin on Ubuntu 15.04

phpMyAdmin is an open source tool used for the administration of MySQL. In addition to offering the capability to perform administration tasks such as creating, editing, or deleting databases, and managing users and permissions, phpMyAdmin provides a graphical user interface to do all of these tasks and more.

Pre-Flight Check

  • These instructions are intended specifically for installing phpMyAdmin on Ubuntu 15.04.
  • I’ll be working from a Liquid Web Self Managed Ubuntu 15.04 server, and I’ll be logged in as root.
  • A LAMP, Linux, Apache, MySQL and PHP, must be installed on your server.

Continue reading “How to Install and Configure phpMyAdmin on Ubuntu 15.04”

How to Install and Configure phpMyAdmin on Fedora 22

phpMyAdmin is an open source tool used for the administration of MySQL. In addition to offering the capability to perform administration tasks such as creating, editing, or deleting databases, and managing users and permissions, phpMyAdmin provides a graphical user interface to do all of these tasks and more.

Pre-Flight Check

  • These instructions are intended specifically for installing phpMyAdmin on Fedora 22.
  • I’ll be working from a Liquid Web Self Managed Fedora 22 server, and I’ll be logged in as root.
  • A LAMP stack, meaning Linux, Apache, MySQL and PHP, must be installed on your server.

Continue reading “How to Install and Configure phpMyAdmin on Fedora 22”

How to Install and Configure phpMyAdmin on Fedora 21

phpMyAdmin is an open source tool used for the administration of MySQL. In addition to offering the capability to perform administration tasks such as creating, editing, or deleting databases, and managing users and permissions, phpMyAdmin provides a graphical user interface to do all of these tasks and more.

Pre-Flight Check

  • These instructions are intended specifically for installing phpMyAdmin on Fedora 21.
  • I’ll be working from a Liquid Web Self Managed Fedora 21 server, and I’ll be logged in as root.
  • A LAMP stack, meaning Linux, Apache, MySQL and PHP, must be installed on your server.

Continue reading “How to Install and Configure phpMyAdmin on Fedora 21”

How to Install and Configure phpMyAdmin on Fedora 20

phpMyAdmin is an open source tool used for the administration of MySQL. In addition to offering the capability to perform administration tasks such as creating, editing, or deleting databases, and managing users and permissions, phpMyAdmin provides a graphical user interface to do all of these tasks and more.

Pre-Flight Check

  • These instructions are intended specifically for installing phpMyAdmin on Fedora 20.
  • I’ll be working from a Liquid Web Self Managed Fedora 20 server, and I’ll be logged in as root.
  • A LAMP stack, meaning Linux, Apache, MySQL and PHP, must be installed on your server.

Continue reading “How to Install and Configure phpMyAdmin on Fedora 20”