[Gentoo] Mysql does not work

#1
Hello all. I am trying to setup Mysql to use Feedonfeeds (a server side feed reader which I use to read this fine site) but I seem to be having quite a major problem. I get this error:

Cannot connect to database. Check your configuration. Mysql says: Lost connection to MySQL server during query

Unfortunatly the Mysql documentation does not shine any light on fixing the problem. I have tried setting the max_allowed_packet and the wait_timeout but they won't seem to "set". After using mysql_install_db it gives commands to set a root password via commands. But alas I get this error:

Lost connection to MySQL server during query

I am unsure what to do. I think I'm at the end of the line and I'm about to go crazy. Please help. Thank you, DreamweaverN
 

Glaanieboy

OSNN Veteran Addict
#4
seconded :yes: MySQL errors are quite common under n00bs (meaning people that just started using MySQL) and you're solution may also be their solution.
 

ZeroHour

ho3 ho3 ho3
#5
FYI
to set variables you need to do this
set-variable=tmpdir=c:/temp/mysql
in your my.ini file or relevant unix filename.
 
#6
Sure thing. Actually this was a very strange error and many things made it occur. I found that a setting I had made before that worked in FeedonFeeds (the localhost variable, it had to be set to this even though setting it to other things had worked perfectly fine on other Linux OSs). Also the user I had created for Mysql had to host "localhost" and nothing else. It seems Mysql didn't want to handel "outside" data (even though it came from the same machine). Of course the error had nothing to do with the fix. Also this set of conditions had not been seen anywhere else or so it seems (of all the searching I did nothing came close to the fix). The Mysql documentation was no help at all. I've setup Mysql on Mandrake, Red Hat and Slackware with the same software and doing the same things yet it all seemed to die when I changed to Gentoo. Oh well, it is working now and that is the main thing :).
 

Members online

No members online now.

Latest posts

Latest profile posts

Perris Calderon wrote on Electronic Punk's profile.
Ep, glad to see you come back and tidy up...did want to ask a one day favor, I want to enhance my resume , was hoping you could make me administrator for a day, if so, take me right off since I won't be here to do anything, and don't know the slightest about the board, but it would be nice putting "served administrator osnn", if can do, THANKS

Been running around Quora lately, luv it there https://tinyurl.com/ycpxl
Electronic Punk wrote on Perris Calderon's profile.
All good still mate?
Hello, is there anybody in there? Just nod if you can hear me ...
Xie
What a long strange trip it's been. =)

Forum statistics

Threads
61,971
Messages
673,299
Members
89,016
Latest member
Poseeut