localhost priveledges lost - OS 10.3.9

Report · Apr 28, 2006

Can anyone help me with this.
I haven't changed any settings on my Mac Laptop but just no I've started getting the following message when I try to connect to the MySQL databases.

>> Unable to connect to host localhost. Be sure that the address is correct and you have the necessary priveledges <<

I have tried restarting and that made no difference.

Any suggestions?

Cheers

Dave

Report · Apr 28, 2006

have you tried flushing the privileges and resetting them?

--
Nancy Gill
Adobe Community Expert
BLOG: http://www.dmxwishes.com/blog.asp
Author: Dreamweaver 8 e-book for the DMX Zone
Co-Author: Dreamweaver MX: Instant Troubleshooter (August, 2003)
Technical Editor: DMX 2004: The Complete Reference, DMX 2004: A Beginner's
Guide, Mastering Macromedia Contribute
Technical Reviewer: Dynamic Dreamweaver MX/DMX: Advanced PHP Web Development

"davecheet" <webforumsuser@macromedia.com> wrote in message
news:e2sv6b$8i7$1@forums.macromedia.com...
> Can anyone help me with this.
> I haven't changed any settings on my Mac Laptop but just no I've started
> getting the following message when I try to connect to the MySQL
> databases.
>
> >> Unable to connect to host localhost. Be sure that the address is
> >> correct
> and you have the necessary priveledges <<
>
> I have tried restarting and that made no difference.
>
> Any suggestions?
>
>
> Cheers
>
> Dave
>
>

Report · Apr 28, 2006

Thanks Nancy ,

I gave that a try.

Or at least I think I tried that. I found a command in Navicat that was called flush priveledges but it didn't seem to do much.

Navicat gives a slighhtly different message though
The error message in navicat is:

>> Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)<<

I'm not sure if that helps identify what the problem is?

Any more ideas?

Cheers

Dave

Report · Apr 28, 2006

davecheet wrote:
> The error message in navicat is:
>
> >> Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)<<

It means that the socket file is missing. Normally, you can recreate the
socket file by closing down and restarting your Mac.

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