cant connect to database

Doctor-Eggman

I got a tutorial for making a comment script online. I used the .sql file attached to it to make a database. Changed all that it said but when I try to use it on the web space I get this error.

Warning: mysql_connect() [function.mysql-connect]: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) in Sitefiles/inc_rate.php on line 12
I cannot connect to the database because: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

I am really bad at databases and am not sure what to do.

When I made the database in phpmyadmin it came up with this
mySQL returned an empty result set (i.e. zero rows)

what does this mean. Here is the .sql file I was importing to try and get it working

CREATE TABLE `comments` (
  `commentid` int(11) NOT NULL auto_increment,
  `tutorialid` int(11) NOT NULL default '0',
  `name` text NOT NULL,
  `url` text NOT NULL,
  `comment` text NOT NULL,
  `email` text NOT NULL,
  `date` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`commentid`),
  KEY `tutorialid` (`tutorialid`)
)

nectarapricot

have you launced the mysql server on your localhost?
start/launch it if you do not.

Doctor-Eggman

I am really new to databases and am not 100% sure what I am doing. How do you launch MQSQL server on your localhost?

halojoy

Linux or Windows. Does not matter.

download mysql package
run installer
Many times the package will auto-install by itself.
-----
The installer sometimes give you option to install as Service (starts when you turn on PC)
or Turn it on manually when you need it.
MySQL is 90% running as Service on peoples computers.
It is no different really from installing any Program. Even Apache is a program you install.

As a service MySQL is:
Always ready to serve data from its database files.
And ready for connect to in (php) scripts or by direct SQL Commands in console.

Doctor-Eggman

is localhost even what I want? I am trying to get it to run on my website. maybe localhost wasnt what i needed. will installing that help with it working online?

nectarapricot

You need localhost to test the system you developed before update to the server.
Normally, people need the mysql server to be run on their computer

Doctor-Eggman

I dont actually have the database though. I made it using phpmyadmin on my web server. So the database lives on my web space. How can i use it offline.

Pikachu2000

The point being made is that you should have the database locally, and test and debug everything before putting it on a live, hosted site. If you expose things to the public before they're debugged, you can easily end up with a Toyota.

Not only that, but it's quicker and easier not to be forced to upload every time you change a character in a script.

Having said that, if you are unable to connect to the db with the PHP script, often you can use the same URL that is used in phpMyAdmin to connect. If that fails, you should check your hosting company's help/FAQ pages, or call their tech support for connection parameters.

Doctor-Eggman

I inserted some data into it using the insert function of phpmyadmin. I just cant get it to show on my site.

Here is just what happens when I try and load it.

http://www.compatatron.com/testpage.php

It just cant find it.

I have a database all made and it says it is there on the server. I dont get why it wont find it, the name and password are corect as is the name of the database. Its infuriating!

bradgrafelman

Show us the code where you try to connect to the database.

None of us can answer what the right way to connect to the database is - that information comes from your host and/or how MySQL was installed and configured.

halojoy

If you can connect with phpMyAdmin
then you can connect with your php script.
Because phpMyAdmin is .... that's right: a php application!
So what ever phpMyAdmin uses to connect with .. this is what you should use.