Error 1045 : Access Denied

Error 1045 : Access Denied

Post by Marc LAVERROU » Fri, 22 Dec 2000 23:23:51



------=_NextPart_000_0119_01C06B62.4F938990
Content-Type: text/plain;
        charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi,

    I have a problem which i can't resolve.  So, I have create as root =
an user :


by 'xxxxxxxxxx' with grant option;
mysql> select * from db where user=3D"marc01";
Here's the result :

Host    localhost
Db    marc
User    marc01
Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | =
Drop_priv | Grant_priv | References_priv | Index_priv | Alter_priv | =3D =
Y

mysql> select * from user where user=3D"marc01";
Here's the result :

Host    localhost
User    marc01
Password    xxxxxxxx
Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | =
Drop_priv | Reload_priv | Shutdown_priv | Process_priv | File_priv | =
Grant_priv | References_priv | Index_priv | Alter_priv | =3D N

SO WHEN I am connected with user "marc01" and that I use the database =
"marc" and put the following command :
mysql> LOAD DATA INFILE "/home/marc01/temp/armures.txt" INTO TABLE =
marc.armures LINES TERMINATED BY '\n';

I have the following error :

YES)

Is somebody should help me ?

Thxs,
        Marc LAVERROUX

PS : Sorry for my english :)

------=_NextPart_000_0119_01C06B62.4F938990--

 
 
 

Error 1045 : Access Denied

Post by John Cic » Sat, 23 Dec 2000 00:08:30


Marc,
I'm not sure if this is just an typing error in your note, but if you
entered:


'xxxxxxxxxx' with grant option;

and then tried to access the mysql with this info:

SO WHEN I am connected with user "marc01" and that I use the database
"marc" and put the following command :


but then you attempted to load data into the marc database.

Have a great day...
John


> Hi,

>     I have a problem which i can't resolve.  So, I have create as root an user :


> mysql> select * from db where user="marc01";
> Here's the result :

> Host    localhost
> Db    marc
> User    marc01
> Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Grant_priv | References_priv | Index_priv | Alter_priv | = Y

> mysql> select * from user where user="marc01";
> Here's the result :

> Host    localhost
> User    marc01
> Password    xxxxxxxx
> Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv | Process_priv | File_priv | Grant_priv | References_priv | Index_priv | Alter_priv | = N

> SO WHEN I am connected with user "marc01" and that I use the database "marc" and put the following command :
> mysql> LOAD DATA INFILE "/home/marc01/temp/armures.txt" INTO TABLE marc.armures LINES TERMINATED BY '\n';

> I have the following error :

> Is somebody should help me ?

> Thxs,
>         Marc LAVERROUX

> PS : Sorry for my english :)

--
---------------------------------------------------------------------
Please check "http://www.mysql.com/documentation/manual.php" before

To unsubscribe, send a message to:

If you have a broken mail client that cannot send a message to
the above address (Microsoft Outlook), you can use:
    http://lists.mysql.com/php/unsubscribe.php

 
 
 

Error 1045 : Access Denied

Post by Marc LAVERROU » Sat, 23 Dec 2000 00:20:12


John,

Yes, I am sorry the database is "marc" for user "marc01", and I grant all
privileges to user "marc01" on "marc.*"

Best regards,
    Marc

----- Original Message -----



Sent: Thursday, December 21, 2000 3:50 PM
Subject: Re: Error 1045 : Access Denied

> Marc,
> I'm not sure if this is just an typing error in your note, but if you
> entered:


> 'xxxxxxxxxx' with grant option;

> and then tried to access the mysql with this info:

> SO WHEN I am connected with user "marc01" and that I use the database
> "marc" and put the following command :


> but then you attempted to load data into the marc database.

> Have a great day...
> John


> > Hi,

> >     I have a problem which i can't resolve.  So, I have create as root
an user :


by 'xxxxxxxxxx' with grant option;
> > mysql> select * from db where user="marc01";
> > Here's the result :

> > Host    localhost
> > Db    marc
> > User    marc01
> > Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv |
Drop_priv | Grant_priv | References_priv | Index_priv | Alter_priv | = Y

> > mysql> select * from user where user="marc01";
> > Here's the result :

> > Host    localhost
> > User    marc01
> > Password    xxxxxxxx
> > Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv |
Drop_priv | Reload_priv | Shutdown_priv | Process_priv | File_priv |
Grant_priv | References_priv | Index_priv | Alter_priv | = N

> > SO WHEN I am connected with user "marc01" and that I use the database
"marc" and put the following command :
> > mysql> LOAD DATA INFILE "/home/marc01/temp/armures.txt" INTO TABLE
marc.armures LINES TERMINATED BY '\n';

> > I have the following error :

YES)

> > Is somebody should help me ?

> > Thxs,
> >         Marc LAVERROUX

> > PS : Sorry for my english :)

--
---------------------------------------------------------------------
Please check "http://www.mysql.com/documentation/manual.php" before

To unsubscribe, send a message to:

If you have a broken mail client that cannot send a message to
the above address (Microsoft Outlook), you can use:
    http://lists.mysql.com/php/unsubscribe.php

 
 
 

1. ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)

Hello.

...........................

Looks like mysqld didn't started properly. What is in the error log?

We'll check this after solving the problem with the daemon's start.

--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Gleb Paharenko

/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
       <___/   www.mysql.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

2. modem rate adaptation

3. ERROR 1045: Access denied for user:

4. Jobs: Graphics Programmer & Retouch Specialist

5. ERROR 1045: Access denied for user: 'abcd@localhost' (Using password:

6. Safe location to place Powerbook

7. ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)

8. Need info on Dynamic Screen Manager APIs (DSM)

9. ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES)

10. ERROR 1045: Access denied for user: 'root@localhost' (Using password:

11. ERROR 1045: Access denied for user: 'root@localhost' (Using

12. ERROR 1045: Access denied for user: 'abcd@localhost' (Using password: YES)

13. ERROR 1045: Access denied for user: 'root@localhost' (Using password: