RE: mySQL logon PROBLEM!!
Thank-you David I appreciate the response.
I am assuming that I have to do the same for all the users in the system
already in order for mySQL to prompt me for a password when I type in
"mySQL"? and for future users I could just make it so that when a new
user is added it will also add it into mysql automatically right? Thanx!
Francisco
-----Original Message-----
From: David Ramsden [mailto:david@hexstream.eu.org]
Sent: Sunday, May 11, 2003 10:09 PM
To: Francisco Castellon
Subject: Re: mySQL logon PROBLEM!!
On Sun, May 11, 2003 at 09:43:25PM -0600, Francisco Castellon wrote:
> Ok apparently I do have a problem. =(
>
> This is what I am doing.
> Log in to my Debian machine through SSH remotely using a regular user
> account (not root). I type in "mysql -u root" and it logs me into
mysql
> as if I were root. It doesn't ask me for a password AT ALL, and I have
> root privileges, this means that any user with an account in that
system
> can log on to mysql as root by typing the above command. What is it
that
> I should be doing to fix this?
>
This is normal for a default installation of MySQL - The root MySQL user
has no password by default.
YOU'RE ment to set it.
You can set it using this command:
mysqladmin -u root -p password 'newpassword'
Where newpassword, is the password you want to use (yes, it's in
clear-text but will be encrypted by MySQL).
When you press enter, MySQL will ask you for the password - Just press
enter as root currently has no password.
After that (providing there are no error messages), the root MySQL user
password will be set.
HTH.
David.
--
.''`. David Ramsden <david@hexstream.eu.org>
: :' : http://portal.hexstream.eu.org/
`. `'` PGP key ID: 507B379B on wwwkeys.pgp.net
`- Debian - when you have better things to do than to fix a system.
Reply to: