MySql in LINUX?

Discussion in 'Open Source' started by paragkalra, Sep 12, 2006.

Thread Status:
Not open for further replies.
  1. paragkalra

    paragkalra The Linux Man !

    Joined:
    Jan 6, 2006
    Messages:
    217
    Likes Received:
    2
    Trophy Points:
    0
    Location:
    Nagpur, Maharashtra, India
    Hi Friends,
    I am well aquainted with Linux and Oracle.

    I am using Suse 10.1 Linux, RHEL 4 AS, RHEL 4 WS, Fedora Core 5.

    I know that in all these distros, MySql comes integrated. So no need to install.

    I wanted to know how can I start MySql in LINUX in any one of these distros, particularly in RHEL.

    Q1: I mean what all files I am suppose to edit and what all daemons i am suppose to start.

    Q2: How exactly MySql of Linux differs from Oracle?

    Q3: Are there any online tutors or free ebooks available on MySql in Linux?
     
  2. mediator

    mediator New Member

    Joined:
    Mar 18, 2005
    Messages:
    2,491
    Likes Received:
    16
    Trophy Points:
    0
    Location:
    In ur Evil Mind!
    Hi Parag! I am using fedora only for last 2 yrs. So in fedora u start mysql by
    1. Opening terminal as root!
    2. Command "service mysqld start"

    For other distros the command is "/etc/init.d/mysql start" I think.

    Now if u'll encounter an error saying "Failed to start mysql" or something like that i dont remember, then open up the "/etc/hosts" file and add a new entry as "127.0.0.1 localhost"!

    That shud be it!
     
  3. OP
    OP
    paragkalra

    paragkalra The Linux Man !

    Joined:
    Jan 6, 2006
    Messages:
    217
    Likes Received:
    2
    Trophy Points:
    0
    Location:
    Nagpur, Maharashtra, India
    thanx mediator, I have started the MySql in RHEL 4 WS

    now what i wanna know that, is der any sample data base in mysql like oracle where u can log in as user: scott and password: tiger
     
  4. JGuru

    JGuru Well-Known Member

    Joined:
    Dec 25, 2005
    Messages:
    1,705
    Likes Received:
    32
    Trophy Points:
    48
    Location:
    Space-time continuum
    @Parag, To start MySQL Server , open the Terminal Window & login as 'root' & type:

    $ /etc/init.d/mysqld start

    This will start the MySQL Server.

    To make MySQL server start every time, when you boot Linux, login as 'root' & type:
    $ chkconfig mysqld on

    You can also configure it from the 'Services' in the Linux distro you are using.
    Also start Apache Web Server, install it if you haven't installed it.
    To start 'Apache Web Server' , login as 'root' & type:
    $ /etc/init.d/httpd start

    This will start the 'Apache Web Server'. Now open the browser & type:
    http://localhost

    This will show that Apache is up & running.
    Start the Apache Server first & then start MySQL server. Apache will take care
    of the 'localhost' problems!!

    Also download the MySQL 5.0 Documentation Click here
    It contains all the information you need to get started using MySQL Database.
    Goodluck.
     
  5. GNUrag

    GNUrag FooBar Guy

    Joined:
    Jun 22, 2004
    Messages:
    1,246
    Likes Received:
    5
    Trophy Points:
    0
    Location:
    Interwebs
    MySQL does not contain sample database, however you can install one from sqldump files available off the net, or maybe install a CMS like Drupal, or something like Wordpress and study its DB schema. You might also want to install PHPMyAdmin to navigate the databases.

    If you want to learn MySQL specific SQL Syntax, then use doc.mysql.com documentation. Online tutorials about MySQL are just huuggggeee. You just need to search for them using a good search engine.

    I dunno what differences you are talking about, but MySQL comes with around 5 widely used Database engines, MyISAM and InnoDB being the most common engines. Also, the biggest plus with MySQL is the language APIs available. You can start coding with MySQL databases with almost any language. All of them have MySQL connector APIs available.
     
  6. mediator

    mediator New Member

    Joined:
    Mar 18, 2005
    Messages:
    2,491
    Likes Received:
    16
    Trophy Points:
    0
    Location:
    In ur Evil Mind!
    Hi parag I dunno about any temporary/sample database in mysql. But u can create any databse easily!
    1. Start ur mysql service as I already told
    2. From root terminal connect to mysql by commanding "mysql" and then....

    a. "create user paragkalra;"
    b. "create database girlfriends;"
    c. "grant all privileges on girlfriends.* to 'paragkalra'@localhost identified by 'some_password';"

    3. escape from root terminal, and connect from local terminal as
    "mysql -u paragkalra -p girlfriends"
    4. Thats it u have a username => paragkalra, database => girlfriends now! All u need to initiate everytime is step 1 and step 3 to work with mysql !!

    Have fun!
     
  7. OP
    OP
    paragkalra

    paragkalra The Linux Man !

    Joined:
    Jan 6, 2006
    Messages:
    217
    Likes Received:
    2
    Trophy Points:
    0
    Location:
    Nagpur, Maharashtra, India
    THANX mediator, jguru and GNUrag......for ur support.......my mysql database has started..........i have even created tables.......its working wonders........thanx once again......

    thanx for this link:
    http://www.mysql.org/doc/refman/5.0/en/

    It has got an excellent documentation.....

    DIGIT FORUM ROCKS!!!!!
     
  8. Desi-Tek.com

    Desi-Tek.com New Member

    Joined:
    Oct 15, 2006
    Messages:
    370
    Likes Received:
    4
    Trophy Points:
    0
    Location:
    Mumbai
    input from expert exchange

    __________
    But PostgreSQL is giving good competition to oracle and mssql.
    Why PostgreSQL can best SQLServer, Oracle

    input from
    Code:
     http://searchopensource.techtarget.com/tip/1,289483,sid39_gci1174224,00.html 
    coz this input is only for registered user thats why i copied and posted it here

    Regards,
    Dheeraj
     
    Last edited: Oct 17, 2006
  9. GNUrag

    GNUrag FooBar Guy

    Joined:
    Jun 22, 2004
    Messages:
    1,246
    Likes Received:
    5
    Trophy Points:
    0
    Location:
    Interwebs
    @Desk-Teck,

    Dont try to put words in our mouth. Point me the place where someone in this thread made statements comparing Oracle and MySQL.

    They are different databases, under difference license terms, using different database engines. Oracle is a monster, and MySQL only supports a subset of features supported by Oracle.
     
  10. Desi-Tek.com

    Desi-Tek.com New Member

    Joined:
    Oct 15, 2006
    Messages:
    370
    Likes Received:
    4
    Trophy Points:
    0
    Location:
    Mumbai
    hmm GNU sahab i think u only read the heading.
     
    Last edited: Oct 17, 2006
  11. GNUrag

    GNUrag FooBar Guy

    Joined:
    Jun 22, 2004
    Messages:
    1,246
    Likes Received:
    5
    Trophy Points:
    0
    Location:
    Interwebs
    That was the question paragkalra asked. Where did people compare MySQL and Oracle as you say.

     
Thread Status:
Not open for further replies.

Share This Page