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
