Marvin,
Although this goes way off topic for this forum, the localhost password
you've got there should be "root" and the password "pwd".
When the form asks for the server write "localhost", and if that fails use
"host" and you should be in. There isn't a password for localhost,
that is unless you've done a very strange install and going away from the
wamp install lines. Good luck mate...
DougB
----- Original Message -----
From: "Marvin Hunkin" <startrekc...@gmail.com>
To: <wsg@webstandardsgroup.org>
Sent: Sunday, December 11, 2011 8:47 PM
Subject: [WSG] Wamp, Accessibility, How To Reset Passwords In My Sql
hi.
doing a website development course from http?wsi.tafensw.edu.au, and doing
php.
and the lecturers are on vacation.
so, working my way through this subject.
and so up to inserting data into a database, using php and my sql, in a
form.
now.
got this stupid error, which i will paste below.
and my code.
and the form.
can any one help?
getting a access denied localhost and password error.
how do i fix this?
using wamp server 2.2.
bagning my head, looked up google, and tried to update my sql server, in
the my sql command line prompt.
tried to clear the cache, but no success.
can any one help me out.
so what code, or what sql commands do i need to use, and where?
using wamp server, and looked in the php my admin, my database is there,
with the table i created.
so, just totally frustrated.
if any one can help.
let me know.
Marvin.
ps: the lecturers are on vacation till early febuary.
would like an answer to my problem.
using windows 7 professional, 32 bit, jaws 13, using wamp server 2.2, my
sql 5.5.16, php 5.35, latest version.
can any one help.
so how to reset the password for the local host.
that is what i am looking for.
just totally frustrated.
rewrote the code for this weeks exercise from my lecturer a few times, but
still giving me the error.
and learning, php, and my sql.
can any one help?
this is giving me a migrain.
Marvin, from Devonport, Tasmania, Australia.
if any aussies on the list, maybe can give me a hand.
<?php
$firstname=$_POST['firstname'];
$lastname=$_POST['lastname'];
$phone=$_POST['phone'];
$dateofbirth=$_POST['dateofbirth'];
$server="localhost";
$user="root";
$password="pwd";
$database="AddressBook";
$connection=mysql_connect($server, $user, $password);
$dbOK=@mysql_select_db($database, $connection) or die ("Unable to select
db");
$sql = "INSERT INTO tperson (firstname, lastname, phone, dateofbirth)
VALUES ('$firstname', '$lastname', '$phone', '$dateofbirth')";
$result = mysql_query($sql, $connection) or die ("Error in query:
".mysql_error());
mysql_close();
?>
ps: will http://localhost/FifthPHP/Data.php
table with 5 columns and 5 rows
( ! ) Warning: mysql_connect() [
function.mysql-connect]:
Access denied for user 'root'@'localhost' (using password: YES) in
C:\wamp\www\FifthPHP\Data.php on line 10
Call Stack
#
Time
Memory
Function
Location
1
0.0006
373088
{main}( )
..\Data.php:0
2
0.0006
373768
mysql_connect
( )
..\Data.php:10
table end
Unable to select db
ps:: will paste the html form code below as well.
<html>
<head>
<title>Person Details</title>
</head>
<body>
<form action="Data.php" method="post">
Firstname: <input type="text" name="firstname">
Lastname: <input type="text" name="lastname">
Phone: <input type="text" name="phone">
Date Of Birth : <input type="text" name="dateofbirth">
<input type="submit" name="submit" value="Submit">
</form>
</body>
</html>
*******************************************************************
List Guidelines: http://webstandardsgroup.org/mail/guidelines.cfm
Unsubscribe: http://webstandardsgroup.org/join/unsubscribe.cfm
Help: memberh...@webstandardsgroup.org
*******************************************************************
*******************************************************************
List Guidelines: http://webstandardsgroup.org/mail/guidelines.cfm
Unsubscribe: http://webstandardsgroup.org/join/unsubscribe.cfm
Help: memberh...@webstandardsgroup.org
*******************************************************************