Access denied (newbie) query.

Hi,

I am getting a "1044 Access Denied" error...

http://www.aspects.org.au/sqdb4.jpg

I don't however know why I am getting this error and how I can=20
fix it. I have setup full privileges as per..

http://www.aspects.org.au/sqdb5.jpg

The server has phpMyAdmin 2.6.0 installed.

Can anyone here help please ? Perhaps suggesting how/
what steps I should take ?

Regards, John.


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org

Re: Access denied (newbie) query.

> Thanks, but I don't know the difference between "global privileges"
> and "database ones". Or how/where they are set. :-(

I don't know exactly how PhpMyAdmin sets this privileges, but I'll try
to explain. Global privileges are set in a way the user will have that
privileges over all databases and tables, database privileges apply
only when the user is working with that database, your query was a
"create database", and your setting were for user jf at localhost over
that database, it seems ilogical to have rights over a database that
is not created... Dunno.

> Yes, it certainly looks good, but it also appears not to be for a win
> '98 system. Which I have. Looks like I might need to consider setting
> up an XP system. :-(

You don't need a XP System, everything you need is at the mysql bin
directory ;) and the MySQL manual, using mysql console (/bin/mysql)
you can create, set privileges and mess around with users and hosts.
(take a look at the "GRANT" command syntax)

> Sorry, not sure what you mean. My "host" is a local hosting company.
> Not sure of what your comment means.

Hosts are the computers (IP address or names) from where you can
connect and work with your databases, when you see and "@" like
mike@localhost, localhost is the place where you are executing the
commands.

> Thank you for your help. It is very much appreciated.
>
> Regards, John.
--
Daniel da Veiga
Computer Operator - RS - Brazil

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: Access denied (newbie) query.

On Fri, 19 Nov 2004 12:43:41 -0300, Daniel da Veiga wrote:
=20
Re-post. I don't think the other got here.

>> Thanks, but I don't know the difference between "global privileges"
>> and "database ones". Or how/where they are set. :-(

>I don't know exactly how PhpMyAdmin sets this privileges, but I'll try
>to explain. Global privileges are set in a way the user will have that
>privileges over all databases and tables, database privileges apply
>only when the user is working with that database, your query was a
>"create database", and your setting were for user jf at localhost over
>that database, it seems ilogical to have rights over a database that
>is not created... Dunno.

Ah ! That is very clear. Now I have to find out how to set global
privileges rather than database ones on my server. Thanks for pointing
this out and the explanation.=20

In the case we are discussing however I don't know whether my lack of
access is due to my

Global level privileges

Database level privileges

Table level privileges

Column level privileges

Any combination of the above.

Other.

#1044 means nothing to me. :-(

>> Yes, it certainly looks good, but it also appears not to be for a win
>> '98 system. Which I have. Looks like I might need to consider setting
>> up an XP system. :-(

>You don't need a XP System, everything you need is at the mysql bin
>directory ;) and the MySQL manual, using mysql console (/bin/mysql)
>you can create, set privileges and mess around with users and hosts.
>(take a look at the "GRANT" command syntax)

Thanks. Knowing what to look for is a huge help. Though in this case I
get 130 "hits" when searching the MySQL manual. Added to that even if
I knew the syntax to change the global privileges I have no idea
where/how to do that on my hosting server.=20

If you mean that I need to telnet to the above directory then I must
admit that that doesn't sound too appealing to me. Trying out numerous
(correct/incorrect) commands is a sure fire way to make a mess of
things IMO.

If it were able to be done on my machine as a DOS command I wouldn't
mind but on another machine as a UNIX command ? I was hoping for a
"windows" way of doing things. My thinking was that this "list" was
for windows users. Command line computing is fine but not everyone
wants to search through/use hundreds of "commands".
=20
>> Sorry, not sure what you mean. My "host" is a local hosting company.
>> Not sure of what your comment means.

>Hosts are the computers (IP address or names) from where you can
>connect and work with your databases, when you see and "@" like
>mike@localhost, localhost is the place where you are executing the
>commands.

Duh ! Sorry. It was late at night when I made that last post. The
"host" that gave me the errors was my local hosting company.

Thanks again for the extra help.

Regards, John.


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org

Re: Access denied (newbie) query.

Ok, look at section 4.3.1 GRANT and REVOKE Syntax. (manual.html#GRANT)

You will see there that you can grant privileges to all db's and tables by =
designating *.*. Ex:

GRANT ALL ON *.* TO me IDENTIFIED BY mypassword;

This will allow 'me' to create and gain complete access all databases.

Global privileges are those designated by the '*'. They are not assigned fo=
r a particular table or database.

Again, using phpMyAdmin:

Go to the phpMyAdmin home page (index.php).
Click on the 'Privileges' tab.

This will list all your users along with their global privileges. You can e=
dit the privileges for the user by clicking on the appropriate 'Edit' link.=
The next page will give you options to set privileges for single databases=
or tables. Check the privileges you wish to give the user and uncheck priv=
ileges you do not wish the user to have. Click on "Go" and you're done.

phpMyAdmin will work on any platform with php and MySQL installed--Windows,=
Unix, Linux, Mac, whatever. It's the long way around for experienced db ad=
mins, but it's pretty easy to follow for newbies.

Good Luck :)

Randy Clamons
Systems Programming
Astro-auction.com


> ------------Original Message------------
> From: John Fitzsimons
> To: win32@lists.mysql.com
> Date: Fri, Nov-19-2004 4:26 PM
> Subject: Re: Access denied (newbie) query.
>
> On Fri, 19 Nov 2004 12:43:41 -0300, Daniel da Veiga wrote:
> =

> Re-post. I don't think the other got here.
> =

> >> Thanks, but I don't know the difference between "global privileges"
> >> and "database ones". Or how/where they are set. :-(
> =

> >I don't know exactly how PhpMyAdmin sets this privileges, but I'll try
> >to explain. Global privileges are set in a way the user will have that
> >privileges over all databases and tables, database privileges apply
> >only when the user is working with that database, your query was a
> >"create database", and your setting were for user jf at localhost over
> >that database, it seems ilogical to have rights over a database that
> >is not created... Dunno.
> =

> Ah ! That is very clear. Now I have to find out how to set global
> privileges rather than database ones on my server. Thanks for pointing
> this out and the explanation. =

> =

> In the case we are discussing however I don't know whether my lack of
> access is due to my
> =

> Global level privileges
> =

> Database level privileges
> =

> Table level privileges
> =

> Column level privileges
> =

> Any combination of the above.
> =

> Other.
> =

> #1044 means nothing to me. :-(
> =

> >> Yes, it certainly looks good, but it also appears not to be for a =

> win
> >> '98 system. Which I have. Looks like I might need to consider =

> setting
> >> up an XP system. :-(
> =

> >You don't need a XP System, everything you need is at the mysql bin
> >directory ;) and the MySQL manual, using mysql console (/bin/mysql)
> >you can create, set privileges and mess around with users and hosts.
> >(take a look at the "GRANT" command syntax)
> =

> Thanks. Knowing what to look for is a huge help. Though in this case I
> get 130 "hits" when searching the MySQL manual. Added to that even if
> I knew the syntax to change the global privileges I have no idea
> where/how to do that on my hosting server. =

> =

> If you mean that I need to telnet to the above directory then I must
> admit that that doesn't sound too appealing to me. Trying out numerous
> (correct/incorrect) commands is a sure fire way to make a mess of
> things IMO.
> =

> If it were able to be done on my machine as a DOS command I wouldn't
> mind but on another machine as a UNIX command ? I was hoping for a
> "windows" way of doing things. My thinking was that this "list" was
> for windows users. Command line computing is fine but not everyone
> wants to search through/use hundreds of "commands".
> =

> >> Sorry, not sure what you mean. My "host" is a local hosting company.
> >> Not sure of what your comment means.
> =

> >Hosts are the computers (IP address or names) from where you can
> >connect and work with your databases, when you see and "@" like
> >mike@localhost, localhost is the place where you are executing the
> >commands.
> =

> Duh ! Sorry. It was late at night when I made that last post. The
> "host" that gave me the errors was my local hosting company.
> =

> Thanks again for the extra help.
> =

> Regards, John.
> =

> =

> -- =

> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe: =

> http://lists.mysql.com/win32?unsub=3Drandy@novaspace.com
> =

> =



--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org

Re: Access denied (newbie) query.

On Fri, 19 Nov 2004 18:14:26 -0700, Randy Clamons wrote:

Hi Randy,
=20
>Ok, look at section 4.3.1 GRANT and REVOKE Syntax. (manual.html#GRANT)

Okay, I went to 4.3.1 at ;

http://dev.mysql.com/doc/mysql/en/Command-line_options.html

and it is talking about command line options. I don't know how to get
to/use command line access on my hosting ISPs Unix server.

The phpMyAdmin documentation at ;

http://www.phpmyadmin.net/documentation/

was no better.

>You will see there that you can grant privileges to all db's and tables =
by designating *.*. Ex:

>GRANT ALL ON *.* TO me IDENTIFIED BY mypassword;

>This will allow 'me' to create and gain complete access all databases.

>Global privileges are those designated by the '*'. They are not assigned=
for a particular table or database.

>Again, using phpMyAdmin:

>Go to the phpMyAdmin home page (index.php).

>Click on the 'Privileges' tab.

Thanks, I would.....IF there were a 'Privileges' tab. As you can see
from ;

http://www.aspects.org.au/sat1.jpg

there is nothing there about "privileges". :-(

>This will list all your users along with their global privileges.=20

< snip >

Sounds good. If anyone can tell me how to find that page then I will
be pleased to try your suggestion.

Thanks for the feedback. I sure hope someone here can guide me=20
to the page you talk about.

Regards, John.


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org