MX Linux Forum

timkb4cq wrote: ↑Sat Oct 26, 2019 2:47 pm Phpmyadmin 4.9.1 with its not-in-debian-buster dependencies is now available in the MX-19 Test repository.
While recent versions of phpmyadmin are not yet in Debian or Ubuntu, I found the packaging here: https://salsa.debian.org/phpmyadmin-team (Salsa is a collaborative platform for Debian devs & outside developers to work together).
Given that it hasn't hit Debian Experimental yet I expect there will be ongoing tweaks - but it does build and install.

I've never used PHP nor any sql database so I'm not a good person to evaluate whether it works properly. Please leave feedback if you try this set of packages

Not working on my mx-linux19.2

fehlix wrote: ↑Sat Aug 22, 2020 8:12 am Just installed apache,mysql, php vi MXPI ->pop.apps:
server.png
and phpmyadmin installed via MXPI->MX testrepo works perfectly here:
phpmyadmin-login.png
create_db.png
If it is not working for you, you might give some indications, what you have done and what is not working.

timkb4cq wrote: ↑Sat Aug 22, 2020 8:38 am Phpmyadmin 4.9.5 is now in buster-backports. That version uses php-phpmyadmin-motranslator 5.0.0-2.
The 4.9.1 version I built for MX Test last year was built against a 4.x version of php-phpmyadmin-motranslator.

Either disable the the buster-backports repo to install the MX Test version, or better yet, install the newer buster-backports version.

php-phpmyadmin-motranslator           5.0.0-1~bpo10+1              
php-phpmyadmin-shapefile              2.1-3~bpo10+1                
php-phpmyadmin-sql-parser             4.6.1-2~bpo10+1              
phpmyadmin                            4:4.9.5+dfsg1-2~bpo10+1      

richb wrote: ↑Sat Aug 22, 2020 9:53 am Moderator
Please do not double post. If you want to add information, edit your first post.

peregrine wrote: ↑Sat Aug 22, 2020 8:25 am I have been using phpMyAdmin on my 19.2 since MX-19 was released. After you get it installed, you may find when you go to phpmyadmin , you can login with the password you set during the install but the user has no privileges.
I googled and found a fix:

Code: Select all

The fix was by reconfiguring phpmyadmin, and by answering some interactive questions.
sudo dpkg-reconfigure phpmyadmin
<Ok>
Reinstall database for phpmyadmin: <Yes>
Connection method for MySQL database server for phpmyadmin: TCP/IP
Host name of the MySQL database server for phpmyadmin: localhost
Port number for the MySQL service: 3306
MySQL database name for phpmyadmin: phpmyadmin
<Ok>
MySQL username for phpmyadmin: [Your MYSQL ADMIN USERNAME]
MySQL application password for phpmyadmin:  [ANY PASSWORD YOU WANT]
Password confirmation: pass
Name of the database’s administrative user:  [Your MYSQL ADMIN USERNAME]
Web server to reconfigure automatically: apache2
An error occurred while installing the database: ignore

Now you can connect into phpmyadmin (localhost/phpmyadmin) using your chosen username and password and you have the privileges you need

sudo cat /etc/mysql/debian.cnf
[client]
host     = localhost
user     = root
password =  root
...

sudo cat /etc/mysql/debian.cnf
[client]
host     = localhost
user     = root
password = 
...

peregrine wrote: ↑Sat Aug 22, 2020 8:25 am I have been using phpMyAdmin on my 19.2 since MX-19 was released. After you get it installed, you may find when you go to phpmyadmin , you can login with the password you set during the install but the user has no privileges.
I googled and found a fix:

Code: Select all

The fix was by reconfiguring phpmyadmin, and by answering some interactive questions.
sudo dpkg-reconfigure phpmyadmin
<Ok>
Reinstall database for phpmyadmin: <Yes>
Connection method for MySQL database server for phpmyadmin: TCP/IP
Host name of the MySQL database server for phpmyadmin: localhost
Port number for the MySQL service: 3306
MySQL database name for phpmyadmin: phpmyadmin
<Ok>
MySQL username for phpmyadmin: [Your MYSQL ADMIN USERNAME]
MySQL application password for phpmyadmin:  [ANY PASSWORD YOU WANT]
Password confirmation: pass
Name of the database’s administrative user:  [Your MYSQL ADMIN USERNAME]
Web server to reconfigure automatically: apache2
An error occurred while installing the database: ignore

Now you can connect into phpmyadmin (localhost/phpmyadmin) using your chosen username and password and you have the privileges you need

➜  ~ sudo dpkg-reconfigure phpmyadmin
/usr/sbin/dpkg-reconfigure: phpmyadmin is broken or not fully installed

timkb4cq wrote: ↑Sat Aug 22, 2020 10:12 am In order to install the new phpmyadmin version from backports you must disable the MX Test repo. Your screenshot shows it's still enabled.

timkb4cq wrote: ↑Sat Aug 22, 2020 10:23 am Synaptic -> Settings -> Repositories
Find the entries with testrepo in them and uncheck them. Save, Reload.

timkb4cq wrote: ↑Sat Aug 22, 2020 1:17 pm If you're still getting the error, try using aptitude

Code: Select all

sudo aptitude install -f

It will give you options to fix the problem. Choose one that doesn't remove a lot of programs, although removing php-myadmin related packages could be the key to getting a good install from backports.

➜  ~ sudo aptitude install -f
[sudo] password for hudacse6: 
No packages will be installed, upgraded, or removed.
0 packages upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
Need to get 0 B of archives. After unpacking 0 B will be used.

antiX-Dave wrote: ↑Mon Aug 24, 2020 1:31 pm Are there plans for phpmyadmin to be back in the debian official repositories?
Approximately 2 months ago I put together a debian server and the phpmyadmin package was a metapackage that installed adminer (this is no longer the case).
Seeing this made me wonder if it was a conscious change over decision (Similar to mysql and mariadb was my thought). I did not look any further into this as I have not been using phpmyadmin myself.

Edit: sorry if this has already been answered, I did not realize this was a multipage thread