Page 1 of 1

1st time to install mysql on linux...

Posted: Mon Nov 28, 2005 11:17 pm
by infolock
and it was a nightmare.

mysql's documentation didn't do a bit of good for me either... but then again i'm a linux newb so what do i know.

anyways, safe_mysqld --user=mysql & saved my life.. 3 hours straight of trying to get this @#*&! RPM to work.. jeez...

in case anyone runs across the issue of this :
error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists!./mysqladmin start
and
Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!
020531 14:48:01 Aborting
or after running mysql_install_db you get
Cannot resolve host ''
blah blah blah use msyqld, blahblahblah use mysqladmin blah blah blah
the solution is just to throw your computer in the garbage and go to bed for the night... or just run safe_mysqld --user=mysql &
for me, it was located in the /usr/bin/

Using suse 10

good times...

Posted: Mon Nov 28, 2005 11:27 pm
by John Cartwright
This is mostly the reason I have other people set up my servers :lol:

Posted: Tue Nov 29, 2005 4:29 am
by Jenk
hair pulling is part of being a Linux guru, hence why most of them are either bald or balding. :P

I prefer Linux over Windows as far as a development enviroment is concerned, so good choice in moving over :P

btw, try using the mysqld_admin function, in same dir as safe_mysqld

Posted: Tue Nov 29, 2005 4:29 am
by Chris Corbyn
If you download the Binary version from the MySQL website it's pretty trivial if you just read through the README ;)

The documentation for compiling from source isn't too good. In fact, last I checked (months ago now) they stated on their own website to use the binary as they didn't recommend compiling the sources :?

Posted: Tue Nov 29, 2005 5:51 am
by Jenk
I've always done it via source compilation and never had any issues :?

Though I haven't installed any of the latest releases, think I have found something to do now.

Posted: Tue Nov 29, 2005 9:27 am
by infolock
actually d1, it was downloaded and installed via SuSe's YaST Software Control installer. It compiled and installed, I just could not get it to start the mysql server... nor could i connect. Thus the error messages I got. but the mysqld_safe command was what i used to initialize it and it worked fine.

Although I did try manually downloading and installing via the source, which just crapped out on me every time (disremember what exactly I did, but was following the instructions).

All i know is, the help me on mysql's doc site that is suposed to guide you through the errors I was getting didn't help at all. Ended up finding the solution on a message board somewhere after someone else had had the exact same issue (also a linux newb).

Jenk, Yep, I would 100% agree. I've been using a dual boot linux and windows box at work for about 5 months for all my development needs, but I'd never had to install php, apache, or mysql since all I had to do was ssh into our servers and code on the server enviorment. so, this was my first really intense step that i've taken in php. Intense for me, mundane for linux gurus, but we start somewhere ;)

The enviorment for linux is so much better to code in, it's just painful to get things working since I am coming from a point-click-work world. The main reasoning behind moving to linux though is to just try something new. I used to love dos and almost refused to go to windows 95 because they tried to get away from it. Actually, I held off til windows 98 before I finally gave in and migrated.. since then, I became a gui gimp, and as i said, am just ready for a change.

Linux provides all kinds of adventures for the geek at heart, and I finally feel that I've found the replacement for my long lost terminal days.

fun fun... but painful at the same time