Page 1 of 2 12 LastLast
Results 1 to 10 of 12

Thread: MySQL on 12.04

  1. #1
    Join Date
    Sep 2012
    Beans
    30

    MySQL on 12.04

    I am new to Ubuntu and have been trying to install mysql on to a laptop. A laptop which I bought specifically to learn about Ubuntu.

    Is there an idots step by step guide I can use since I seem to have created a user called mysql and I am really confused about the issue of not being able to access the root password in ubuntu. I assume it is not needed for the root of mysql is it the same different?

    How do I run a client to access the database any pointers please?



    So far

    I think I have installed mysql, it's not a good start is it? On the command line (as user rd) I tried:

    sudo apt-get install mysql-server

    rd@rd-W240HU-W250HUQ:~$ sudo apt-get install mysql-server
    [sudo] password for rd:
    Reading package lists... Done
    Building dependency tree
    Reading state information... Done
    mysql-server is already the newest version.
    The following packages were automatically installed and are no longer required:
    language-pack-kde-en language-pack-kde-en-base kde-l10n-engb
    calligra-l10n-engb libboost-date-time1.46.1 libmusicbrainz4c2a libvpx0
    libgrail1 amarok-help-en
    Use 'apt-get autoremove' to remove them.
    0 upgraded, 0 newly installed, 0 to remove and 1 not upgraded.

    and then

    rd@rd-W240HU-W250HUQ:~$ sudo netstat -tap | grep mysql
    tcp 0 0 localhost:mysql *:* LISTEN 1090/mysqld

    So assume it must be running?.

  2. #2
    Join Date
    Nov 2007
    Location
    London, England
    Beans
    7,699

    Re: MySQL on 12.04

    Yes it's running.
    But it's only listening on the loopback address at the moment. If you want it to listen for connections from other boxes, you will need to edit a text file somewhere, perhaps /etc/mysql.conf or something like that, then restart the service.

    There is a text mode client that you start with a command like
    Code:
    mysql -u root -p
    which tries to log in to the local mysql a user root. Mysql has its own user database so root here is not the same thing as the Linux root account, it the the name of the mysql administrator account.

    There is also a GUI mysql application called mysql-workbench. The package to install for this GUI client is also called mysql-workbench.

  3. #3
    Join Date
    Sep 2012
    Beans
    30

    Re: MySQL on 12.04

    Thank you that's very useful. I will in due course want to link to another box etc. but for the moment I just want to try to do what I have done in ms-win os. Thanks for the information about workbench that was going to be one of my next questions..

    Thanks again

  4. #4
    Join Date
    Sep 2012
    Beans
    30

    Re: MySQL on 12.04

    Can I be really lazy and ask can you point me to some easy instructions to install workbench?

  5. #5
    Join Date
    Nov 2007
    Location
    London, England
    Beans
    7,699

    Re: MySQL on 12.04

    Code:
    sudo apt-get install mysql-workbench
    should do the trick.

  6. #6
    Join Date
    Sep 2012
    Beans
    30

    Re: MySQL on 12.04

    Thanks - I have downloaded it it has installed. I assume that it will configure to 127.0.0.1:3306?

  7. #7
    Join Date
    Nov 2007
    Location
    London, England
    Beans
    7,699

    Re: MySQL on 12.04

    I think it installs with localhost in the host list by default. For other hosts, click New Connection and enter the name/address and port.

  8. #8
    Join Date
    Sep 2012
    Beans
    30

    Re: MySQL on 12.04

    Thanks very much.

  9. #9
    Join Date
    Sep 2012
    Beans
    30

    Re: MySQL on 12.04

    A couple more questions not directly related but relevant:

    1. How do I install php to work on a single pc is it as straight forward as Mysql and workbench?

    2. I understand there is a Libreoffice equivalent to the MS-Access database (which did not install when I installed it) how do I install this software?

  10. #10
    Join Date
    Nov 2007
    Location
    London, England
    Beans
    7,699

    Re: MySQL on 12.04

    1: I hve no idea

    2: The package name is libreoffice-base
    sudo apt-get install libreoffice-base

    It needs a java runtime:
    sudo apt-get install openjdk-6-jre

    I'm not sure if you will think it's as good as Access. Last time I tried it (a few years ago), I thought it seemed very clunky.

Page 1 of 2 12 LastLast

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •