How can i access my local phpmyadmin and mysql

Support Uncategorized
1

i am creating custom webapp with using this software as serverso how can i access mysql database admin area

2

Go into Local
Click your site
Click “Database” in the right-hand area
Click one of the available buttons to access the database

3

Just to explain, Local doesn’t come with phpmyadmin installed.

It comes with Adminer (it’s similar) that can be accessed through the button on the “Database” tab
image

Sequel Pro is a Database tool that works on MacOSX only.

2 Likes
4

Thanks bro but please if you can also tell me about installing composer on local by flywheel help me i am really new to local and i am from xammp background

5

Just to avoid duplicate content, and more important, answer this in a topic of another query, I’ll link you some other topics that I found looking for “composer install” here on the forum:

Those might give you the solution or maybe a hint on how to do it. As far as I know, it’s not much different from XAMPP, only thing is that the paths are different.

1 Like
6

I don’t know whether this is a proper solution. But it works as expected.

  1. Create a new website with Local.

  2. Clean the public folder and replace the PHPMyAdmin source code.

  3. Edit config.inc.php file to add multiple servers to the PHPMyAdmin login screen. (selectbox)

    $i++;
    $cfg[‘Servers’][$i][‘verbose’] = ‘Dev 1’;
    $cfg[‘Servers’][$i][‘host’] = ‘localhost’;
    $cfg[‘Servers’][$i][‘port’] = ‘10004’;
    $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;

Change the port number and verbose according to your requirements.
Source: PHPMyAdmin to Local by Flywheel

7

Thank you varunalex for sharing this!

I got stuck with getting port number. It looks like Local decided to remove port and host but only keep socket. Do you know other way to get the port number or connect a site with PHPMyAdmin?

8

For unix-y systems, Local only uses unix sockets. If you want to enable access over ports, then you can follow the steps outlined in this FAQ: