Changing from command line to a graphic interface and installing mySQL in suse 8.2 pro

I'm a newbie for linux, I run win2k as my o/s and have Suse 8.2 Professional running in VMware as a webserver so I can experiment in coding PHP without paying for a host or uninstalling my localhost which I need for ASP.

My friend set it all up for me and he did it without installing mySQL... he's now gone off on holiday for a few weeks and i'm stuck!  He left it in command line mode so I have no graphical interface.

Here's my question:

Can someone either guide me through installing mySQL in command line.... OR ....if that's a difficult way around (esp. considering im a newbie) can you first guide me through changing to a graphical desktop layout and then installing mySQL??

Notes:
1. I have the orginal DVD installation disc I just don't know where to start!
2. The webserver runs fine for most PHP code at the moment, just I can't do anything with db's.

Thanks guys.... tobz
tobz2020Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

paullamhkgCommented:
For install the mysql in command line is very easy, download the binary source from www.mysql.com and do the procedure as below

     shell> groupadd mysql
     shell> useradd -g mysql mysql
     shell> cd /usr/local
     shell> tar zxvf /path/to/mysql-VERSION-OS.tar.gz
     shell> ln -s full-path-to-mysql-VERSION-OS mysql
     shell> cd mysql
     shell> scripts/mysql_install_db
     shell> chown -R root  .
     shell> chown -R mysql data
     shell> chgrp -R mysql .
     shell> bin/safe_mysqld --user=mysql &
     or
     shell> bin/mysqld_safe --user=mysql &
     if you are running MySQL 4.x

For changing to graphical mode login, try edit the /etc/inittab from init:3 to init:5
0
paullamhkgCommented:
Oh for got to say, to understand more about mysql installation or how to go with your PHP, I will recomment you go to www.mysql.com and look for the documentation site, there have lots of informative stuff around and you can search what you need there.

Most of the mysql users 1st will read/search in there.

Hope this info can help.
0
tobz2020Author Commented:
would you believe I need more help on this ;o)

1. on www.mysql.com which version of mySQL do you recommend; 4 or 5?
2. which download should i choose (x86, libc6) or (s/390) or (IA64) or (Alpha) etc?

3. to change to graphical mode do I do the following:
linux:~ # edit /etc/inittab init:5
...and then what do I do as it says 'swap file "/etc/inittab.swp" already exists! ...at which point I just quited as I didn't want to mess anything up.

4. I need the graphical interface done first so I can download from mysql.com... unless I can do it from the DVD?

Thanks for your help....
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

paullamhkgCommented:
1st for download the mysql, I recommend the version 4 because I used it and happy with it, you can make your own choice.

if you using a IBM compatible PC x86 will be the choice.

"/etc/inittab.swp" mean you or someone have already try to edit the file, but not quitting  properly, so try to make a copy of your inittab by "cp /etc/inittab /etc/inittab.bak" so that if there anything wrong you still got the backup file to recover, than try to vi the file again, it will ask you whether you wanted to delete or recover, just choose recover or delete and make you change.
0
tobz2020Author Commented:
thanks for advice but was to no avail, maybe because i dont fully understand how linux works yet... but a friend advised me to just type "startx" after logging in and that worked, a very easy solution!
0
paullamhkgCommented:
oh sorry I forgot to mention about the startx, what I give out is the xwindows will start up everytime you startup your linux box. Yes, startx is to launch you xwindows from command promt/console mode.

If I'm too busy I'm sure I will give out the same suggestion.

Anyway, you find out the solution, send a 0 point request to EE admin, and request to delete this TA and have points refund, just post the request here http://www.experts-exchange.com/Community_Support/ will do :)

enjoy your linux life.
0
tobz2020Author Commented:
i appreciate your help even though i managed it a different way, sorry you dont get the points!

thanks again
0
paullamhkgCommented:
Dear tobz2020,

I'm not looking for points, I'm here to learn and trying my best to help.

Dear YensidMod,

please PAQ this and points refund, I've no objection.

Paul
0
Computer101Commented:
PAQed, with points refunded (50)

Computer101
E-E Admin
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Linux

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.