MySQL Forums
Forum List  »  Perl

Re: Can't connect to MySql server
Posted by: Randy Clamons
Date: June 09, 2009 11:32AM

It's hard to tell exactly what's going on, but I'll take a guess and give you a suggestion.

1. Are you sure your server is listening on localhost? Check your settings in my.ini or my.cfg, depending on your version or OS. There should be a line in the mysqld section that says "bind-address=127.0.0.1". Do not bind to localhost.

2. Is the user 'sa' authorized to access your server using local host? Look in mysql.user. There needs to be an entry for 'sa' for host=localhost or host=127.0.0.1

Options: ReplyQuote


Subject
Written By
Posted
June 09, 2009 02:58AM
Re: Can't connect to MySql server
June 09, 2009 11:32AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.