Skip to main content
O
OmarJenkintown
Participant
October 29, 2010
Question

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

  • October 29, 2010
  • 2 replies
  • 553 views

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?

This topic has been closed for replies.

2 replies

O
OmarJenkintownAuthor
Participant
October 29, 2010

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.

J
javissss
Known Participant
October 29, 2010

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!

J
javissss
Known Participant
October 29, 2010

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!

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices