MySQL Help

TKDLady · 08-04-2006, 01:52 PM

I am trying to put a guestbook on my site and it requires me to setup a MySQL database. I keep getting an error saying it cannot connect to my local server through socket /tmp/mysql.sock. Is anyone smart on MySQL and how to set it up on Windows XP? I am very novice. Thanks.

Duke · 08-04-2006, 02:52 PM

I've never actually setup a local database server so I don't know if I can help you but if you need a database, I can supply you with one, no problem.

TKDLady · 08-04-2006, 03:29 PM

I downloaded a guestbook from the web and it has all these files in PHP and it uses mysql. I downloaded mysql and have it installed but when I run the php file to get the database to work it can't connect through the socket. I don't know where to look to fix it. The setup process was tedious and I don't know how to back out and start over.

darkangelism · 08-04-2006, 07:15 PM

you really dont want to host the guest book off your own system unless that is your web server and if its your server you dont want it running XP...but let duke set up a database for you and use that, much easier...i have gotten mysql to run a local system, but it is a pain to set up.

TKDLady · 08-04-2006, 07:47 PM

The problem is I need a canned system. I don't know how to do one on my own and the ones I have come across on the internet suck, except I like this one but it requires so much setup and I still can't get it working. I am pulling my hair out.

Duke · 08-04-2006, 07:53 PM

What is a canned system?

This site, and all of the others, are running off of mysql so it should be easy to setup, it won't affect your bandwidth on your local machine, and it won't be offline should your computer screw up, be turned off or hybernate.

TKDLady · 08-04-2006, 09:03 PM

I got a hold of the person who already had the guestbook I wanted and found out I could get it through my webhosting tools. We use the same web host. I didn't have to go through all the stuff I was going through earlier and it works now. Thanks for the support. I wish I could have understood what was wrong but I am too tired to care anymore. Maybe someday I will really get into this web building stuff and learn the tools better. For now, I am glad there are drag and drop tools that do not require too much effort.

darkangelism · 08-04-2006, 11:34 PM

i think the issue was that the mysql needed to be installed through the site not your machine, but anyway good that you got it figured out.

TKDLady · 08-05-2006, 10:38 AM

No, all the information I read yesterday talked about installing it on your own machine so you could develop databases for your websites and for other reasons. I don't know how it is working through my web host considering what I had to do but right now I don't care.

darkangelism · 08-05-2006, 03:57 PM

hmm, if you install it on your machine the database would be there not on the server. For dev purposes it would work, but you would still need an online databse for deployment

TKDLady · 08-05-2006, 04:04 PM

Doesn't matter. It didn't work anyway and I found a soultion elsewhere.

Merika · 08-05-2006, 11:24 PM

In the future you can check this out:

This ebook site repository hosts over 250 freely available I.T. and technical ebooks in pdf, chm, zip, and rar formats. The following topics are covered by these ebooks: HTML, Linux, Redhat Linux, RHCE, Debian Linux, FreeBSD, Solaris, Unix, AIX, Java, C++, C, Python, PHP, XML, Ruby, Perl, Unix Shell Programming, MySQL, Zope, JBoss, Tomcat, Apache, BEA Weblogic, PostgreSQL, DB2, Oracle, Visual Studio .Net, Security, Firewalls, VPN, Networking, Snort, Ethereal, Cisco, CCNA, Game Programming, Sun SCSA, and Subversion.

lab.lpicn.org/pub/books/

(You have to paste this into your browser, I don't know why. Maybe I need to read one of the books.)

TKDLady · 08-06-2006, 10:42 AM

Thanks. I'll check it out.