Gossamer Forum
Home : Products : Others : MySQLMan :

Access denied, Password "Yes"

Quote Reply
Access denied, Password "Yes"
I have this problem with MySQLMan through LinksSQL 2.0.4.
I can login and do everything (that I've tried to do) except export to a file. I get the following error:

MySQL Said: Access denied for user: 'myusername' (Using password: YES).
Query: SELECT * INTO OUTFILE '/mysite/catlinks.txt' FIELDS TERMINATED BY '|' ESCAPED BY '\\' LINES TERMINATED BY '\n' FROM CatLinks


I'm then prompted to login. Which I do using 'myusername' and password. The results are the same.

Where does this password 'Yes' come from? It would seem if I wasn't logged in correctly I wouldn't be able to create tables, update tables, etc., etc.,.

Anyone else get this password 'Yes'? This is an original installion from Links 2.0.4.

Thanks.




Quote Reply
Re: [Clueless] Access denied, Password "Yes" In reply to
I'm having the same problem..

Anyone have any ideas?

A permissions issue perhaps?

I saw a post in one of the forums within the last couple of months that gave the MySQL command for setting user permissions but I cannot find it now, goshdurnit.

Any help is appreciated!

--
Matt G
Quote Reply
Re: [mglaspie] Access denied, Password "Yes" In reply to
Hmmm... I'm able to export from within LinksSQL admin.

I think this is a MySQLMan bug.

Can anyone export using MySQLMan?

--
Matt G
Quote Reply
Re: [mglaspie] Access denied, Password "Yes" In reply to
I can and have been able to for awhile.

You need to use the FULL path to where your flat file is located. Not just a relative path.
========================================
Buh Bye!

Cheers,
Me
Quote Reply
Re: [mglaspie] Access denied, Password "Yes" In reply to
Yes I've been experiencing this problem too.
Quote Reply
Re: [Chewbaca] Access denied, Password "Yes" In reply to
Hi Eliot,

I tried:

/full/path/to/testexport.txt

I tried again, but this time created a blank "testexport.txt" file first.

Same problem both times.

Heck, I can't even export to screen!

Keep getting:

Permission to perform action denied!

MySQL Said: Access denied for user: 'myusername@localhost' (Using password: YES).
Query: SELECT * INTO OUTFILE '/usr/tmp/GTMM100499587724313583' FIELDS TERMINATED BY '|' ESCAPED BY '\\' LINES TERMINATED BY '\n' FROM Links_Links

Please enter your user name and password


I noticed Paul was having the same problem a few threads down...

Thanks for the reply, though.

--
Matt G
Quote Reply
Re: [RedRum] Access denied, Password "Yes" In reply to
Hi Paul,

Yeah, I noticed that after looking through this forum a little more (I don't usually frequent this one very often).

--
Matt G
Quote Reply
Re: [Matt Glaspie] Access denied, Password "Yes" In reply to
Did anyone ever solve this issue?
Quote Reply
Re: [Stealth] Access denied, Password "Yes" In reply to
Did you ever solve this data import (Access denied) issue?
Quote Reply
Re: [manc1958] Access denied, Password "Yes" In reply to
1) You need to make sure that you have IMPORT permissions to IMPORT files into your MySQL database.

2) You need to make sure that the file you are uploading is minimally set to 666 in order to upload it.

I've not had any problems uploading files, but I do have the above criteria working for me, meaning that my ISP does allow me to IMPORT and I always make sure the file permissions are correct.
========================================
Buh Bye!

Cheers,
Me