PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !

Hi,

I find the following line in my syslog events:

Daemon Error mysqld
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !

followed by a whole lot of notes, advice and web links. I do have set a
custom password for root, root is not accessible from remote, the
anonymous user does not exist and a database named test also does not
exist. Yet still I see this message when starting the MySQL server.

How can I get rid of it?

MySQL 5.1 on Ubuntu 10.04

--
Yves Goergen "LonelyPixel"
Visit my web laboratory at http://beta.unclassified.de

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !

On 13.12.2010 15:26 CE(S)T, who.cat wrote:
> try /mysql_bin_path/mysql_secure_installation !
> Hope it helpfu!

I already followed that path and it doesn't quite help. I've done the
checks that the install script does and my installation is secure by
those means. But I don't want to install things. The server is already
up and running in production. I only want to get rid of that whole load
of messages posted to syslog. I don't know where they come from to do
further analysis.

--
Yves Goergen "LonelyPixel"
Visit my web laboratory at http://beta.unclassified.de

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !

On 14.12.2010 20:36 CE(S)T, Alejandro Bednarik wrote:
> Are you using ubuntu deb's or mysql bin? Do you get that message when
> the service start? Look init script to see what it does.

I get the message when MySQL is started. I've installed the Ubuntu
standard package mysql-server-5.1. It has already asked for a root
password during package configuration and I did enter some password there.

I just tried to grep my whole filesystem for parts of this message but
either grep failed "allocating memory" (there's plenty left!) or it
didn't find the text in a file I could start something with. So I still
don't know where the message comes from!

--
Yves Goergen "LonelyPixel"
Visit my web laboratory at http://beta.unclassified.de

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !

--001636c5b95610aeaf0497e91628
Content-Type: text/plain; charset=UTF-8

Maybe you should give a password to MySQL's root. And I think this note will
disappear.
David Yeung, In China, Beijing.
My First Blog:http://yueliangdao0608.cublog.cn
My Second Blog:http://yueliangdao0608.blog.51cto.com
My Msn: yueliangdao0608@gmail.com



2010/12/17 Yves Goergen

> On 14.12.2010 20:36 CE(S)T, Alejandro Bednarik wrote:
> > Are you using ubuntu deb's or mysql bin? Do you get that message when
> > the service start? Look init script to see what it does.
>
> I get the message when MySQL is started. I've installed the Ubuntu
> standard package mysql-server-5.1. It has already asked for a root
> password during package configuration and I did enter some password there.
>
> I just tried to grep my whole filesystem for parts of this message but
> either grep failed "allocating memory" (there's plenty left!) or it
> didn't find the text in a file I could start something with. So I still
> don't know where the message comes from!
>
> --
> Yves Goergen "LonelyPixel"
> Visit my web laboratory at http://beta.unclassified.de
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=yueliangdao0608@gmail.com
>
>

--001636c5b95610aeaf0497e91628--

Re: PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !

On 21.12.2010 11:27 CE(S)T, 杨涛涛 wrote:
> Maybe you should give a password to MySQL's root. And I think this note will
> disappear.

I would be extremely dumb not to set any password on MySQL's root
account at all! Of course (I hope I made that clear before) a password
has been set while installing the MySQL package. The point is that this
message is plain wrong and should be removed altogether until it works
as it claims.

--
Yves Goergen "LonelyPixel"
Visit my web laboratory at http://beta.unclassified.de

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org