Installation Problem

[Luciel]

Fill in the data press "let's go" and this comes up:

Could not create a mySQL connection, please check the SQL values entered

MySQL error was : Can't connect to local MySQL server through socket '/tmp/mysql.sock' (46)

Help!

[kegobeer]

From the MySQL Manual, A.2.2 Can't connect to [local] MySQL server:

The error (2002) Can't connect to ... normally means that there is no MySQL server running on the system or that you are using an incorrect Unix socket filename or TCP/IP port number when trying to connect to the server.

Here are some reasons the Can't connect to local MySQL server error might occur:

   * mysqld is not running. Check your operating system's process list to ensure the mysqld process is present.

   * Someone has removed the Unix socket file that mysqld uses (`/tmp/mysql.sock' by default). For example, you might have a cron job that removes old files from the `/tmp' directory. You can always run mysqladmin version to check whether the Unix socket file that mysqladmin is trying to use really exists. The fix in this case is to change the cron job to not remove `mysql.sock' or to place the socket file somewhere else. See section A.4.5 How to Protect or Change the MySQL Socket File `/tmp/mysql.sock'.

   * You have started the mysqld server with the --socket=/path/to/socket option, but forgotten to tell client programs the new name of the socket file. If you change the socket pathname for the server, you must also notify the MySQL clients. You can do this by providing the same --socket option when you run client programs. You also need to ensure that clients have permission to access the `mysql.sock' file. To find out where the mysql server socket is, you can do:

shell> netstat -l | grep mysql


If you are self hosted, brush up on how to properly set up your webserver, php, and mysql.  If not, ask your host about this problem.

[Luciel]

ok, so im new to this whole thing and i have no idea of what u just said but i dont mind giving the details of my database (login and username) if its just a one change thing if u could do that?

[kegobeer]

Are you running your own server, or do you pay someone to host your site?  If it's the first one, you'll have to fix it yourself - there's not much anyone can do about that.  If it's the second one, verify you have the correct MySQL username/password information, then tell your host the error message you get.

[Luciel]

no, yahoo runs it for me, ill email them now, cheers