Question: I'm error checking a search index table (asIndex) that is built by a script from 25 tables.

Both the asIndex and Evaluations tables have multiple rows per address. 

So this query was an attempt to be sure that everywhere an index row has Evaluation = 'blue' that there was at least one row in Evaluations where Evaluation is set to 'blue'.
It works but it produces 40K rows.

```
SELECT 
    ev.`Street Name`, 
    ev.`Street Number`, 
    ev.Evaluation
FROM 
  `tblEvaluations` ev,
  `asIndex` asi
WHERE asi.`Evaluation` = 'blue'
AND asi.`StreetName` = ev.`Street Name`
AND asi.`StreetNumber` = ev.`Street Number`;

```

What I need to do is make a query that will list any address which has a blue Evaluation in the asIndex but for which there is no matching address in Evaluations table with a blue Evaluation value.

How do I select that negative match?

Answer: 
The phpMyAdmin which comes with cPanel (in the 3rdparty-directory) is apparently secured with the cpanel-authentication, so the answer is "no".

You could install your own phpMyAdmin (maybe it's even available in the script-center/one-click-installer) and set it up to directly authenticate on the MySQL-server with your custom MySQL-user or just let your user enter his credentials which you have supplied.
**You cannot give direct access to your phpMyAdmin without providing direct cPanel access as well.**

This is a security measure from cPanel as phpMyAdmin is known to be one of the most exploited PHP applications of all time. It is only available after you start your session by logging into cPanel.

**A nice work-around this is to do the following:**

Create a MySQL User for the other person. Assign that MySQL User to your Database. Both of those are done through:

**cPanel -> MySQL Databases**

After that you need to allow access for the other person by adding his/hers IP address in your Remote MySQL Connection - this is also a tool in cPanel

After that the other person will be able to connect to your Database without direct access to your cPanel nor phpMyAdmin, it can be done using software like [MySQL WorkBench](https://www.mysql.com/products/workbench/)