Hello all,
well I have installed MYSQL and when I lunch it, it waits me to enter a password, but when I install it, I didnt enter a password, so that prompt shouldn't be included , so what should I do?
thanks

It's a normal behavior of mysql (as far as I know)

Type in the shell:

$mysql -u root -p
Enter password: [just hit enter]
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 8 to server version: 4.0.20-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> SET PASSWORD FOR root@localhost=password('newPassword');

(-u to specify the user and -p to specify you want to input a pwd)
Already in the mysql prompt you can set your password with the command mentioned above.

If you don't want to specify user and password each time you execute mysql, you can save your preferences at ~/.my.conf, i.e.:
$mysql -u myUser -p myPwd
will be the same that writing in your my.conf the following


Cheers!!

but when i install it , I didn't supply any password

assuming you installed it as root..
are you logging in as root? or as another user.. if you are logging in as another user you have to add the user info to the user db in mysql using the root account first..

also did you run the
after installing?

yes, but as far as you have to access mysql using user and password, the default installation provides you with a blank default password which I [languaje false friend]hardly[/language false friend] STRONGLY encourage you to change.
It is a normal behavior

Edited: sorry people, I only read english not speak it. For now on, I'll be sticked to an on-line dictionary to check the sense of my posts. I cannot believe that only a word changed all the meaning of my sentence. Sorry

leaving the password blank is a normal behavior?

then why does the Mysql documentation suggest setting the root password immediately after install.

Because the Mysql documentation also knows that it's a Bad Thing to leave the server running with a blank root password.

I suppose you didn't really mean to say "hardly" here.
("hardly" in english means "apenas" in spanish)

yes i understood that.. i was just stressing it for effect.

the earlier post makes more sense if guedellas didnot mean to say hardly.. as that did not make any sense..

Or guedillas was just a bit sarcastic for effect.

yes.. hmm..

time to ban sarcasm..

No sarcasm at all, people, just some ineptitude with english and bad luck with a false friend. (Thanks Hko for this language tip ). Error edited and corrected.

Be positive, boy, I'm learning some GNU/linux and also improving my english...

My apologies again.

PS: @alsharifhoussam change your password ASAP

thanks for ur help
guedellas I have changed my password and things gone well now..
but this post doesnt deserve all that fight about langauge right?!

I think there are no apologies really needed.. just a simple misunderstanding.. and also I was referring to banning sarcasm for myself.. once again, I failed in using it.. lol

good luck with english.

-x