Re: phpmyadmin ... need help!

[Joe]

On Wed, 24 May 2017 06:17:35 -0400
Fungi4All <fungil...@protonmail.com> wrote:

>  Original Message 
> Subject: Re: phpmyadmin ... need help!
> UTC Time: May 23, 2017 8:18 PM
> From: j...@jretrading.com
> 
> Yes, you've done it backwards, but it's no big deal in Debian.
> phpmyadmin needs the root password of mysql in order to install
> 
> In all other systems it is a catastrophic mistake, but in Debian it
> is no biggy, you just throw everything away and start from
> scratch. :) :) :) :) LoLLL
> 

The point being that throwing phpmyadmin away and reinstalling is
trivial, whatever the OS. As I said, it's just a few web server scripts.
Debian just makes it even more trivial, and makes setting up mysql just
as easy. We recently went through this with mariadb, and I discovered
that setting that up isn't so easy, since there is no postinstall script
supplied by Debian like the mysql one.

Had things been the other way around, and the OP had installed mysql
and twenty applications which use it, and they had all set up their
users and databases, and that lot had to be reinstalled... yes, that
would have been a big deal, in Debian or anything else.

-- 
Joe

Re: phpmyadmin ... need help!

[Fungi4All]

 Original Message 
Subject: Re: phpmyadmin ... need help!
UTC Time: May 23, 2017 8:18 PM
From: j...@jretrading.com

Yes, you've done it backwards, but it's no big deal in Debian.
phpmyadmin needs the root password of mysql in order to install

In all other systems it is a catastrophic mistake, but in Debian it is no 
biggy, you just throw everything away and start from scratch. :) :) :) :) LoLLL

Sorry, I spent some time in my youth in sales, I know what it's like. Otherwise 
the advise was compact and sensible. One question I have is why isn't dpkg 
requiring such order of pre-requisite and dependency but can allow phpadmin to 
be installed without mysql being there. [please don't let that answer be "you 
should have read the manual first"]

As things are evolving with servers and keyringers one needs a separate 
encrypted debian system to be running somewhere with all the keys and 
passwords, unless one choses the logical path of using one for everything, in 
which case sometimes it gets really confusing for what this passphrase was for.

Did your dpkg just get updated? Or is it just me?

Re: phpmyadmin ... need help!

[Joe]

On Tue, 23 May 2017 13:43:20 -0500
Dennis Wicks  wrote:

> How do I get the setup procedure to run?
> 
> I use a url of 127.0.0.1/phpmyadmin/setup like I found in
> the docs but it keeps asking for a user and password. I have
> tried many combos that I have found: root, admin, pma,
> phpmyadmin. I tried using localhost in the url but it gets
> changed to www.localhost.com! I tried setting the
> config.sample.inc.php AllowNoPassword to TRUE but that
> didn't help. I have run out of places to look and ideas.
> 
> Does anybody know how to get this thing started?
> 
> If I have to setup mysql first, that is just as great a
> mystery! I was hoping that phpmyadmin would take care of
> that for me too!
> 
> Any help will be greatly appreciated!!
> 


Yes, you've done it backwards, but it's no big deal in Debian.
phpmyadmin needs the root password of mysql in order to install, and if
you haven't installed mysql, it obviously doesn't have one. phpmyadmin
itself needs to set up data in mysql.

So remove phpmyadmin, then install mysql. The mysql installation will
ask you to create a root password. Note that the mysql root user and his
password are completely separate from the Linux root user and password.
Don't lose this password, as mysql takes security seriously and will
not allow you to recreate a root password unless you already have it. If
you forget it, you need to reinstall, and all data that you can't
manage to backup without the root password will be lost. A wise
precaution is to backup all the data regularly, even if the computer
itself is being backed up regularly.

Having installed mysql, it will have created some data tables of its
own for housekeeping. Now install phpmyadmin (it's really just a few
scripts, you're not actually installing anything, just hooking it into
the apache configuration). It will want the mysql root password in
order to make some data of its own.

As far as I recall, that's it. It is possible that there will be php
or even apache issues, as both are much more tightly controlled than
when I last set this up. It may be necessary to enable something here
or there, but I suspect Debian will sort that out.

You'll need at least a vague idea of how mysql works, as it's not
really intuitive if you haven't used something like it before. There
are reams of information and tutorials on the Net, in addition to
the official mysql site. Note particularly that mysql users (again,
completely separate from Linux users) are specified by both user name
and client computer hostname. From a recent post of mine:

"Note also what someone else here was confused about recently, that
mysql knows users by both name and client computer hostname, so
richard@comp1 is a different user to richard@comp2, and different again
to richard@localhost and richard@%. The '%' is the SQL wildcard. As
different users, they can have different privileges and passwords e.g
richard@comp1 can use database fred but not database bill, and
richard@localhost can use bill but not fred. Wordpress will almost
certainly name its user(s) 'xxx@localhost', and that account will not
work from anywhere else. I mention this in detail because it took me a
while to get the hang of it.

List the users/hosts with USE mysql; SELECT * FROM user;

Don't mess with user privileges until you understand them, a large
variety of privileges can exist globally, per database, per table and
per column. A user set up by an application will (hopefully) have
exactly the correct set of privileges."

You are right for the most part, with phpmyadmin you shouldn't need to
use the mysql command line, but it is worth knowing that it is there,
and what you can do from it (i.e. everything) and if you ever have
trouble with your web server, the command line will still be there. You
may also one day want to involve some or all of your mysql databases in
your backup scripts, and again, the command line is what you will need
then.

Re: phpmyadmin ... need help!

[Richard Owlett]

On 05/23/2017 01:43 PM, Dennis Wicks wrote:

How do I get the setup procedure to run?

I use a url of 127.0.0.1/phpmyadmin/setup like I found in
the docs but it keeps asking for a user and password. I have
tried many combos that I have found: root, admin, pma,
phpmyadmin. I tried using localhost in the url but it gets
changed to www.localhost.com! I tried setting the
config.sample.inc.php AllowNoPassword to TRUE but that
didn't help. I have run out of places to look and ideas.

Does anybody know how to get this thing started?

If I have to setup mysql first, that is just as great a
mystery! I was hoping that phpmyadmin would take care of
that for me too!

Any help will be greatly appreciated!!

TIA!
Dennis




Sounds like symptoms I've reported:
• Initial thread
  "Doing a clean install with ATYPICAL constraints"
  
• Major sub-thread
  "A regression bug comparing Stretch to Jessie -was [..."
  

The symptoms I've seen revolve around Debian's move from MySQL to 
Mariadb. If you are using Stretch, I don't know the solution yet.


If Jessie the key is to stick with MySQL without taking any options for 
Mariadb.

phpmyadmin ... need help!

[Dennis Wicks]

How do I get the setup procedure to run?

I use a url of 127.0.0.1/phpmyadmin/setup like I found in
the docs but it keeps asking for a user and password. I have
tried many combos that I have found: root, admin, pma,
phpmyadmin. I tried using localhost in the url but it gets
changed to www.localhost.com! I tried setting the
config.sample.inc.php AllowNoPassword to TRUE but that
didn't help. I have run out of places to look and ideas.

Does anybody know how to get this thing started?

If I have to setup mysql first, that is just as great a
mystery! I was hoping that phpmyadmin would take care of
that for me too!

Any help will be greatly appreciated!!

TIA!
Dennis