how to install phpmyadmin for database viewing?

Questions about applications and software
Forum rules
Before you post please read how to get help
charroo
Level 3
Level 3
Posts: 100
Joined: Mon Aug 14, 2017 9:45 am
Location: IL

how to install phpmyadmin for database viewing?

Postby charroo » Tue Oct 17, 2017 2:26 pm

hi

i failed at installing wordpress offline.

so i'm wondering if it is any simple to install phpmyadmin so i can view a database contents?

i saw a depricated guide on the web so asked here

thanks

User avatar
WharfRat
Level 19
Level 19
Posts: 9917
Joined: Thu Apr 07, 2011 8:15 pm

Re: how to install phpmyadmin for database viewing?

Postby WharfRat » Wed Oct 18, 2017 12:15 am

phpmyadmin is available in the repos and can be installed with sudo apt-get install phpmyadmin

It will also install some mysql components.

You can get more information with apt show phpmyadmin in the terminal.
Image ImageImage

charroo
Level 3
Level 3
Posts: 100
Joined: Mon Aug 14, 2017 9:45 am
Location: IL

Re: how to install phpmyadmin for database viewing?

Postby charroo » Fri Oct 20, 2017 3:01 am

thanks

and after installing it how exactly do i open my sql for viewing?

typing

Code: Select all

mysql -u username -p database_name < localhost.sql
?

afte typing this it is asking for a password

User avatar
WharfRat
Level 19
Level 19
Posts: 9917
Joined: Thu Apr 07, 2011 8:15 pm

Re: how to install phpmyadmin for database viewing?

Postby WharfRat » Fri Oct 20, 2017 11:06 pm

I haven't used mysql and phpmyadmin in a long time so I can't be of much more help here.

From what I remember you should have been prompted during installation for user and passwords for both phpmyadmin and mysql.

If you messed something up during that process you can run sudo dpkg-reconfigure phpmyadmin to go through the setup again.

phpmyadmin should be accessible with http://localhost/phpmyadmin
Image ImageImage

charroo
Level 3
Level 3
Posts: 100
Joined: Mon Aug 14, 2017 9:45 am
Location: IL

Re: how to install phpmyadmin for database viewing?

Postby charroo » Sat Oct 21, 2017 9:46 am

i'll try
thank you!!


Return to “Software & Applications”

Who is online

Users browsing this forum: Google [Bot] and 17 guests