Skip to main content
A
Anonymous
July 24, 2006
Question

Connecting to MySQL

  • July 24, 2006
  • 4 replies
  • 631 views
I've installed MySQL on my Mac (OSX 10.4) and installed Navicat to administer MySQL. I've got a connection in Navicat and can view the test databases already installed, so no problem there.

When I try to connect to the database through Dreamweaver 8 I get the message "HTTP Error code 500 internal server error"
I'm using the connections details of:
MySQL server: localhost
User: root
Pass: *****

Any ideas?
This topic has been closed for replies.

4 replies

A
Anonymous
July 30, 2006
I have my testing server set up to a remote server, which is the same as my remote info, and the names on the list mean nothing to me?
N
Newsgroup_User
Inspiring
July 26, 2006
ward-ie wrote:
> So why do you think I have a great long list and not the three I should have?
> Just re-installed MySQL standard 5.0 and still get the same list.

No idea. It's a situation I have never encountered before.

Are you connecting locally or to a remote server? Do any of the names on
the list mean anything to you? Are they files on your computer?

--
David Powers
Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
Author, "Foundation PHP 5 for Flash" (friends of ED)
http://foundationphp.com/
A
Anonymous
July 26, 2006
So why do you think I have a great long list and not the three I should have?
Just re-installed MySQL standard 5.0 and still get the same list.
N
Newsgroup_User
Inspiring
July 24, 2006
ward-ie wrote:
> When I try to connect to the database through Dreamweaver 8 I get the message
> "HTTP Error code 500 internal server error"

Which version of PHP? Which version of MySQL?

If you're running PHP 4, it won't support connection to MySQL 4.1 or
higher unless you use the OLD_PASSWORD protocol.

http://dev.mysql.com/doc/refman/5.0/en/old-client.html

--
David Powers
Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
Author, "Foundation PHP 5 for Flash" (friends of ED)
http://foundationphp.com/
A
Anonymous
July 25, 2006
Hi I'm seem to sorted that problem out, but here's another I now get the message >>
"MySQL Error 2002 Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)."

I've installed PHP 5.1.4 and using MySQL administrator and MySQL 5.0
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices