Connecting to MySQL

[ward-ie]

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?

[Newsgroup_User]

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/

[ward-ie]

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

[Newsgroup_User]

ward-ie wrote:
> "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

That normally means that the MySQL server isn't running. In my
experience, MySQL doesn't start up automatically on Mac OS X 10.4, even
if you select automatic startup in the Pref Pane.

Open the MySQL Pref Pane, and start the server. If it won't start, you
may need to close down your computer and restart it.

--
David Powers
Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
Author, "Foundation PHP 5 for Flash" (friends of ED)
http://foundationphp.com/

[ward-ie]

Went into the Pref Pane and its says 'MySQL Server is running"???

[Newsgroup_User]

ward-ie wrote:
> Went into the Pref Pane and its says 'MySQL Server is running"???

I've just looked back at your error message, a see that it refers to
/var/lib/mysql/mysql.sock. That's not the default location for the MySQL
socket. It should be /tmp/mysql.sock.

I see that you're using Navicat. I wonder if that has anything to do
with it?

You could try stopping the server, then restarting your computer.
Normally, the socket file is created automatically when MySQL starts up.

--
David Powers
Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
Author, "Foundation PHP 5 for Flash" (friends of ED)
http://foundationphp.com/

[ward-ie]

OK, what I have done is changed the FTP server and testing server to another supplier, we seem to be making progress because I have new error message "MySQL 1045 Access denied for user 'root@localhost' (using password: YES).

This means to me that we have a connection frm Dreamweaver to MySQL, but I can't get in??

[ward-ie]

OK, what I have done is changed the FTP server and testing server to another supplier, we seem to be making progress because I have new error message "MySQL 1045 Access denied for user 'root@localhost' (using password: YES).

This means to me that we have a connection from Dreamweaver to MySQL, but I can't get in??

[Newsgroup_User]

ward-ie wrote:
> OK, what I have done is changed the FTP server and testing server to another
> supplier, we seem to be making progress because I have new error message "MySQL
> 1045 Access denied for user 'root@localhost' (using password: YES).
>
> This means to me that we have a connection frm Dreamweaver to MySQL, but I
> can't get in??

Yes. It means MySQL is responding, but it doesn't like your root
password. Did you set up a root password on MySQL? Also, you should
never connect as root because root has unlimited privileges. It's safer
to establish a user account with just SELECT, INSERT, UPDATE, and DELETE
privileges.

--
David Powers
Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
Author, "Foundation PHP 5 for Flash" (friends of ED)
http://foundationphp.com/

[ward-ie]

We have lift off!!
I've connected to the MySQL server and I have a huge list of databases to choose from which is a bit strange as I've only three in Navicat, any reason for this?

[Newsgroup_User]

ward-ie wrote:
> We have lift off!!

Excellent.

> I've connected to the MySQL server and I have a huge list of databases to choose from which is a bit strange as I've only three in Navicat, any reason for this?

You should see only as many databases as there are in your MySQL data
store. In a standard installation of MySQL 5.0, you have three by default:

information_schema
mysql
test

The first is a virtual database that contains information about all
other databases. It cannot be edited in any way - because it doesn't
really exist.

The mysql database controls access privileges to the entire system, and
should not be edited directly unless you really know what you're doing.

The test database is empty.

--
David Powers
Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
Author, "Foundation PHP 5 for Flash" (friends of ED)
http://foundationphp.com/

[ward-ie]

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.

[Newsgroup_User]

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/

[ward-ie]

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?