Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.

Dismiss

[PHP] Re: Connecting to a DB using PHP and mysql...

0 views

Skip to first unread message

Rick Emery

unread,

Apr 2, 2002, 2:12:05 PM4/2/02

to php-g...@lists.php.net

I assume that instead of johndoe, you used the real user name that you have
in your script

-----Original Message-----
From: Anthony Ritter [mailto:to...@gonefishingguideservice.com]
Sent: Tuesday, April 02, 2002 2:06 PM
To: Rick Emery
Subject: Rick...

Rick,
After typing in:

mysql> SHOW GRANTS FOR johndoe@localhost;

I get an ERROR 1064

Regards,
TR
..........................................

----- Original Message -----
From: Rick Emery <rem...@excel.com>
To: 'Anthony Ritter' <to...@gonefishingguideservice.com>;
<php-g...@lists.php.net>
Sent: Tuesday, April 02, 2002 12:31 PM
Subject: RE: [PHP] Re: Connecting to a DB using PHP and mysql...

> at the mysql command line, type:
> mysql> show grants for johndoe@localhost;
>
> what does it show?
..................................
>
> -----Original Message-----
> From: Anthony Ritter [mailto:to...@gonefishingguideservice.com]
> Sent: Tuesday, April 02, 2002 1:08 PM
> To: php-g...@lists.php.net
> Subject: [PHP] Re: Connecting to a DB using PHP and mysql...
>
>
> Craig,
> I tried the following.
>
> I was able to connect to mysql but not to the database "contacts".
>
> TR
> .......................................................
>
> <HTML>
> <BODY>
> <?
> define("DATABASE_HOST", "localhost");
> define("DATABASE_USER", "johndoe");
> define("DATABASE_PASSWORD", "abc");
> define("DATABASE_NAME", "contacts");
>
> $connection=mysql_connect(DATABASE_HOST,DATABASE_USER,DATABASE_PASSWORD);
> if(!$connection)
> {
> echo "Couldn't connect.";
> exit;
> }
> $db=mysql_select_db(DATABASE_NAME,$connection);
> if(!$db)
> {
> echo "Couldn't connect to the database.";
> exit;
> }
> $sql="SELECT * FROM leads";
> $mysql_result=mysql_query($sql, $connection);
> $num_rows=mysql_num_rows($mysql_result);
>
> if($num_rows==0)
> {
> echo "There is no information";
> }
> else
> {
> echo"<TABLE ALIGN=\"Center\" BORDER=\"1\">";
> echo"<TR><TH>First Name</TH><TH> =\"Arial\" SIZE=\"2\">Last Name</TH><TH> SIZE=\"2\">email</TH><TH>State</TH>";
>
> while($row=mysql_fetch_array($mysql_result))
> {
> $fname=$row["fname"];
> $lname=$row["lname"];
> $email=$row["email"];
> $state=$row["state"];
> $ID=$row["ID"];
> echo " <TR><TH>$fname</TH><TH> =\"Arial\" SIZE=\"2\">$lname</TH><TH> SIZE=\"2\">$email</TH><TH> SIZE=\"2\">$state</TH></TR>";
> }
> }
> mysql_close($connection);
> ?>
> </BODY>
> </HTML>
> ...........................................
>
> Craig Donnelly wrote in message:
> Try this for your connection:
> ............................................
> <?
> >
> > // Database constants
> > define("DATABASE_HOST", "localhost");
> > define("DATABASE_USER", "root");
> > define("DATABASE_PASSWORD", "*YOUR_PASS*");
> > define("DATABASE_NAME", "*YOUR_DB_NAME*");
> >
> > // Establish connection
> > $dbLink = mysql_connect(DATABASE_HOST, DATABASE_USER,
DATABASE_PASSWORD);
> > if(!$dbLink) {
> > print "Unable to connect to the database, please contact
Sysadmin
> > asap.";
> > } else {
> > $dbUse = mysql_select_db(DATABASE_NAME, $dbLink);
> > }
> >
> > ?>
> >
>
> --------------------------------------------------------------------------
> --
> > Hope it helps ya,
> >
> > Craig
>
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
> ---
> [This E-mail scanned for viruses by IAS, an Archiventure Company]
>
>

---
[This E-mail scanned for viruses by IAS, an Archiventure Company]

Rick Emery

unread,

Apr 2, 2002, 1:31:36 PM4/2/02

to Anthony Ritter, php-g...@lists.php.net

at the mysql command line, type:
mysql> show grants for johndoe@localhost;

what does it show?

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

Rick Emery

unread,

Apr 2, 2002, 2:18:09 PM4/2/02

to php-g...@lists.php.net

The error indicates that johndoe doesn't have permissions to any database.
If he did, it should look like:

mysql> show grants for root@localhost;
+---------------------------------------------------------------------+
| Grants for root@localhost |
+---------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION |
+---------------------------------------------------------------------+

> -----Original Message-----
> From: Anthony Ritter [mailto:to...@gonefishingguideservice.com]

> Sent: Tuesday, April 02, 2002 2:06 PM
> To: Rick Emery
> Subject: Rick...
>
>
> Rick,
> After typing in:
>
> mysql> SHOW GRANTS FOR johndoe@localhost;
>
> I get an ERROR 1064
>
> Regards,
> TR
> ..........................................
>
> ----- Original Message -----
> From: Rick Emery <rem...@excel.com>
> To: 'Anthony Ritter' <to...@gonefishingguideservice.com>;
> <php-g...@lists.php.net>
> Sent: Tuesday, April 02, 2002 12:31 PM

> Subject: RE: [PHP] Re: Connecting to a DB using PHP and mysql...
>
>
> > at the mysql command line, type:
> > mysql> show grants for johndoe@localhost;
> >
> > what does it show?

> ..................................

0 new messages