Hi,
Only the root with the '%' character on the host field from table mysql.user
have full priveleges.Try to connect with "-h" option and specify the
Host_Name of your server.Should be work.
Eg: mysql -u root -h Your_Server_Name
Regards,
Gelu
_____________________________________________________
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
----- Original Message -----
From: Ian Phillips <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, April 22, 2002 11:58 AM
Subject: New Setup
> I thank anyone in advance who may be able to help me iron this out.
>
> 1. I am setting up mysql on my apache server. I have had it there for a
> while, but haven't really done much with getting my head round it.
>
> 2. I have figured out some shell commands, and have been able to set a
root
> password.
>
> 3. I have also been able to use phpMyAdmin - which I had to modify to take
> into account the root password etc that is now in place.
>
> 4. I can create a database & table using the phpMyAdmin forms - and it was
> relatively easy. However, when I go back to try and set up a new user who
> has permission to do a range of things on this database, (using shell
now),
> I am given an error....
>
> ERROR 1044: Access denied for user: 'root@localhost' to database 'cbaa'
>
> Shell command I am using....
>
> mysql> GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP
> -> ON cbaa.*
> -> TO cbaa@localhost
> -> IDENTIFIED BY 'itsmeolord';
>
> This seems strange to me, as I figured that root would have permission to
do
> anything (even if it were 'inappropriate'.
>
> Any guidance would be appreciated.
>
> Ian
>
>
> ---------------------------------------------------------------------
> 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
>
>
---------------------------------------------------------------------
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
