Re: Mysql



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
--
They say pesticides have been linked to low sperm counts.
In my opinion if you have bugs down there that are so bad
you need to use a pesticide, you're not gonna get laid anyway.
.



Relevant Pages

  • Re: Error 1044 Access denied to database
    ... Or perhaps it is just a bug with php or MySql? ... When you installed MySQL you had a root account at the very beginning. ...
    (alt.php)
  • Re: Error 1044 Access denied to database
    ... Or perhaps it is just a bug with php or MySql? ... When you installed MySQL you had a root account at the very beginning. ...
    (comp.lang.php)
  • [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)