Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 547
  • Last Modified:

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
0
tobz2020
Asked:
tobz2020
  • 5
  • 3
1 Solution
 
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
Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

 
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

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 5
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now