Access denied selecting database

**RyanReese** · Feb 26, 2012 20:50

Go to Ryanreese.us/blog.php

Fill out some random nonsense and then click submit. It gives me this error

dbselectAccess denied for user 'ryanree1_reese'@'localhost' to database 'blog'

Ignoring that "dbselect" for now, this is my code.

config.php

PHP Code:


<?php$host="localhost";
$username="ryanree1_reese";
$password="*************";
$tableName="userSubmitted";
$DbName="blog";

?>

checkInfo.php

PHP Code:


<?phpsession_start();
include ("config.php");
?>
<!doctype html>
<html>
<head>
<title>check</title>
</head>
<body>
<?php


$contentOfPost=$_POST['contentOfPost'];
$submit=$_POST['submit'];
$date = date("Y/m/d");
$time = time();


$link = mysql_connect($host, $username, $password);


if(!$link){echo "link";die(mysql_error());}
$db_selected = mysql_select_db($DbName, $link);
if(!$db_selected){echo "dbselect";die(mysql_error());}
$insertionToDatabase="INSERT INTO $tableName ('PostNumber', 'Date', 'Time', 'Content') VALUES (NULL, '$date', '$time', '$contentOfPost')";


$result = mysql_query($insertionToDatabase);
if (!$result) {
    die('Invalid query: ' . mysql_error());
}
echo $result;
mysql_close($link);


?>


</body>
</html>

Ignore any security for now. I have no need for it until I get this sorted out. I've deduced I can logon to the database, but my line in CheckInfo.php of mysql_select_db() is wrong. What's the issue?

For reference, my DB name is ryanree1_blog and my table name is ryanree1_userSubmitted

Edit-Changed DB name to ryanree1_blog in the config.php file but no go. It's back to just "blog" now.

**ralph.m** · Feb 26, 2012 21:15

This is not my area at all, but I notice you don't have a gap between ?php and $host here:

PHP Code:


<?php$host="localhost";

I'm pretty sure there should be a gap there.

**RyanReese** · Feb 26, 2012 21:48

It's just from copy pasting.

**ralph.m** · Feb 26, 2012 21:56

Well, there's meant to be a space after <?php, so give it a try!

**RyanReese** · Feb 26, 2012 22:00

Did I not just say it's from copy pasting?

The file has a line break...

**ralph.m** · Feb 26, 2012 22:01

Originally Posted by RyanReese

Did I not just say it's from copy pasting?

Yes, but it didn't mean anything.

**RyanReese** · Feb 26, 2012 22:09

Originally Posted by ralph.m

Yes, but it didn't mean anything.

It does if you wonder why that was my response to your statement

.

**ralph.m** · Feb 26, 2012 22:22

Originally Posted by RyanReese

It does if you wonder why that was my response to your statement

.

No, to me it meant "I copied it from some reliable source in this form so I assume it's OK and you are wrong." That's why it's better to be specific and not assume your meaning is clear.

It seems a bit odd that the spaces would be removed in a copy-paste anyhow. Are your sure the source code has a space in it? You also have this in your code: <?phpsession_start(); ... again a case where a space is needed.

Of course, it may be that none of this is relevant to the issue, but it's worth pointing out.

**RyanReese** · Feb 26, 2012 22:26

I'm positive it's not an issue. Can we just wait for those who can answer this? Granted this is keeping my thread at the top.

It's also note worthy that the PHP wouldn't have allowed it to go so far down the page as to my SQL statement, it surely would have died out from the get-go. I wrote that PHP myself, had I copied it, they would have been sure to make it not crappy and add in some security

.

**oddz** · Feb 27, 2012 00:47

Has a database named "blog" and user named "ryanree1_reese" been created with permissions to access blog? Normally you would do this by using the command line and running appropriate commands to create the db, user and grant blog permissions to the user. If so than I would recommend double checking the authentication credentials by connecting to MySQL and selecting the db directly via the command prompt. It sounds to me like either the connection is failing because of incorrect credentials or the user does not have permissions to access the database. The first step though is to determine whether a connection to MySQL can be established using the given credentials by eliminating PHP from the equation and using the command line. So verify that first than attempt to use the db to verify that once a connection has been established.

**RyanReese** · Feb 27, 2012 07:21

How would I do the appropriate commands?

Right now I have PHPmyadmin installed. I created the SQL database via some mysql thing, created a username I could use, and then went to PHP myadmin to create the table.

**StarLion** · Feb 27, 2012 07:54

did you give access rights for your user? By default they have no rights...

**RyanReese** · Feb 27, 2012 08:30

Then that's probably it. I went to my admin console yesterday because I thought of that but I didn't see any option to give rights so I assumed I got it by default. How do I give mydelf access?

**StarLion** · Feb 27, 2012 08:44

Depends a little bit on what version of PHPMA you're using, but in general:
Go to the 'server' level of the breadcrumbs (Usually the "localhost" link at the top).
Click the "Privileges" tab.
Click on the Edit Privileges icon next to the user in question.
Scroll down to "Database-specific privileges". Add the database in question.
Click the Edit Privileges button next to the database.
Select the relevant privileges (for a regular user access, SIUD should be sufficient.)
Click Go.

**litebearer** · Feb 27, 2012 08:53

http://docs.cpanel.net/twiki/bin/vie...s%20Privileges

**John_Betong** · Feb 27, 2012 09:23

Just posted and noted that others have answered with the same permission possible answers.

Deleting post

**RyanReese** · Feb 27, 2012 13:57

Originally Posted by StarLion

Depends a little bit on what version of PHPMA you're using, but in general:
Go to the 'server' level of the breadcrumbs (Usually the "localhost" link at the top).
Click the "Privileges" tab.
Click on the Edit Privileges icon next to the user in question.
Scroll down to "Database-specific privileges". Add the database in question.
Click the Edit Privileges button next to the database.
Select the relevant privileges (for a regular user access, SIUD should be sufficient.)
Click Go.

There is no priviledges option

. I can screenshot my PHPmyadmin for those who want it.

Originally Posted by litebearer

http://docs.cpanel.net/twiki/bin/vie...9;s Privileges

Thing is, under account maintenance in mysql, there is no priviledges option.

**RyanReese** · Feb 27, 2012 14:00

Literally foudn it after I posted. It wasn't there but I found it.

Now I have this error, which corrolates to this PHP line.

Invalid query: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''PostNumber', 'Date', 'Time', 'Content') VALUES (NULL, '2012/02/27', '1330372760' at line 1

$insertionToDatabase="INSERT INTO $tableName ('PostNumber', 'Date', 'Time', 'Content') VALUES (NULL, '$date', '$time', '$contentOfPost')";

$result = mysql_query($insertionToDatabase);
if (!$result) {
die('Invalid query: ' . mysql_error());
}

**RyanReese** · Feb 27, 2012 17:29

K, now a new error.

Code:

<?phpinclude ("config.php");
?>
<!doctype html>
<html>
<head>
<title>check</title>
</head>
<body>
<?php


$contentOfPost=$_POST['contentOfPost'];
$submit=$_POST['submit'];
$date = date("Y/m/d");
$time = time();


$link = mysql_connect($host, $username, $password);


if(!$link){echo "link";die(mysql_error());}
$db_selected = mysql_select_db($DbName, $link);
if(!$db_selected){echo "dbselect";die(mysql_error());}
$insertionToDatabase="INSERT INTO $tableName (PostNumber, Date, Time, Content) VALUES (NULL, $date, $time, $contentOfPost)";


$result = mysql_query($insertionToDatabase);
if (!$result) {
    die('Invalid query: ' . mysql_error());
}
echo $result;
mysql_close($link);


?>


</body>
</html>

My error message is "Invalid query: Unknown column 'messageofblog' in 'field list'"

My table has 4 columns. PostNumber, Date, Time, and Content..."messageofblog" was what I inputted in my textarea, so tahts the "Content"

**RyanReese** · Feb 27, 2012 18:03

Everything is working now. Well, I may make a new thread if I can't figure out why my date and time are showing up as just a whole load of 0's, but anywa thanks to everyone

. Sorry for so many duplicate posts, I just wanted to give updates as I made a breakthrough so that people don't work on old data.

**John_Betong** · Feb 27, 2012 18:46

For debugging purposes I use the following:

PHP Code:




  # content should be validated to prevent GIGO

  $contentOfPost = isset( $_POST['contentOfPost'] ) ? $_POST['contentOfPost'] : FALSE;



  if ( ! $contentOfPost && $submit != $_POST['submit'] )

  {

    echo '<pre>';

       print_r( $_POST );

    echo '</pre>';

    die;

  }

  else

  {

    $link = mysql_connect($host, $username, $password);



    if(!$link)

    {

      echo "link";

      die(mysql_error());

    }



    $db_selected = mysql_select_db($DbName, $link);

    if( ! $db_selected )

    { 

        echo "dbselect";

        die(mysql_error());

     }



     $insertionToDatabase=

     "

       INSERT INTO $tableName 

       (

         PostNumber, Date, Time, Content

       )

       VALUES 

       (

        NULL, $date, $time, $contentOfPost

       )

     ";

     $result = mysql_query($insertionToDatabase);

    # check your SQL on error

    if ( ! $result )

    {

       echo $insertionToDatabase;

       echo '<br />';

       die( 'Invalid query: ' . mysql_error() );

    }

    echo $result;

    mysql_close($link);

  }//endelse

?>

Also, check your table Field type, Defaults and Attributes and let the database do all the work

# Field Type => TIMESTAMP
# Default => CURRENT _TIMESTAMP
# Attributes => on update CURRENT_TIMESTAMP

**RyanReese** · Feb 27, 2012 19:03

Yes the time field in my database is correct. It matches what you wrote down for me to have.

As for that code, what am I replacing it with? I posted a new thread describing my issue along with my full code.

**John_Betong** · Feb 27, 2012 19:36

@RyanReese

Yes the time field in my database is correct. It matches what you wrote down for me to have.

As for that code, what am I replacing it with? I posted a new thread describing my issue along with my full code.

If the time field is set to TIMESTAMP then changing the Default and Attributes in the table structure field dropdowns eliminate the need to pass the date and current time on updates.

PHP Code:


   #  Defaults inserted for PostNumber, Date, Time 

   $insertionToDatabase= "INSERT INTO $tableName   (  Content )  VALUES  ( $contentOfPost )";

As for that code, what am I replacing it with? I posted a new thread describing my issue along with my full code.

On errors encountered the code I posted displays more informative error messages.

**RyanReese** · Feb 27, 2012 19:59

I changed the attributes to "null"

And ok thanks for the debugging tools

.

User Tag List

Thread: Access denied selecting database

Thread Tools

Display

Access denied selecting database

Bookmarks

Bookmarks

Posting Permissions