Re: Debian installation methodolgy and mysql root password ahndling?
stan <stanb@awod.com> writes:
> Basicly I'm trying to get gnutrition set up. It uses mysql as a backbend.
> I'm on a "testing" machine, so I was able to install gnutrion successfully
> using select, and it pulled in the appropriate mysql packages. Along the
> way I saw a message about setting a root password for mysql.
...
> At the moment a ps shows the mysql daemon running, and I can connect to the
> mysql backbend using "mysql -uroot mysql", which I think bypasses the
> password mechanism, right? I'm able to do this both as root an a normal
> user.
>
> However, when I fire up gnutrition, I get an initial setup dialog that
> prompts me for a user name and password pair for mysql. What should I use
> there? If I try root/mysql, I get a "connect filed". so that must not be
> correct.
I've never played with mysql on Debian, though I've used it
elsewhere. With the mysql command line,
if you used 'mysql -usomebody -ppassword', it uses the given password;
if you used 'mysql -usomebody -p', it prompts for a password;
otherwise, it uses no password.
The 'mysql' on your sample command line is the name of the database to
connect to. Unless there is something set up so that root connections
from the localhost don't need passwords, this probably means that your
mysql root account has no password at all. (I'd probably consider
either configuration poor, though "no password, personal machine, only
allows connections from localhost" is probably acceptable.)
--
David Maze dmaze@debian.org http://people.debian.org/~dmaze/
"Theoretical politics is interesting. Politicking should be illegal."
-- Abra Mitchell
Reply to: