Re: Access denied irregularities
Nick,
Monday, May 06, 2002, 1:30:22 PM, you wrote:
NW Hi all, I'm getting intermittent 'Access denied' errors when running a
NW php script to admin a mysql db. I've looked in the manual but cannot
NW work out why I can connect in some parts of the script and not in others
NW Perhaps there is some common 'gotchas' you might let me know about?
NW Here is the code I use to connect:
NW function _db_connect() {
NW if(!$this-link_id) {
NW $this-link_id=mysql_connect($this-host, $this-user,
NW $this-pass);
NW }
NW if(!$this-link_id) {
NW return FALSE;
NW }
NW $db=mysql_select_db($this-db) or die (can't select db);
NW return TRUE;
NW }
NW Many thanks for any help :-)
Access denied error occurs when you have no required privileges to
connect to the MySQL server. You gave incomplete error message and I
can't give you detailed answer. Please, check the following
link, you can find description of this error there:
http://www.mysql.com/doc/A/c/Access_denied.html
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Egor Egorov
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
___/ www.mysql.com
-
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: Access denied irregularities
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 * and then Egor Egorov declared Access denied error occurs when you have no required privileges to connect to the MySQL server. You gave incomplete error message and I can't give you detailed answer. Please, check the following link, you can find description of this error there: http://www.mysql.com/doc/A/c/Access_denied.html Yes, I've already been there. No luck. the problem seems to be on/off part of the time it is okay and at other times not. It is just a regular 'Access denied to user 'nick@localhost using passwore YES' error. - -- Nick Wilson // www.explodingnet.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux) iD8DBQE81n36HpvrrTa6L5oRAsTCAKCmYg8C6gO98Ci95gUJFFDP29KIGgCgh3AF nA5VXs3zxNVcnd4HsLB6cS8= =dTXx -END PGP SIGNATURE- - 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: Access denied irregularities
Make sure that the user + host combination you are giving has privileges
in the MySQL server you are trying to connect. You may wanna check user
table in the mysql database.
Gurhan
-Original Message-
From: Nick Wilson [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 06, 2002 6:30 AM
To: [EMAIL PROTECTED]
Subject: Access denied irregularities
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi all, I'm getting intermittent 'Access denied' errors when running a
php script to admin a mysql db. I've looked in the manual but cannot
work out why I can connect in some parts of the script and not in others
Perhaps there is some common 'gotchas' you might let me know about?
Here is the code I use to connect:
function _db_connect() {
if(!$this-link_id) {
$this-link_id=mysql_connect($this-host, $this-user,
$this-pass);
}
if(!$this-link_id) {
return FALSE;
}
$db=mysql_select_db($this-db) or die (can't select db);
return TRUE;
}
Many thanks for any help :-)
- --
Nick Wilson // www.explodingnet.com
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.0.6 (GNU/Linux)
iD8DBQE81ls+HpvrrTa6L5oRAp0nAJwLLRlGpFV6ZQndPhqqF1+pW6w2MwCeK+H8
bsslUwVkhNA+8vVU/8S4qTc=
=jhe5
-END PGP SIGNATURE-
-
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
Re: Access denied irregularities
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 * and then Gurhan Ozen declared Make sure that the user + host combination you are giving has privileges in the MySQL server you are trying to connect. You may wanna check user table in the mysql database. Well, there must be privileges because as I said, I can connect sometimes and not others. - -- Nick Wilson // www.tioka.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux) iD8DBQE81oh/HpvrrTa6L5oRApPXAJ4uZhnlEh1uVOUva5QJRXtFq8H82ACfedLj ss8aXzi5/Spgwn2migqqnW4= =HVzX -END PGP SIGNATURE- - 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: Re: Access denied irregularities
Nick, Monday, May 06, 2002, 3:58:34 PM, you wrote: NW * and then Egor Egorov declared Access denied error occurs when you have no required privileges to connect to the MySQL server. You gave incomplete error message and I can't give you detailed answer. Please, check the following link, you can find description of this error there: http://www.mysql.com/doc/A/c/Access_denied.html NW Yes, I've already been there. No luck. the problem seems to be on/off NW part of the time it is okay and at other times not. It is just a regular NW 'Access denied to user 'nick@localhost using passwore YES' error. Did you have successfully connected as 'nick@localhost' with the same password before or Access denied error appeared after you added this user? If you have no successful connections before, how did you set up privileges for your user? Are you sure that your password is correct? Check also privilege tables, if there are any conflict entries. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - 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
