An error that has been repeated many times over

Giuda · September 13th, 2006, 04:44 AM

Hi,
sorry for my bad eng.
I try to use code chapter6, file: index.php.
----------------------------------------------------------------------
<?php
  $link = mysql_connect("localhost", "bp5am", "bp5ampass")
    or die("Could not connect: " . mysql_error());
  mysql_select_db('moviesite', $link)
    or die(mysql_error());
?>
<html>
<head>
<title>Movie database</title>
<style type="text/css">
TD{color:#353535;font-family:verdana}
TH{color:#FFFFFF;font-family:verdana;background-color:#336699}
</style>
</head>
<body>
<table border="0" width="600" cellspacing="1" cellpadding="3"
       bgcolor="#353535" align="center">
  <tr>
    <td bgcolor="#FFFFFF" colspan="2" align="center">
      Movies <a href="movie.php?action=add&id=">[ADD]</a>
    </td>
  </tr>
<?php
  $moviesql = "SELECT * FROM movie";
  $result = mysql_query($moviesql)
    or die("Invalid query: " . mysql_error());
  while ($row = mysql_fetch_array($result)) {
?>
  <tr>
    <td bgcolor="#FFFFFF" width="50%">
      <?php echo $row['movie_name']; ?>
    </td>
    <td bgcolor="#FFFFFF" width="50%" align="right">
      <a href="movie.php?action=edit&id=<?php
        echo $row['movie_id']; ?>">[EDIT]</a>
      <a href="delete.php?type=movie&id=<?php
        echo $row['movie_id']?>">[DELETE]</a>
    </td>
  </tr>
<?php
  }
?>
  <tr>
    <td bgcolor="#FFFFFF" colspan="2" align="center">
      People <a href="people.php?action=add&id=">[ADD]</a>
    </td>
  </tr>
<?php
  $moviesql = "SELECT * FROM people";
  $result = mysql_query($moviesql)
    or die("Invalid query: " . mysql_error());
  while ($row = mysql_fetch_array($result)) {
?>
  <tr>
    <td bgcolor="#FFFFFF" width="50%">
      <?php echo $row['people_fullname']; ?>
    </td>
    <td bgcolor="#FFFFFF" width="50%" align="right">
      <a href="people.php?action=edit&id=<?php
        echo $row['people_id']; ?>">[EDIT]</a>
      <a href="delete.php?type=people&id=<?php
        echo $row['people_id']; ?>">[DELETE]</a>
    </td>
  </tr>
<?php
  }
?>
</table>
</body>
</html>
----------------------------------------------------------------------

But i incur in this type of error:

Warning: mysql_connect(): Accesso non consentito per l'utente: 'bp5am'@'localhost' (Password: SI) in c:\programmi\easyphp1-8\www\a1db\index.php on line 2
Could not connect: Accesso non consentito per l'utente: 'bp5am'@'localhost' (Password: SI)

A forbidden access.
I think there is a problem with db creation. I use code chapter3 to create db.
----------------------------------------------------------------------
<?php
//connect to MySQL; note we've used our own parameters- you should use
//your own for hostname, user, and password
$connect = mysql_connect("localhost", "root", "mysqlpass") or
     die ("Hey loser, check your server connection.");

//create the main database
mysql_create_db("wiley")
     or die(mysql_error());

//make sure our recently created database is the active one
mysql_select_db ("wiley");

//create "movie" table
$movie = "CREATE TABLE movie (
  movie_id int(11) NOT NULL auto_increment,
  movie_name varchar(255) NOT NULL,
  movie_type tinyint(2) NOT NULL default 0,
  movie_year int(4) NOT NULL default 0,
  movie_leadactor int(11) NOT NULL default 0,
  movie_director int(11) NOT NULL default 0,
  PRIMARY KEY (movie_id),
  KEY movie_type (movie_type,movie_year)
) TYPE=MyISAM AUTO_INCREMENT=4 ";

$results = mysql_query($movie)
     or die (mysql_error());

//create "movietype" table
$movietype = "CREATE TABLE movietype (
  movietype_id int(11) NOT NULL auto_increment,
  movietype_label varchar(100) NOT NULL,
  PRIMARY KEY (movietype_id)
) TYPE=MyISAM AUTO_INCREMENT=9" ;

$results = mysql_query($movietype)
     or die(mysql_error());

//create "people" table
$people = "CREATE TABLE people (
  people_id int(11) NOT NULL auto_increment,
  people_fullname varchar(255) NOT NULL,
  people_isactor tinyint(1) NOT NULL default 0,
  people_isdirector tinyint(1) NOT NULL default 0,
  PRIMARY KEY (people_id)
) TYPE=MyISAM AUTO_INCREMENT=7";

$results = mysql_query($people)
     or die(mysql_error());

echo "Movie Database successfully created!";

?>
----------------------------------------------------------------------

Another problem are some variable don't dichiarate...i forget some option to edit in file php?

I hope in a exaurient reply =)
Cya
Tano

ciderpunx · October 31st, 2006, 06:05 PM

Hi Tano,

this sounds like a mysql privileges problem. Use the command line client to log in and do:

Code:

mysql> GRANT ALL ON wiley.* TO 'bp5am'@'localhost' IDENTIFIED BY 'bp5ampass';
0 rows affected
mysql> FLUSH PRIVILEGES;

--
Don't Stand on your head - you'll get footprints in your hair
http://charlieharvey.org.uk
http://charlieharvey.com