Level 122
You are asking if it is possible to run phpmyadmin under Herd, or run a database server under Herd?
Sep 13, 2023
16
Level 1
Herd Localhost management Database
is it possible to run database on phpmyadmin with Herd localhost ?
Level 1
@Snapey yes
Level 122
@heshamHanafi I asked A OR B? - the answer cannot be "Yes"
1 like
Level 1
@Snapey A sorry
Level 80
@heshamhanafi phpMyAdmin is just a PHP app for viewing a database. You don’t “run” a database in it; it’s just a tool for accessing a database. So you need a database elsewhere; phpMyAdmin doesn’t create nor run databases.
Level 15
Yes, you can run phpMyAdmin using Laravel Herd. All you need to do is download the ZIP file, unzip it, and rename the folder to whichever .test URL you want to access phpMyAdmin from.
Place that folder inside your Herd directory, by default this should be ~/Herd. Then enter {folderName}.test and phpMyAdmin should be running like normal.
In the end, it is just a PHP application after all. Not an actual database like MySQL or PostgreSQL. 🤷♂️
If you want to install a database I'd recommend using either DBngin or installing directly via Homebrew.
2 likes
Level 1
@thinkverse herd recommended use DBngin it used TablePlus it is bad to manage my database i want and alternative
Level 15
@heshamHanafi DBngin isn't a database management tool like TablePlus or PHPMyAdmin, it's a tool for installing databases like MySQL and Postgres. There was some confusion above if you wanted an actual database, like MySQL, or a management tool like PHPMyAdmin.
Given that confusion, I added that if you wanted to install an actual database using DBngin is a great choice.
You don't have to use TablePlus with DBngin, you can use whatever management tool you'd like, for instance, PHPMyAadmin works just as fine. DBngin might recommend TablePlus given it's actually built by the same team.
1 like
Level 1
@thinkverse that's good how to use phpmyadmin with DBngin ?
Level 15
@heshamHanafi as I explained above, you only need to download and unzip PHPMyAdmin and place that folder where Herd parks your sites, by default it should be ~/Herd. Rename that folder to whatever .test URL you want to access PHPMyAdmin from. Then PHPMyAdmin should work like normal since it's all local installations.
If your MySQL installation doesn't have a password you'd need to add a config.inc.php file in the PHPMyAdmin root directory and change AllowNoPassword from false to true. That's done easiest by copying the config.sample-inc.php sample config file.
6 likes
Level 1
@thinkverse i try it
Level 2
@thinkverse does this mean phpmyadmin can not be run and accessed globally? I had laravel valet installed and had phpmyadmin running there, now i have just recently installed laravel HERD , I cannot repurpose that valet phpmyadmin installation for HERD right? I need to reinstall again in the HERD folder right, at least that is how i understand your response here. Thanks in advance
Level 1
MySQL can be installed as a stand-alone server on Windows-based systems.
https://dev.mysql.com/downloads/installer/
Then you can have a PMA in the herd as a normal php app as said by @thinkverse and point to this new server on your system.
A quick Google search pulled up this link https://www.dataquest.io/blog/install-mysql-windows/
Level 29
@heshamhanafi Yes, you can do it simply, just download do next steps: 1- download phpmyadmin and extract folder and renamed phpmyadmin 2- move phpmyadmin folder inside Herd folder 3- open os terminal (in windows use powerShell) and run next command 4- herd link 'full path to the phpmyadmin folder'
Level 2
@abdosaeedelhassan before running the command, should i cd into herd folder or to phpmyadmin (which is inside the Herd folder)?
Level 29
@screwtape_mk herd command in terminal will be executed from any where if herd installed correctly then you need to run command from any dir like herd link 'pass your phpmyadmin dir path her '
Please or to participate in this conversation.