Re: Setting User Privileges ? Confused !!
I mean user table - mysql.user
anonimous user - mysql.user.User = "%" and mysql.user.Host = "localhost"
On Wed 29 Aug 2001 22:58, Dennis Herndon wrote:
> I have the same problem and have looked all over for the solution. You
> have to delete the anonymous user from which table? I would assume the
> users table?
>
> -Original Message-
> From: Roman Festchook [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, August 29, 2001 10:05
> To: Peter Moscatt; MySQL List
> Subject: Re: Setting User Privilges ? Confused !!
>
>
> By default you have record for anonimous user with any name and no pass in
> your access tables, thats lock access any other user from localhost with
> password to database. Just delete this anonimous user from mysql access
> tables
>
> On Wed 29 Aug 2001 13:08, Peter Moscatt wrote:
> > I am pretty new to MySQL, in fact that also covers Linux as well.
> >
> > I have Mandrake 8.0 which I have installed MySQL using the RPM format.
> > I plan to write code (python) to access the database to manage what
> > data it may hold.
> >
> > The server automatically starts on boot - which is fine.
> >
> > To be able to do anything with MySQL I have to be logged on as 'root'
> >
> > If I try to access the database I have created under my normal logon
> > ('pmoscatt') I get the following error message:
> >
> > ERROR 1044: Access denied for user '@localhost' to database 'MCMaint'
> >
> > I have read the manual to see how I can get around this but find it
> > confusing.
> >
> > Can anyone help me to allow me to access databases under my normal user
> > account.
> >
> > Pete
> >
> >
> >
> > -
> > 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
--
Roman Festchook
Network Engineer
ISP ORTA Polesye
http://www.polesye.net
-
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
RE: Setting User Privileges ? Confused !!
I have the same problem and have looked all over for the solution. You have
to delete the anonymous user from which table? I would assume the users
table?
-Original Message-
From: Roman Festchook [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 29, 2001 10:05
To: Peter Moscatt; MySQL List
Subject: Re: Setting User Privilges ? Confused !!
By default you have record for anonimous user with any name and no pass in
your access tables, thats lock access any other user from localhost with
password to database. Just delete this anonimous user from mysql access
tables
On Wed 29 Aug 2001 13:08, Peter Moscatt wrote:
> I am pretty new to MySQL, in fact that also covers Linux as well.
>
> I have Mandrake 8.0 which I have installed MySQL using the RPM format.
> I plan to write code (python) to access the database to manage what
> data it may hold.
>
> The server automatically starts on boot - which is fine.
>
> To be able to do anything with MySQL I have to be logged on as 'root'
>
> If I try to access the database I have created under my normal logon
> ('pmoscatt') I get the following error message:
>
> ERROR 1044: Access denied for user '@localhost' to database 'MCMaint'
>
> I have read the manual to see how I can get around this but find it
> confusing.
>
> Can anyone help me to allow me to access databases under my normal user
> account.
>
> Pete
>
>
>
> -
> 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
--
Roman Festchook
Network Engineer
ISP ORTA Polesye
http://www.polesye.net
-
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
