localhost

[ckosloff]

I am trying to install ZC in a local LAMP server.
I am using the Debian distro latest version (11, name bullseye), Debian attempts to make things easy with metapackages I installed one called task-web-server.
If I type localhost in my browser I get the Debian document, so it works.
I have reading the Zen Cart Manual by Richard Underwood which relies heavily on Windows and Cpanel, so not very useful.
Problem is: I need to create database and user first to install ZC, I am trying to do so with php my admin, but it fails because it asks for password for administrative user, which I have not created yet, so how to proceed?
PS: I am an old user, but have been away for a long time, I am old and sick so I got a brain fart, please be kind.

[carlwhat]

I am trying to install ZC in a local LAMP server.
I am using the Debian distro latest version (11, name bullseye), Debian attempts to make things easy with metapackages I installed one called task-web-server.
If I type localhost in my browser I get the Debian document, so it works.
I have reading the Zen Cart Manual by Richard Underwood which relies heavily on Windows and Cpanel, so not very useful.
Problem is: I need to create database and user first to install ZC, I am trying to do so with php my admin, but it fails because it asks for password for administrative user, which I have not created yet, so how to proceed?
PS: I am an old user, but have been away for a long time, I am old and sick so I got a brain fart, please be kind.

if you have installed phpmyadmin on a bullseye LAMP server already, bravo!

the foregoing statement means you have already successfully installed mysql. so now it is a question of resetting your root password (else do a google search for default mysql root password, actually the default is none!)

if the default password does not work, you will need to stop the mysql service, and do a bunch of stuff. all of which looks to be contained in this link.

once you can login with root, you can then add users, create databases, and the like.

i would think for this base sort of stuff operating on the command line might be better, but my opinion is biased.

i hope that was kind enough for you... it's about as kind as i get!

[ckosloff]

No, phpmyadmin did not install correctly because apparently I need to create a DB and user first, set passwords, etc. Got tons of errors. Cannot install in my localhost, please help.

[brittainmark]

.this link might help on setting up a lamp stack on Debian 11.

[ckosloff]

Problem here is that there is no mysql-server in Debian repo, apparently it has been replaced by MariaDB, should I install that?

[ckosloff]

The links and commands don't work on Debian 11, mysql commands take me to MariaDB, so I suppose that was installed by metapackage task-web-server

[ckosloff]

SOLVED!!
Followed instructions here:
https://www.ibm.com/docs/en/spectrum...d-mysqlmariadb
This was posted in wrong thread, my apologies.

[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.