RE: [PHP] Access Denied

2009-07-28 Thread Ernie Kemp
Please ignore.

 

Newbie error solved

Thanks

 

From: Ernie Kemp [mailto:ernie.k...@sympatico.ca] 
Sent: July-28-09 9:34 PM
To: php-general@lists.php.net
Subject: [PHP] Access Denied

 

Line in Program:

//connect to server and select database

//connect to server and select database

$mysqli = mysqli_connect("localhost", "jdoe", "doepass", "testdb");

 

//create and issue the query

$sql = "SELECT f_name, l_name FROM auth_users WHERE username =
'".$_POST["username"]."' AND password = PASSWORD('".$_POST["password"]."')";

$result = mysqli_query($mysqli, $sql) or die(mysqli_error($mysqli));

 

 

Record in mySQl database:
UsersPASSWORD

id f_name l_name email username password
 Edit
 Delete1 John Doe j...@doe.com jdoe
*0AAD744979343D58A7F17A50E514E6AD6533D04B

 

 

Message from Firefox Browser:

Warning: mysqli_connect() [function.mysqli-connect
 ]: (28000/1045):
Access denied for user 'jdoe'@'localhost' (using password: YES) in
C:\wamp\www\rogers\userlogin.php on line 9

Warning: mysqli_query() expects parameter 1 to be mysqli, boolean given in
C:\wamp\www\rogers\userlogin.php on line 13

Warning: mysqli_error() expects parameter 1 to be mysqli, boolean given in
C:\wamp\www\rogers\userlogin.php on line 13

 

This one has got me.  

Please Help.

 

/Ernie



Re: [PHP] Access Denied

2009-07-28 Thread Jim Lucas

Ernie Kemp wrote:
 


Line in Program:

//connect to server and select database

//connect to server and select database

$mysqli = mysqli_connect("localhost", "jdoe", "doepass", "testdb");

 


//create and issue the query

$sql = "SELECT f_name, l_name FROM auth_users WHERE username =
'".$_POST["username"]."' AND password = PASSWORD('".$_POST["password"]."')";

$result = mysqli_query($mysqli, $sql) or die(mysqli_error($mysqli));

 

 


Record in mySQl database:
UsersPASSWORD

id f_name l_name email username password
 Edit
 Delete1 John Doe j...@doe.com jdoe
*0AAD744979343D58A7F17A50E514E6AD6533D04B

 

 


Message from Firefox Browser:

Warning: mysqli_connect() [function.mysqli-connect
 ]: (28000/1045):
Access denied for user 'jdoe'@'localhost' (using password: YES) in
C:\wamp\www\rogers\userlogin.php on line 9



Ok, not to be harsh, but I thought I would point it out before others jumped on 
this one.

The answer to your question is in the question itself.

Access denied for user 'jdoe'@'localhost' (using password: YES) in
C:\wamp\www\rogers\userlogin.php on line 9

So, since line 9 is your mysqli_connect() call, I would suggest looking at the 
manual page for that.

http://php.net/mysqli_connect

Plus look at mysql documentation on how to create a new user, grant them privileges, and flush the 
privileges table.


http://dev.mysql.com/doc/refman/5.1/en/adding-users.html

A simple Google search would have brought you to these pages.

As for the reset of the errors.  Fix the first one and the others might be 
fixed also.

Jim


Warning: mysqli_query() expects parameter 1 to be mysqli, boolean given in
C:\wamp\www\rogers\userlogin.php on line 13

Warning: mysqli_error() expects parameter 1 to be mysqli, boolean given in
C:\wamp\www\rogers\userlogin.php on line 13

 

This one has got me.  


Please Help.

 


/Ernie





--
Jim Lucas

   "Some men are born to greatness, some achieve greatness,
   and some have greatness thrust upon them."

Twelfth Night, Act II, Scene V
by William Shakespeare

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] Access Denied-phpMyAdmin

2005-04-16 Thread Andre Dubuc
On Saturday 16 April 2005 07:18 am, Mark Sargent wrote:
> Marek Kilimajer wrote:
> > Mark Sargent wrote:
> >> Hi All,
> >>
> >> I can access the database from the terminal on Fedora 3,
> >>
> >> [EMAIL PROTECTED] bin]# ./mysql -h localhost -u root -p
> >> Enter password:
> >> Welcome to the MySQL monitor.  Commands end with ; or \g.
> >> Your MySQL connection id is 2 to server version: 4.1.10a-standard
> >>
> >> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
> >>
> >> mysql>
> >>
> >> But, get the following error when accessing via phpMyAdmin with user
> >> as root and the correct password,
> >>
> >> phpMyAdmin tried to connect to the MySQL server, and the server
> >> rejected the connection. You should check the host, username and
> >> password in config.inc.php and make sure that they correspond to the
> >> information given by the administrator of the MySQL server.
> >>
> >> |#1045 - Access denied for user 'root'@'localhost' (using password: YES)
> >>
> >> I don't understand this. What have I missed..?
> >>
> >> $cfg['PmaAbsoluteUri'] = 'http://localhost/phpMyAdmin-2.6.1-pl3/';
> >>
> >> $cfg['Servers'][$i]['user']  = 'root';  // MySQL user
> >> $cfg['Servers'][$i]['password']  = 'password is
> >> correct';  // MySQL password (only needed
> >
> > Change $cfg['Servers'][$i]['connect_type'], I guess it should be
> > 'socket' in your setup
>
> Hi All,
>
> thanx, but, no difference. What I don't un, is, the setup is the same as
> another FC3 box, and it works. Cheers.
>
> Mark Sargent.


Mark, 
I had the same problem. Try:

$cfg['PmaAbsoluteUri'] = '';

/**
 * Disable the default warning about $cfg['PmaAbsoluteUri'] not being set
 * You should use this if and ONLY if the PmaAbsoluteUri auto-detection
 * works perfectly.
 */
$cfg['PmaAbsoluteUri_DisableWarning'] = FALSE;

..

$cfg['Servers'][$i]['host']  = 'localhost'; // MySQL hostname or IP 
address

Hth,
Andre

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] Access Denied-phpMyAdmin

2005-04-16 Thread Mark Sargent
Marek Kilimajer wrote:
Mark Sargent wrote:
Hi All,
I can access the database from the terminal on Fedora 3,
[EMAIL PROTECTED] bin]# ./mysql -h localhost -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2 to server version: 4.1.10a-standard
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql>
But, get the following error when accessing via phpMyAdmin with user 
as root and the correct password,

phpMyAdmin tried to connect to the MySQL server, and the server 
rejected the connection. You should check the host, username and 
password in config.inc.php and make sure that they correspond to the 
information given by the administrator of the MySQL server.

|#1045 - Access denied for user 'root'@'localhost' (using password: YES)
I don't understand this. What have I missed..?
$cfg['PmaAbsoluteUri'] = 'http://localhost/phpMyAdmin-2.6.1-pl3/';
$cfg['Servers'][$i]['user']  = 'root';  // MySQL user
$cfg['Servers'][$i]['password']  = 'password is 
correct';  // MySQL password (only needed

Change $cfg['Servers'][$i]['connect_type'], I guess it should be 
'socket' in your setup

Hi All,
thanx, but, no difference. What I don't un, is, the setup is the same as
another FC3 box, and it works. Cheers.
Mark Sargent.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


Re: [PHP] Access Denied-phpMyAdmin

2005-04-16 Thread Marek Kilimajer
Mark Sargent wrote:
Hi All,
I can access the database from the terminal on Fedora 3,
[EMAIL PROTECTED] bin]# ./mysql -h localhost -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2 to server version: 4.1.10a-standard
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql>
But, get the following error when accessing via phpMyAdmin with user as 
root and the correct password,

phpMyAdmin tried to connect to the MySQL server, and the server rejected 
the connection. You should check the host, username and password in 
config.inc.php and make sure that they correspond to the information 
given by the administrator of the MySQL server.

|#1045 - Access denied for user 'root'@'localhost' (using password: YES)
I don't understand this. What have I missed..?
$cfg['PmaAbsoluteUri'] = 'http://localhost/phpMyAdmin-2.6.1-pl3/';
$cfg['Servers'][$i]['user']  = 'root';  // MySQL user
$cfg['Servers'][$i]['password']  = 'password is correct';  
// MySQL password (only needed
Change $cfg['Servers'][$i]['connect_type'], I guess it should be 
'socket' in your setup

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


Re: [PHP] Access denied problem, please help

2003-08-23 Thread Jim Lucas
These are all converted into boulean once the config file is read.  So it
doesn't matter.

on = yes = 1 = true
off = no = 0 = false

And by what method are you uploading the files?

Can you show the Form and process scripts.  If they are large scripts,
please only include the sections that does the uploading.

Jim Lucas

- Original Message - 
From: "Ryan A" <[EMAIL PROTECTED]>
To: "Jim Lucas" <[EMAIL PROTECTED]>
Sent: Saturday, August 23, 2003 4:06 AM
Subject: Re: [PHP] Access denied problem, please help


> Oops sorry,
> Here are the phpinfo files of the other 2:
>
> bestwebhosters.com/phpinfo.php
> 321go.biz/phpinfo.php
>
> jumac.com/phpinfo.php
>
>
> I have noticed that in the other two phpinfo files that it shows
> file_uploads as "on" but in jumac it shows it as "1" which according to
the
> manual at the phpinfo site is the default, maybe i should change it to
"on"?
> but how via a .htaccess as i dont hvae accsess to the php.ini file...
>
> Thanks,
> -Ryan
>
>
> > how about giving the specs on all three servers?
> >
> > So WE can see the differences.
> >
> > Jim Lucas
>
>
> > > Hi,
> > > I am trying to upload something into a directory on my server but
always
> i
> > > am getting a permission denied ONLY from this server...i have tried it
> on
> > 2
> > > other servers and they seem to be working fine but i have to get it
> > working
> > > on this server as this server is the fastest and our production
server.
> > >
> > > I have looked at the folder permissions and CHMODED/changed them from
> 644
> > to
> > > 766 and finally 777 but am getting the same error, i then had a look
at
> > the
> > > php info file (http://jumac.com/phpinfo.php) and i see file_uploading
is
> > set
> > > to 1 and 1, safe mode is off, i am not too familier with file
uploading
> so
> > > is this right? if not, how can i change it? hopefully via a .htaccess
as
> I
> > > dont have access to the php.ini file directly.
> > >
> > > These are my paths:
> > > $UserUploadDir="/usr163/home/r/y/ryanknig/public_html/BWH-Ads-Images";
> > > $UserUploadURL = "http://jumac.com/BWH-Ads-Images";;
> > >
> > >
> > > Let me again point out that this problem only seems to be on this
> server,
> > > the scripts including the upload is working perfectly on the other
test
> > > servers/sites.
> > >
> > > Kindly reply,
> > > -Ryan A.
> > >
> > >
> > >
> > > We will slaughter you all! - The Iraqi (Dis)information ministers site
> > > http://MrSahaf.com
> > >
> > >
> > >
> > > -- 
> > > PHP General Mailing List (http://www.php.net/)
> > > To unsubscribe, visit: http://www.php.net/unsub.php
> > >
> > >
> >
> >
> > -- 
> > PHP General Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
>
>


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] Access denied problem, please help

2003-08-23 Thread Ryan A
Oops sorry,
Here are the phpinfo files of the other 2:

bestwebhosters.com/phpinfo.php
321go.biz/phpinfo.php

jumac.com/phpinfo.php


I have noticed that in the other two phpinfo files that it shows
file_uploads as "on" but in jumac it shows it as "1" which according to the
manual at the phpinfo site is the default, maybe i should change it to "on"?
but how via a .htaccess as i dont hvae accsess to the php.ini file...

Thanks,
-Ryan


> how about giving the specs on all three servers?
>
> So WE can see the differences.
>
> Jim Lucas


> > Hi,
> > I am trying to upload something into a directory on my server but always
i
> > am getting a permission denied ONLY from this server...i have tried it
on
> 2
> > other servers and they seem to be working fine but i have to get it
> working
> > on this server as this server is the fastest and our production server.
> >
> > I have looked at the folder permissions and CHMODED/changed them from
644
> to
> > 766 and finally 777 but am getting the same error, i then had a look at
> the
> > php info file (http://jumac.com/phpinfo.php) and i see file_uploading is
> set
> > to 1 and 1, safe mode is off, i am not too familier with file uploading
so
> > is this right? if not, how can i change it? hopefully via a .htaccess as
I
> > dont have access to the php.ini file directly.
> >
> > These are my paths:
> > $UserUploadDir="/usr163/home/r/y/ryanknig/public_html/BWH-Ads-Images";
> > $UserUploadURL = "http://jumac.com/BWH-Ads-Images";;
> >
> >
> > Let me again point out that this problem only seems to be on this
server,
> > the scripts including the upload is working perfectly on the other test
> > servers/sites.
> >
> > Kindly reply,
> > -Ryan A.
> >
> >
> >
> > We will slaughter you all! - The Iraqi (Dis)information ministers site
> > http://MrSahaf.com
> >
> >
> >
> > -- 
> > PHP General Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
> >
>
>
> -- 
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>



We will slaughter you all! - The Iraqi (Dis)information ministers site
http://MrSahaf.com



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] Access denied problem, please help

2003-08-22 Thread Jim Lucas
how about giving the specs on all three servers?

So WE can see the differences.

Jim Lucas
- Original Message - 
From: "Ryan A" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, August 22, 2003 5:39 PM
Subject: [PHP] Access denied problem, please help


> Hi,
> I am trying to upload something into a directory on my server but always i
> am getting a permission denied ONLY from this server...i have tried it on
2
> other servers and they seem to be working fine but i have to get it
working
> on this server as this server is the fastest and our production server.
>
> I have looked at the folder permissions and CHMODED/changed them from 644
to
> 766 and finally 777 but am getting the same error, i then had a look at
the
> php info file (http://jumac.com/phpinfo.php) and i see file_uploading is
set
> to 1 and 1, safe mode is off, i am not too familier with file uploading so
> is this right? if not, how can i change it? hopefully via a .htaccess as I
> dont have access to the php.ini file directly.
>
> These are my paths:
> $UserUploadDir="/usr163/home/r/y/ryanknig/public_html/BWH-Ads-Images";
> $UserUploadURL = "http://jumac.com/BWH-Ads-Images";;
>
>
> Let me again point out that this problem only seems to be on this server,
> the scripts including the upload is working perfectly on the other test
> servers/sites.
>
> Kindly reply,
> -Ryan A.
>
>
>
> We will slaughter you all! - The Iraqi (Dis)information ministers site
> http://MrSahaf.com
>
>
>
> -- 
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



RE: [PHP] Access denied to php files in Netscape 6

2002-10-01 Thread Smith, Benjamin

It's not impossible if the site is not opened up to full public access, and he is 
using different proxy settings on each browser. 

Check those.

-Original Message-
From: Chris Shiflett [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 2 October 2002 4:23 PM
To: Chris Nielsen
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP] Access denied to php files in Netscape 6


This seems absolutely impossible. Can you verify that you are using the 
*exact* same URL with each browser? I would recommend copy/pasting the 
URL from each into a text document or something to be sure every slash, 
etc., is identical.

This will also ensure that you are accessing these scripts via the 
http:// scheme rather than the file:// scheme.

Chris

Chris Nielsen wrote:

>I'm running PWS on WinXP Pro. I can't test my php stuffs in Netscape cause
>it says Access Denied when I try to access any php file. They work fine in
>IE6.
>


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




Re: [PHP] Access denied to php files in Netscape 6

2002-10-01 Thread Chris Shiflett

This seems absolutely impossible. Can you verify that you are using the 
*exact* same URL with each browser? I would recommend copy/pasting the 
URL from each into a text document or something to be sure every slash, 
etc., is identical.

This will also ensure that you are accessing these scripts via the 
http:// scheme rather than the file:// scheme.

Chris

Chris Nielsen wrote:

>I'm running PWS on WinXP Pro. I can't test my php stuffs in Netscape cause
>it says Access Denied when I try to access any php file. They work fine in
>IE6.
>


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




RE: [PHP] Access denied errors

2002-05-06 Thread Brian McGarvie

sounds like the username/password are not being accepted...

-Original Message-
From: Nick Wilson [mailto:[EMAIL PROTECTED]]
Sent: 06 May 2002 12:32
To: php-general
Subject: [PHP] Access denied errors


-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Hi everyone, 
not sure if this is a php or mysql problem: I seem to be able to connect
in my script to mysql at the beginning but by the time I make the third
or fourth call I get 'Access denied' errors? 

Here is the function I use to connect: *Any* insight would be welcome
:-)

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

- -- 
Nick Wilson //  www.explodingnet.com



-BEGIN PGP SIGNATURE-
Version: GnuPG v1.0.6 (GNU/Linux)

iD8DBQE81mmWHpvrrTa6L5oRAm9pAJ9aV2giDsyj4VZzK5fOWBHjfg1BpQCgn0g/
Xc8fs+7jFDMxJO3lbfoz7e4=
=+xJc
-END PGP SIGNATURE-

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




RE: [PHP] Access Denied !! SOLVED!!

2002-02-15 Thread Thomas Edison Jr.

Hi,

well, after about a week or so, finally, the turmoil &
fire has extinguished. the whole problem of importing
.csv data and the access denied thingy has been
solved, all due to just 'one' single syntax!

As it turns out, the command to be applied is NOT THIS
:

LOAD DATA INFILE 'fanlist.csv' INTO TABLE try FIELDS
TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\"' LINES
TERMINATED BY '\n'

But in fact it is THIS :

LOAD DATA LOCAL INFILE 'fullpath/fanlist.csv' REPLACE
INTO TABLE try FIELDS TERMINATED BY ';' ENCLOSED BY
'"' ESCAPED BY '\\' LINES TERMINATED BY '\r\n' 

Wether you enter the command directly into the mySQL
command line, or through PHP, the error was coming the
same, and now with this, it works both ways too!

The syntax being missed was "LOCAL" in Load Data!

Thank!
T. Edison Jr.


--- Rick Emery <[EMAIL PROTECTED]> wrote:
> Thomas,
> What happens when you enter the LOAD DATA INFILE
> command directly into the
> MYSQL command line?
> 
> -Original Message-
> From: Thomas Edison Jr.
> [mailto:[EMAIL PROTECTED]]
> Sent: Friday, February 15, 2002 7:58 AM
> To: [EMAIL PROTECTED]
> Subject: [PHP] Access Denied !!
> 
> 
> Hi,
> 
> I'm facing a rather tricky problem. 
> The thing is, while connecting to the mySQL database
> using my php page, i get the "acess denied" error on
> only One Particular command, and on any other query,
> the same page, with the same login details works
> fine!
> 
> For ex, this works fine :
> 
>  $db = mysql_connect("localhost","m","pwd");
> mysql_select_db("m",$db);
> 
> $sql = "CREATE table try (ID bigint(21) NOT NULL
> auto_increment, name varchar(50), email varchar(70),
> PRIMARY KEY (ID))";
> $result = mysql_query($sql);
> echo "Thank you! Your information has been
> entered.\n";
> ?>
> 
> But this gives an "Access Denied" error :
> 
>  $db = mysql_connect("localhost","m","pwd");
> mysql_select_db("m",$db);
> 
> $query = "LOAD DATA INFILE 'fanlist.csv' INTO TABLE
> try FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY
> '\"' LINES TERMINATED BY '\n'";
> mysql_query($query) or die("error:". mysql_error());
> ?>
> 
> Why is this happening? 
> 
> T. Edison jr.
> 
> 
> =
> Rahul S. Johari (Director)
> **
> Abraxas Technologies Inc.
> Homepage : http://www.abraxastech.com
> Email : [EMAIL PROTECTED]
> Tel : 91-4546512/4522124
> ***
> 
> __
> Do You Yahoo!?
> Got something to say? Say it better with Yahoo!
> Video Mail 
> http://mail.yahoo.com
> 
> -- 
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
> 
> -- 
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
> 


=
Rahul S. Johari (Director)
**
Abraxas Technologies Inc.
Homepage : http://www.abraxastech.com
Email : [EMAIL PROTECTED]
Tel : 91-4546512/4522124
***

__
Do You Yahoo!?
Got something to say? Say it better with Yahoo! Video Mail 
http://mail.yahoo.com

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




RE: [PHP] Access Denied !!

2002-02-15 Thread Rick Emery

Thomas,
What happens when you enter the LOAD DATA INFILE command directly into the
MYSQL command line?

-Original Message-
From: Thomas Edison Jr. [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 15, 2002 7:58 AM
To: [EMAIL PROTECTED]
Subject: [PHP] Access Denied !!


Hi,

I'm facing a rather tricky problem. 
The thing is, while connecting to the mySQL database
using my php page, i get the "acess denied" error on
only One Particular command, and on any other query,
the same page, with the same login details works fine!

For ex, this works fine :



But this gives an "Access Denied" error :



Why is this happening? 

T. Edison jr.


=
Rahul S. Johari (Director)
**
Abraxas Technologies Inc.
Homepage : http://www.abraxastech.com
Email : [EMAIL PROTECTED]
Tel : 91-4546512/4522124
***

__
Do You Yahoo!?
Got something to say? Say it better with Yahoo! Video Mail 
http://mail.yahoo.com

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




RE: [PHP] Access denied for user

2001-12-06 Thread Richard Black

I would hazard a guess that you have supplied a username/password/host 
combination that isn't valid.

Check in the mysql.user table, and check that there is an entry there for 
the user and host. Thepassword should be encrypted so you won't know if its 
what you're typing, but you should be able to alter this to something else 
if you think it might be wrong.

One other thing worth noting, is that MySQL only picks up changes to user's 
and user permissions when either the server process is restarted, or you 
instruct it to "flush privileges". If this user has just been added then 
maybe something like this is your problem

HTH

Richy

-Original Message-
From:   josep [SMTP:[EMAIL PROTECTED]]
Sent:   06 December 2001 11:22
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject:[PHP] Access denied for user

I get the following message when trying to view a php page

Warning: Access denied for user: 'jupshoes@localhost' (Using password: YES)
in /home/jupshoes/public_html/guest/index.php on line 27
Unable to connect to SQL server

What is going wrong

Josep


--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




Re: [PHP] Access denied for user

2001-12-06 Thread Jon Farmer

> I get the following message when trying to view a php page
>
> Warning: Access denied for user: 'jupshoes@localhost' (Using password:
YES)
> in /home/jupshoes/public_html/guest/index.php on line 27
> Unable to connect to SQL server

The username or password is incorrect. Or the username does not have
permission to log on from localhost

--
Jon Farmer
Systems Programmer, Entanet www.enta.net
Tel 01952 428969 Mob 07763 620378
PGP Key available, send email with subject: Send PGP Key



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]