localhost

[carlwhat]

if you have problems with phpMyadmin, i would recommend adminer.

very easy to install. it is just 1 file.

if you choose to go that route, i can provide code where you do not need your credentials to login. it is tied to your zc admin credentials.

i find it much easier for doing local development as installing phpMyadmin can be challenging.

[ckosloff]

if you have problems with phpMyadmin, i would recommend adminer.

very easy to install. it is just 1 file.

if you choose to go that route, i can provide code where you do not need your credentials to login. it is tied to your zc admin credentials.

i find it much easier for doing local development as installing phpMyadmin can be challenging.

I would be glad to use adminer, I solved the problem with phpmyadmin so I think that I could log into adminer with same credentials.
In fact I prefer it since I am planning to buy a droplet from Digital Ocean and install same Debian 11 that I use at home for development, it is much easier to backup databases with it.
I have the latest file, now I have to copy it to html directory, which at the moment is not writable, I am now figuring out how to make it writable without compromising security.
I used adminer in the past, but a long time has passed and I have a brain fart.

[ckosloff]

I hope this thread will work as guidance for Linux users who like the command line. Real men don't use Windows and Cpanel, regretfully most of the installation tutorials are written for these users, including the implementation guide in Zen Cart docs, just pandering to the crowd.

[ckosloff]

I got everything SOLVED, after fixing perms in my localhost with these instructions, I could copy over the adminer file into my /var/www/html and now invoke it with localhost/adminer.php in my browser (Firefox).
Thanks anyway for your kind advice, I can login with user root and password, same as phpmy admin.
Back in the day, I used to backup database with adminer and save it in my computer and backup files with tar command.
BTW, database backed up with adminer are not the same than with phpmyadmin, maybe compatibility problems have been addressed now.
I don't use Filezilla or any other FTP program, my KDE desktop can connect remotely over fish protocol, so I transfer backups into my computer seamlessly. I did write a tutorial in the KDE forums, I have lost that URL but can retrieve it if there is interest.

[ckosloff]

I got correct perms from here.
Moved file to my localhost and now it works perfectly with same credentials as php myadmin.
Thank you.