Hi,
OK.If you connect from localhost and use the option "-h" you must "put" the
alias name from /etc/hosts(if OS is Unix).Try next;
use mysql;
select Host from user where User='root';
and response is (on my server):
% - this is if i wish to connect from any host
myx - this is if i wish to connect from myx(is the alias from
/etc/hosts) host
So now i can try :
mysql -u root -h myx
I don't use "-p" because i don't have set the password.
Good luck,
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 3:17 PM
Subject: Re: New Setup
> Thanks for the idea -- still stuck though
>
> Tried connecting to mysql using the -h option, but I still had the same
> response. (with the -p option as well thanks Borus). Let me check -
> "Your_Server_Name" I think in my case is localhost
>
> I had a look (using the phpMyAdmin tool) at the records in the user table.
> There are four records - two of which are localhost - one which is root,
> with password (all privileges), and the second no user & no password - no
> privileges. The other two records are similar, but my server's domain name
> appears in these two records.
>
> I could not see any % mark in the user table - however I did find the %
mark
> in the mysql.host table - two records - one for localhost and the other my
> domain name, and the % mark was in the db column.
>
> Ian
>
> ----- Original Message -----
> From: "Gelu" <[EMAIL PROTECTED]>
> To: "Ian Phillips" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Monday, April 22, 2002 9:05 PM
> Subject: Re: New Setup
>
>
> > 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
> >
> >
>
>
> ---------------------------------------------------------------------
> 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
