[PHP-DB] PHP mysql_connect Access Denied

2001-03-19 Thread Matt Coyne 

Hi

Newbie here

I am running Apache/PHP/MySQL locally which emulates my server environment
online. I want to use it as a test environment.

I am running through Julie Meloni's 'PHP Fast  Easy...' and have run up
against a problem.

Using the mysql_connect statement in a php page:

? 
$connection=mysql_connect("localhost", "threezero", "qwerty00") or die
("could not connect");

if ($connection) {
$msg = "success";
}

?
html
head
titleMySQL Connection/title
/head
body bgcolor="#FF" text="#00"

? echo "$msg"; ?

/body
/html

I get the following error returned in any browser:

Warning: MySQL Connection Failed: Can't connect to MySQL server on
'localhost' (10061) in c:\program files\apache
group\apache\htdocs\threezero\phptests\dbstuff\db_connect.php on line 2
could not connect

This is returned after enetering the following into the 'mysql' database
using the MySQL monitor:

insert into user (host, user, password) values ('localhost', 'threezero',
password('qwerty00');

Querying the table returns the inserted values in the table (the password
column being encrypted).

I am thinking that there are some potential configuration problems as the
php page works in my online server environment (pair networks)

Has anyone got an idea where I am going wrong and/or can point me in the
right direction?

Any help appreciated.

TIA
Matt Coyne


t  h  r  e  e  z  e  r  o :   :  :

the mill, millstone lane, leicester, le1 5jn
e : [EMAIL PROTECTED] ::  m : 07747 845690
w : http://www.threezero.co.uk

:   :  :t  h  r  e  e  z  e  r  o



-- 
PHP Database 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-DB] PHP mysql_connect Access Denied

2001-03-19 Thread Julie Meloni 


 I get the following error returned in any browser:
 
 Warning: MySQL Connection Failed: Can't connect to MySQL server on
 'localhost' (10061) in c:\program files\apache
 group\apache\htdocs\threezero\phptests\dbstuff\db_connect.php on line 2
 could not connect

could be that mysqld isn't running...

++
| Julie Meloni ([EMAIL PROTECTED]) |
||
| "PHP Essentials" and "PHP Fast  Easy" |
|   http://www.thickbook.com |
++


-- 
PHP Database 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-DB] PHP mysql_connect Access Denied

2001-03-19 Thread olinux 

http://mysql.com/documentation/mysql/bychapter/manual_Privilege_system.html#
Adding_users

Check out the docs here.

You need to add users this way:

shell mysql --user=root mysql
mysql GRANT ALL PRIVILEGES ON *.* TO monty@localhost
   IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
mysql GRANT ALL PRIVILEGES ON *.* TO monty@"%"
   IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
mysql GRANT RELOAD,PROCESS ON *.* TO admin@localhost;
mysql GRANT USAGE ON *.* TO dummy@localhost;

olinux

- Original Message -
From: "Matt Coyne" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, March 19, 2001 8:16 AM
Subject: [PHP-DB] PHP mysql_connect Access Denied


 Hi

 Newbie here

 I am running Apache/PHP/MySQL locally which emulates my server environment
 online. I want to use it as a test environment.

 I am running through Julie Meloni's 'PHP Fast  Easy...' and have run up
 against a problem.

 Using the mysql_connect statement in a php page:

 ?
 $connection=mysql_connect("localhost", "threezero", "qwerty00") or die
 ("could not connect");

 if ($connection) {
 $msg = "success";
 }

 ?
 html
 head
 titleMySQL Connection/title
 /head
 body bgcolor="#FF" text="#00"

 ? echo "$msg"; ?

 /body
 /html

 I get the following error returned in any browser:

 Warning: MySQL Connection Failed: Can't connect to MySQL server on
 'localhost' (10061) in c:\program files\apache
 group\apache\htdocs\threezero\phptests\dbstuff\db_connect.php on line 2
 could not connect

 This is returned after enetering the following into the 'mysql' database
 using the MySQL monitor:

 insert into user (host, user, password) values ('localhost', 'threezero',
 password('qwerty00');

 Querying the table returns the inserted values in the table (the password
 column being encrypted).

 I am thinking that there are some potential configuration problems as the
 php page works in my online server environment (pair networks)

 Has anyone got an idea where I am going wrong and/or can point me in the
 right direction?

 Any help appreciated.

 TIA
 Matt Coyne


 t  h  r  e  e  z  e  r  o :   :  :

 the mill, millstone lane, leicester, le1 5jn
 e : [EMAIL PROTECTED] ::  m : 07747 845690
 w : http://www.threezero.co.uk

 :   :  :t  h  r  e  e  z  e  r  o



 --
 PHP Database 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]


_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com


-- 
PHP Database 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]