-----Original Message-----
From: Matthew Darcy [mailto:[EMAIL PROTECTED]]
Sent: 27 December 2001 14:08
To: Count Schemula
Subject: RE: Re: host not allowed to connect ? more problems
Hi,
I have re-read and think I understand a little better (think being the
correct word)
I have decided to set the root password - and then add some users.
first of all I tried
./mysqladmin -u root password $thenewpassword
this gave me
./mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: NO)'
I decided to then try
./mysqladmin -u root@jordan password $thenewpassword
this came up with
./mysqladmin: unable to change password; error: 'You are using MySQL as an
anony
mous users and anonymous users are not allowed to change passwords'
the problems are 1 why can mysqladmin not set the root password and not
connect to localhost ???
the second is why when I set the machine name to jordan (root@jordan) does
it tell me I am not logged in ?
what do I need to do to sort this.
Thanks,
Matt
Ps I think I have my head around the grant thing now.
-----Original Message-----
From: Count Schemula [mailto:[EMAIL PROTECTED]]
Sent: 27 December 2001 13:01
To: [EMAIL PROTECTED]
Subject: RE: Re: host not allowed to connect ? where is this config ?
--- Matthew Darcy <[EMAIL PROTECTED]> wrote:
> can you explain how to do this as I keep struggling
> with users.
Not sure on the root/password but I'd set one just in
case. Users/grants drove me nuts too, here's some
basic stuff:
CREATE DATABASE whichdb
USE whichdb
GRANT ALL ON whichdb.* TO [EMAIL PROTECTED]
IDENTIFIED BY "somepassword"
note the .* wildcard in the above!
some others:
SHOW DATABASES;
SHOW TABLES;
SHOW TABLES FROM whichdb;
SHOW COLUMNS FROM which_table;
The docs at www.mysql.com have this in there. It's
abstract, and then it works!
__________________________________________________
Do You Yahoo!?
Send your FREE holiday greetings online!
http://greetings.yahoo.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
