Re: Mysql

houghi wrote:

David Bolt wrote:
[0] IIRC, when you start up the mysql daemon for the first time, it asks
you to set a password for user root at localhost and also for
root@xxxxxxxxxxxxxx using /usr/bin/mysqladmin. If you haven't done very
much you might be lucky and find that command, including the password
you set, in your bash history.

The confusion comes from the fact that the user `root` on a system is
a user that has access to everything, while this is not true for a user
`root` in MySQL.

There the user can be anybody, including `root` or `mysql_root` or
`anything_you_desire` and there has to be no relation perse between the
users on the system and the users in MySQL.
Even worse is that MySQL can work perfectly without the yser 'root' in
MySQL and on some places I read that having 'root' in MySQL could be a
security problem.

Setting MySQL up is not the most logical thing to do. Hence bug #347149
Took me a long time to grasp that as well.

houghi

Thanks for this information. This helps clarify some problems I had in the
past about root in SuSE & root for MySQL. I've read and re-read the
documentation and have had some 'huh ?' moments as the documents are a bit
terse and complicated. I think it would be nice if Yast had a module for
setting up MySQL including a help assistant too.

Anyway, thanks for pointing this (ROOT v root) out. Now I (we) know.
.

Relevant Pages

  • [Full-Disclosure] Proofpoint Protection Server remote MySQL root user vulnerability
    ... The MySQL server may be remotely access by the "root" user without using ... The Proofpoint Protection Server is a software product to filter spam ... the embedded MySQL 4.0 server binds to the default port ... Remote root will not be able to FLUSH ...
    (Full-Disclosure)
  • Re: myqsl dummy needs help
    ... Mike Wright wrote: ... MySQL does this. ... user that user is totally separate from the OS root account. ... I don't install MySql very often but I seem to recall an alert given ...
    (Fedora)
  • Re: INSTALAÇÃO DEBIAN LAMP!
    ... You should only use english in this list. ... >acessar o MySql e diz que eu não tenho permissão para acesso (isso pq eu ... >estou como ROOT). ... Sin importar el usuario, si quieres entrar a mysql como root, ...
    (Debian-User)
  • Re: Need Help setting up Mysql on Openserver 6.0
    ... >> Essentially the same as included with the SCO Doc server. ... > the Root Password... ... Stopping mysql ... ... SET PASSWORD FOR 'root'@'localhost' = PASSWORD; ...
    (comp.unix.sco.misc)
  • mysql connect problems
    ... starting out with MySQL or MySQL-dependent packages run into this. ... Neither of the two above-mentioned applications can connect to my ... # mysql -u root -p ... mysql database, and run 'select user, password, host from user;' I see ...
    (freebsd-questions)