1st time to install mysql on linux...

Ye' old general discussion board. Basically, for everything that isn't covered elsewhere. Come here to shoot the breeze, shoot your mouth off, or whatever suits your fancy.
This forum is not for asking programming related questions.

Moderator: General Moderators

Post Reply
User avatar
infolock
DevNet Resident
Posts: 1708
Joined: Wed Sep 25, 2002 7:47 pm

1st time to install mysql on linux...

Post 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...
User avatar
John Cartwright
Site Admin
Posts: 11470
Joined: Tue Dec 23, 2003 2:10 am
Location: Toronto
Contact:

Post by John Cartwright »

This is mostly the reason I have other people set up my servers :lol:
User avatar
Jenk
DevNet Master
Posts: 3587
Joined: Mon Sep 19, 2005 6:24 am
Location: London

Post 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
User avatar
Chris Corbyn
Breakbeat Nuttzer
Posts: 13098
Joined: Wed Mar 24, 2004 7:57 am
Location: Melbourne, Australia

Post 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 :?
User avatar
Jenk
DevNet Master
Posts: 3587
Joined: Mon Sep 19, 2005 6:24 am
Location: London

Post 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.
User avatar
infolock
DevNet Resident
Posts: 1708
Joined: Wed Sep 25, 2002 7:47 pm

Post 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
Post Reply