mysql password?

[georgergb]

Hi

Another newcomer to the world of Unix etc here. I've successfully installed PHP and MySQL, including the automatic startup.

The only thing I am unsure about is whether I was able to set a password for MySQL. I thought I had but am not getting a prompt for it when I start using the terminal to create a database.

Is this correct? I would just like to make sure it is secure before I do any major work.

Thanks

George

[bakaDeshi]

did you run this command?
mysqladmin -u root password new_password_here
That sets the password for root for mysql.

[georgergb]

Hi

Yes, I thought I had but it didn't seem to have worked, hence my confusion. Anyway, I tried resetting the password again and then encountered another unrelated problem. On fixing that the password issue was also resolved and it is now working fine.

Thanks

George