Where is the password for access to the MyPHP Admin logon used?

[OmarJenkintown]

Iam a newbie to development of a .php application, so I have been using lots of tutorials and help from this forum.  I used David Powers' tutorial on installing and using XAMPP, and eventually had everything working on my desktop, and in preview.  I am using a pre-defined database (of user and password) that I create in MySQL to determine which page to display to a user.  After doing all of my development work, I upload to my remote server and immediately got errors when trying to validate the login.  Contact with my host informs me that my data base on the server is protected by a user name and password of their definition.  I was given this info 3 years ago when I first started using them, but I'd long since lost that e-mail. 

I've now got a situation where my database has one id and password, and my site is requiring another.  I believe that I should have had my site's info before setting up the MyPHP Admin.  At this point, should I re-load MyPHP Admin and use the id and password from my host?

[javissss]

If i understood you well, the php script can't connect to the database, right?

You need to match the access data in the php script, with the user and password from the database.

So, first:

If you are running your site in a hosting with CPanel, you can create the database and the user to that database without entering in phpMyAdmin

Then, you need to change the username, database name and password in your php script, to match the real values (in your webhosting)

That information is stored in /Connections/YourDBConnection.php

If you need to get inside phpMyAdmin, contact your hosting provider for a solution, like a password reset. With that password, you can do the step 1 inside from phpMyAdmin (in case you haven't CPanel on your webhosting). And after that, change the values in /Connections/YourDBConnection.php to match them.

Cheers!

[OmarJenkintown]

Thanks javissss; the problem was primarily my inexperience.  I didn't see initially when I entered MyPHP that I could create users and assign them access to specific data bases.  I've now overcome that problem and started a new discussion thread.  I need to upload an SQL table (very small) to my remote host.  I would like to do that within Dreamweaver, but don't know if that's possible. 

Thanks for your time and attention.

Cheers.

[javissss]

I think you can't manage databases with dreamweaver, you can only see them.

But it's quite simple to have that table in your host.

If you have an *.sql file:

1: create a database with it's user OR, if you already have one created, use it.

2: in phpMyAdmin get into that database, and look for the "import" button. browse your SQL file and your ready to go!

If you haven't got an SQL file, you need to create that table from phpMyAdmin. inside a new or an existing database

Cheers!