Add phpMyAdmin to Local

[omrcnkpln]

Hi, You can just copy the phpmyadmin folder where stays in the wampserver, and paste it to public folder presents in the local sites project. Now you can use your project’s databases like ‘SITEURL’/phpmyadmin

[junglized]

Adminer works pretty well after recent updates TBH, so maybe let’s stay with this for now?

[bcpeterson7]

Windows PHPMyAdmin install:

I installed PHPMyAdmin 5.2.0 in C:/localroot/conf/phpmyadmin directory and then symbolically linked it like so:

1. Run PowerShell as administrator
2. Run this command:
   New-Item -ItemType SymbolicLink -Path "C:\localroot\app\public\phpmyadmin" -Target "C:\localroot\conf\phpmyadmin"

Then navigate to https://website.local/phpmyadmin

Alternatively you can just drop the phpmyadmin folder in your /public/ directory and then you don’t need to symbolic link anything.

I prefer the navigation of PHPMyAdmin. Also the Operations tab is very handy.

[Mr_Jeff]

I really just prefer working with Phpmyadmin and I would like to see that as an easy option.

That said one easy way I found to use phpmyadmin was to go phpmyadmin downloads downloaded the zip, go to Local Sites/site-name create a new folder ‘phpmyadmin’ and then unzip the content in there.
Then access via domain/phpmyadmin in the browser.

[Nick-B]

Thank you for sharing @Mr_Jeff!

[asd]

Here’s is the simplest solution:

1. downlad phpmyadmin official.
2. go to C:\Program Files (x86)\Local\resources\extraResources\
3. backup the folder named Adminer ( just in case something wrong happens. we are going to replace adminer with php my admin)
4. rename the Adminer folder to something else (admine backup)
5. copy the downloaded phpmyadmin folder (phpMyAdmin-5.2.1-all-languages in my case)
6. rename this phpMyAdmin-5.2.1-all-languages folder as Adminer. (now we replaced adminer with phpmyadmin)
7. open the config.sample.inc.php file an paste the below (numer 8), at the end of the file and rename it to config.inc.php
8. paste this:
   $i++;
   *$cfg[‘Servers’][$i][‘verbose’] = ‘mascom’; *
   $cfg[‘Servers’][$i][‘host’] = ‘localhost’;
   $cfg[‘Servers’][$i][‘port’] = ‘10006’;
   $cfg[‘Servers’][$i][‘socket’] = ‘’;
   $cfg[‘Servers’][$i][‘connect_type’] = ‘tcp’;
   $cfg[‘Servers’][$i][‘extension’] = ‘mysqli’;
   $cfg[‘Servers’][$i][‘auth_type’] = ‘cookie’;
   $cfg[‘Servers’][$i][‘AllowNoPassword’] = false;

in here:

$cfg[‘Servers’][$i][‘verbose’] = ‘mascom’;

is MY site name in local write YOURS! (i think you have to give the same name with the site name in local or maybe its not important i dont know. i aimed everyhing same to local)

$cfg[‘Servers’][$i][‘port’] = ‘10006’;

is MY port. learn your from Local Wp “Databse” tab of the site (i will ttry to upload ss if allowed here) and write YOURS
9. save the file. (config.inc.php)
10. go to local and click “OPEN ADMİNER EVO” as if you are opning adminer
11. it will open php my admin :))
12. enter the name and password and choose NOT localhost, choose your verbose name present in the list (it is your site name in local, where you wrote as verbose name. it will appear in the list under localhost in server selection. username and password are very likely to be root, root both.
13. Say lailaheillalah.