setting initial password for phpmyadmin [SOLVED]

Kernels & Hardware, configuring network, installing services

setting initial password for phpmyadmin [SOLVED]

Postby ckosloff » 2018-04-26 21:42

I installed apache 2, mysql server and php my admin without problems.
Problem is that when starting php my admin, it requests user and password and I don't know where to set those.
Last edited by ckosloff on 2018-04-27 14:22, edited 1 time in total.
User avatar
ckosloff
 
Posts: 321
Joined: 2011-12-29 15:08
Location: South Florida, USA

Re: setting initial password for phpmyadmin

Postby jibberjabber » 2018-04-26 22:50

Maybe give a little better details, How exactly did you install phpmyadmin ?
What OS is it ? or Debian version, if it is Debian ,...

Usually the default user is "root" and the default password is "admin"

This might help : https://askubuntu.com/questions/118772/how-to-change-root-password-for-mysql-and-phpmyadmin
If not, there is plenty of tutorials and instruction on installing and setting up phpmyadmin, if you feel you must use it. I don't use it myself, there is no real need for it, php software and programs work just fine with out it.
But any way, you can try again using:
Code: Select all
dpkg-reconfigure -plow phpmyadmin

But be sure to make sure MariaDB Service is running. If stopped, start it.
If you are using Debian 9, stretch,...
This will let you reconfigure it,..(maybe). I strongly suggest reading this
first: (and care fully), https://manjaro.site/how-to-install-phpmyadmin-on-debian-9-stretch/
If you are not using Debian stable or older, who knows ? It is anybodies guess,
the configuration varies, depending on the OS, if it is Debian Testing, there could be other problems as well, it would be nice if people learned to include essential details to start with, but that will never happen.
N5RLX > "Jibber jabber jibber jabber,all day and all night, jibber jabber jibber jabber"

Then there is Papa Parrot
jibberjabber
 
Posts: 82
Joined: 2016-01-10 16:58

Re: setting initial password for phpmyadmin

Postby ckosloff » 2018-04-26 23:04

Ok. I will make you happy, I am using Debian testing, recent full dist-upgrade, no problems there.
Installed all three with Synaptic, no errors on install.
Localhost pulls correctly the Apache start page.
Will try your suggestions and be back to this forum.
Thank you.
User avatar
ckosloff
 
Posts: 321
Joined: 2011-12-29 15:08
Location: South Florida, USA

Re: setting initial password for phpmyadmin

Postby jibberjabber » 2018-04-27 02:29

Ok well, on Debian 7, for me , username: root Password: admin worked, and after logged in, there is a easy "click here here", to change the password.
But that was back when Debian was better, I have no idea about what you will need to to with Debian testing, maybe some one else will. Sorry,
Image

Later on another server, different OS, I was unable to install phpmyadmin, it is not supported, that is when I learned it is not even needed, you can access the mysql or maria data base, via the command line, and do everything you need to with out it, much more efficiently.
N5RLX > "Jibber jabber jibber jabber,all day and all night, jibber jabber jibber jabber"

Then there is Papa Parrot
jibberjabber
 
Posts: 82
Joined: 2016-01-10 16:58

Re: setting initial password for phpmyadmin

Postby ckosloff » 2018-04-27 14:22

I reconfigured with dpkg fom command line, instructions are in file config.inc.php.
That is the only thing that worked, setting password from command line does not work, throws errors.
There is no way to enter password form command line in config.inc.php, explan is in the file itself, unsafe procedure.
User avatar
ckosloff
 
Posts: 321
Joined: 2011-12-29 15:08
Location: South Florida, USA

Re: setting initial password for phpmyadmin [SOLVED]

Postby jibberjabber » 2018-04-27 16:58

Well that is good you got it working.

==== edited =======
Some others may find this helpful:
https://www.server-world.info/en/note?os=Debian_9&p=mariadb&f=2

And this : https://www.vultr.com/docs/reset-mysql-root-password-on-debian-ubuntu
N5RLX > "Jibber jabber jibber jabber,all day and all night, jibber jabber jibber jabber"

Then there is Papa Parrot
jibberjabber
 
Posts: 82
Joined: 2016-01-10 16:58


Return to System configuration

Who is online

Users browsing this forum: No registered users and 6 guests

fashionable