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: 
As I was looking for an answer to this question, I found the following method that did the job for me:

[How to access phpMyAdmin directly from my domain?](http://kb.siteground.com/how_to_access_phpmyadmin_directly_from_my_domain/) 

This worked well for me, although I'm using a **different** hosting provider then Siteground.

Steps I followed:

* Downloaded the **phpmyadmin** installation package. I found the appropriate version, as hosted on my server at [sourceforge.net/projects/phpmyadmin/files/phpMyAdmin](http://sourceforge.net/projects/phpmyadmin/files/phpMyAdmin/)
* Extracted the package.
* Uploaded the files into a suitable folder. I used: public\_html/phpmyadmin/
* Now, via the direct URL [http://yourdomain.com/phpmyadmin] I can strictly grant access to a specific database, I have created in cPanel (using the specific user name + password).

Please note this extra security measure:

* For additional security we would also recommend you to [Password Protect the directory](http://www.siteground.com/tutorials/cpanel/pass_protected_directories.htm) in which the tool is installed.
cPanel user account has a privileges to control all created databases under cPanel account, And because phpMyAdmin in cPanel is using cPanel authentication you are automatically redirected to the phpMyAdmin control page without asking for login info.

Your target could be done with changing cPanel password without changing mysql user password.

You can do the following steps : 

1 - Create MySQL user and add this user to database with full privs.

2 - Create new cPanel account Login through new account Change new cpanel

3 - user password through "Change Password" And un-check Allow MySQL
 password change. 

4 - Click phpMyAdmin from the new cpanel account and you
 will be asked for login info

5- Type the login info of the created mysql
 user in step1.

You can now login to the required database without old account cPanel info.

There is another soln is to copy **/usr/local/cpanel/base/3rdparty/phpMyAdmin** to **/usr/local/apache/htdocs** and login through **http://ip/phpMyAdmin**

Don't forget to change the **auth\_type** in **/usr/local/apache/htdocs/phpMyAdmin/config.inc.php** to http or cookie