Exit
  • Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
  • 한국 커뮤니티
0

Using D. Power's CS5 book, having problems connecting to MySQL

New Here ,
Jun 21, 2011 Jun 21, 2011

I posted this yesterday on another, similar thread.  I'm reposting as a stand alone problem in hopes of finding an answer.  Thank you for any help.

....

I am using Mr. Power's book to learn PHP for Dreamweaver CS5. I'm on a Windows 7 pro system. I followed the directions to install XAMPP but couldn't install b/c port 80 is being used by "NT Kernel & System". I changed the port from 80 to 88 both places in C:\xampp\apache\conf\httpd.conf (using the Apache Friends forums) which then worked.

When trying to finish up the exercise at http://www.adobe.com/devnet/dreamweaver/articles/setup_php.html#articl econtentAdobe_numberedheader_..., everything works great using http://localhost:88/php_test/ until the end. I can't get the MySQL to work.

I set everything according to the directions on http://localhost:88/phpmyadmin . I've set up a user account called 'testUser'@'localhost:88' with the password 'xyz'. I put in the information as:

Connection Name: connTest

MySQL Server: localhost:88

User Name: testUser

Password: xyz

Database: php_test

When I either click on "select" (for the database) or click "test", the "File Activity - localhost" box comes up and goes to "(Not Responding)" status within a few seconds. The box is white the entire time, the text I'm coping comes from the header bar. After a minute or two, a box comes up saying "a server timeout has occured. Possible reasons: 1. Make sure web server is up and running 2.verify ODBC DSN exists on test server". Not sure what to do from there. (If I've clicked on the "select" button by database, Dreamweaver will lock up so I have to shut down and restart b/c it keeps going back to the "File Activity" box.)

I've also tried having MySQL Server: "localhost". Then I get a MySQL error #1045 Access denied for user 'testUser' @ 'localhost' (using password:YES) - but I know the user name & password are correct. I've tried retyping both 10+ times! This is very frustrating for me, any help is much appreciated.

....I forgot to add the XAMPP is running in the background and shows Apache and MySQL running while I'm doing all of this..

Also, when I set up the user name 'testUser' for php_test, on the "host", I selected "local" then defined the name as 'localhost:88'

TOPICS
Server side applications
678
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Jun 22, 2011 Jun 22, 2011

Anyone have ANY suggestions?!?

I've installed/uninstalled XAMPP probably 5 or 6 times, done Revo uninstalls, used CCleaner to clean up my computer, rebooted and rebooted, gone down to XAMPP 1.7.3 done all the above again 2-3 times....nothing is working.  I keep having the same problem when I try to link the sql to the php page.

I've also gone into the sql file and change the host to "localhost:88" which didn't change a thing.

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Explorer ,
Jun 22, 2011 Jun 22, 2011

>> I've also  tried having MySQL Server: "localhost".

>> Then I get a MySQL error #1045  Access denied for user 'testUser' @ 'localhost' (using password:YES)

"localhost" is correct for your MySQL server. "localhost:88" is for your web server only.

The "access denied" error indicates it is connecting to MySQL.

Go into PHPMyAdmin and determine that the access privileges are correct for the user.

HTH

-Rob

FYI: I you make changes to privileges, you should flush privileges before testing the connection.

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Jun 22, 2011 Jun 22, 2011
LATEST

That was what I need!

I know it's stupid, but I went into localhost:88/myphpadmin and changed the testUser local host from "localhost:88" to just "localhost" and now all is working wonderfully!

Thank you.  Sometimes I don't get the obvious.

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines