On Mon, 3 Mar 2008, Daniel Brown wrote:
On Mon, Mar 3, 2008 at 2:46 PM, Hiep Nguyen [EMAIL PROTECTED] wrote:
mysql select user,host,password from mysql.user;
+--+--+--+
| user | host | password |
You should definitely consider getting rid of them, otherwise people can log
in to MySQL from any host with no credentials.
They are created during installation by the mysql_install_db script.
This tells you how to remove them:
http://dev.mysql.com/doc/refman/5.0/en/default-privileges.html
-Dan
On Tue, 4 Mar 2008, Dan Rogart wrote:
You should definitely consider getting rid of them, otherwise people can log
in to MySQL from any host with no credentials.
They are created during installation by the mysql_install_db script.
This tells you how to remove them:
That error occurs when the user has already been dropped - so it's good news
:).
You can check for users with blank user names and/or blank passwords by
querying the mysql.user table:
select user,host,password from mysql.user where user = '' or password = '';
Those are the users you should
got it. thanks.
t. hiep
On Tue, 4 Mar 2008, Dan Rogart wrote:
That error occurs when the user has already been dropped - so it's good news
:).
You can check for users with blank user names and/or blank passwords by
querying the mysql.user table:
select user,host,password from mysql.user
hi all, i just installed mysql and started mysqld.
it suggested i change pw for root, so i did:
mysqladmin -u root password my_pw;
but i can't do:
mysqladmin -u root -h dev.jss.com password my_pw;
how do i change pw for [EMAIL PROTECTED]
thanks,
t. hiep
--
MySQL General Mailing List
For list
On Mon, Mar 3, 2008 at 2:01 PM, Hiep Nguyen [EMAIL PROTECTED] wrote:
hi all, i just installed mysql and started mysqld.
it suggested i change pw for root, so i did:
mysqladmin -u root password my_pw;
but i can't do:
mysqladmin -u root -h dev.jss.com password my_pw;
how do i change pw
On Mon, 3 Mar 2008, Daniel Brown wrote:
On Mon, Mar 3, 2008 at 2:01 PM, Hiep Nguyen [EMAIL PROTECTED] wrote:
hi all, i just installed mysql and started mysqld.
it suggested i change pw for root, so i did:
mysqladmin -u root password my_pw;
but i can't do:
mysqladmin -u root -h
On Mon, Mar 3, 2008 at 2:46 PM, Hiep Nguyen [EMAIL PROTECTED] wrote:
mysql select user,host,password from mysql.user;
+--+--+--+
| user | host | password |
+--+--+--+
| root |