username and a password for mySQL

I installed mySQL and PHP on my computer. When I try to get
into the
database with PHPmyadmin is asks me for a username and a
password for
mySQL. Where does this Username and password come from?  How
do I
access them? I am using windows xp home.


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the
Google Groups "PHP & MySQL" group.
To post to this group, send email to phpmysqlgooglegroups.com
To unsubscribe from this group, send email to
phpmysql-unsubscribegooglegroups.com
For more options, visit this group at http://groups
.google.com/group/phpmysql
-~----------~----~----~----~------~----~------~--~---

user details are usually located on the config.php on the
phpmyadmin
folder. look for the user and password field then fill in
the your
mysql user and password.


robert4442 wrote:
> I installed mySQL and PHP on my computer. When I try to
get into the
> database with PHPmyadmin is asks me for a username and
a password for
> mySQL. Where does this Username and password come from?
 How do I
> access them? I am using windows xp home.


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the
Google Groups "PHP & MySQL" group.
To post to this group, send email to phpmysqlgooglegroups.com
To unsubscribe from this group, send email to
phpmysql-unsubscribegooglegroups.com
For more options, visit this group at http://groups
.google.com/group/phpmysql
-~----------~----~----~----~------~----~------~--~---

Thank you for your response. I found the info in the
config.php file.
Does that control the username and password or just allow me
to see
what it is?

I don't know if you can help me with a Dreamweaver problem.
Once I
found out what the mySQL username and password was I was
able to
connect to it in Dreamweaver. I have created a recordset and
can see
the tables in the database. I did the test in the recordset
box and it
works. When I add a database item from the recordset onto a
page I call
catalog.php and try to view it in the browser in get the
following.

Warning: Access denied for user: 'Robert127.0.0.1' (Using password:
YES) in
c:\phpdev5\www\recordstorephpstart\Connections\cnrecord
storephp.php on
line 9

Fatal error: Access denied for user: 'Robert127.0.0.1' (Using
password: YES) in
c:\phpdev5\www\recordstorephpstart\Connections\cnrecord
storephp.php on
line 9


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the
Google Groups "PHP & MySQL" group.
To post to this group, send email to phpmysqlgooglegroups.com
To unsubscribe from this group, send email to
phpmysql-unsubscribegooglegroups.com
For more options, visit this group at http://groups
.google.com/group/phpmysql
-~----------~----~----~----~------~----~------~--~---

Below is the code for line 9 in the
connections/cnrecordstore.php

<?php
# FileName="Connection_php_mysql.htm"
# Type="MYSQL"
# HTTP="true"
$hostname_cnrecordstorephp = "localhost";
$database_cnrecordstorephp = "RecordStorePHP";
$username_cnrecordstorephp = "root";
$password_cnrecordstorephp = "";
$cnrecordstorephp =
mysql_pconnect($hostname_cnrecordstorephp,
$username_cnrecordstorephp, $password_cnrecordstorephp) or
trigger_error(mysql_error(),E_USER_ERROR); 
?>


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the
Google Groups "PHP & MySQL" group.
To post to this group, send email to phpmysqlgooglegroups.com
To unsubscribe from this group, send email to
phpmysql-unsubscribegooglegroups.com
For more options, visit this group at http://groups
.google.com/group/phpmysql
-~----------~----~----~----~------~----~------~--~---

you need to grant your user robert as well as the 12.0.0.1
host with
some basic sql privileges before it can connect to the
database. try
adding it using phpmyadmin.

goto 127.0.0.1/phpmyadmin
click on the Privileges hyperlink
add a new user with the host you wish to use
check on the correspondong privileges

then try to edit cnrecordstorephp.php using the new user you
have just
made and test it, hope that helps


robert4442 wrote:
> Thank you for your response. I found the info in the
config.php file.
> Does that control the username and password or just
allow me to see
> what it is?
>
> I don't know if you can help me with a Dreamweaver
problem. Once I
> found out what the mySQL username and password was I
was able to
> connect to it in Dreamweaver. I have created a
recordset and can see
> the tables in the database. I did the test in the
recordset box and it
> works. When I add a database item from the recordset
onto a page I call
> catalog.php and try to view it in the browser in get
the following.
>
> Warning: Access denied for user: 'Robert127.0.0.1' (Using password:
> YES) in
>
c:\phpdev5\www\recordstorephpstart\Connections\cnrecord
storephp.php on
> line 9
>
> Fatal error: Access denied for user: 'Robert127.0.0.1' (Using
> password: YES) in
>
c:\phpdev5\www\recordstorephpstart\Connections\cnrecord
storephp.php on
> line 9


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the
Google Groups "PHP & MySQL" group.
To post to this group, send email to phpmysqlgooglegroups.com
To unsubscribe from this group, send email to
phpmysql-unsubscribegooglegroups.com
For more options, visit this group at http://groups
.google.com/group/phpmysql
-~----------~----~----~----~------~----~------~--~---