Archives

The List

« Controlling the MySQL Slow Log (Another Item for the Wish List) | Main | MySQL Pop Quiz »

Installing MySQL 5.1 on Kubuntu, Ubuntu or Asus EEE

By Carsten | February 7, 2008

You might find yourself running into trouble when following the otherwise very well-written instructions on how to install a binary distribution of MySQL 5.1 on (K)Ubuntu.

If you get loads of errors while attempting to run scripts/mysql_install_db, you should instead run

scripts/mysql_install_db --user=mysql --no-defaults

For more MySQL-related information om this site, see:
MySQL Pop Quizzes || MySQL Function of the Day
MySQL DATE_FORMAT() and PHP DATE() tool
Other MySQL blog entries

Rant mode on…

While searching the bugs system before reporting this as a new bug, I came across this entry, and noticed that the severity of the bug is set to “S3 (non-critical)”.

How in the world can instructions that specifically guide the user into creating an admin account with no password be considered non-critical???

Topics: MySQL |

11 Responses to “Installing MySQL 5.1 on Kubuntu, Ubuntu or Asus EEE”

  1. Chris Pizzi Says:
    February 7th, 2008 at 4:01 pm

    I found that typing ./configure insetad of scripts/mysql_install_db worked perfectly. Perhaps the documentation just needs to be updated?

  2. eka Says:
    March 16th, 2008 at 10:07 am

    i am really confuse error from command mysql_install_db,
    searching anywhere not find the solution
    iam running with kubuntu, and install mysql 5.1 from source..

    but it can running now

    thx for info..

  3. robo47 Says:
    October 4th, 2008 at 6:31 am

    just stumbled across this problem setting up my local test-lampp-system …. have recompiled it again and again … tested on another debian system with the same version …. there it worked ….
    but now I am happy to find the solution here.

    thx a lot

    greetz
    robo47

  4. Syed Haseeb ul Hasan Says:
    November 11th, 2008 at 9:08 am

    i have kubuntu 8.04 and i have already installed mysql server 5.1 on my computer.
    But i don’t know how can i run it, because no where it is found in program menu in the system.

    please guide how can i run it.

    thanks and regards

    Syed Haseeb ul Hasan

  5. Santhosh Says:
    December 19th, 2008 at 12:34 pm

    scripts/mysql_install_db –user=mysql –no-defaults
    ./bin/my_print_defaults: 1: Syntax error: Unterminated quoted string
    Neither host ‘domU-12-31-39-01-58-51′ nor ‘localhost’ could be looked up with
    ./bin/resolveip
    Please configure the ‘hostname’ command to return a correct
    hostname.
    If you want to solve this at a later stage, restart this script
    with the –force option

    I am getting the above error while trying to install mysql 5.1 on ubuntu .. how do i solve it?

  6. Luckyo Says:
    January 27th, 2009 at 4:09 am

    Thanks a lot of ton. It can solve my problem.

  7. TPE Says:
    February 3rd, 2009 at 6:46 pm

    If you want an admin gui for mysql run

    sudo apt-get install mysql-admin

  8. Luca Says:
    March 31st, 2009 at 3:14 pm

    Hi Carsten!
    I’ve tried your solution but I still have an error:

    luca@flagwaver:/usr/local/mysql$ sudo scripts/mysql_install_db –user=mysql –no-defaults

    Installing MySQL system tables…
    090331 15:03:11 [Warning] Forcing shutdown of 2 plugins
    OK
    Filling help tables…
    090331 15:03:11 [Warning] Forcing shutdown of 2 plugins
    OK

    To start mysqld at boot time you have to copy
    support-files/mysql.server to the right place for your system

    PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
    To do so, start the server, then issue the following commands:

    ./bin/mysqladmin -u root password ‘new-password’
    ./bin/mysqladmin -u root -h flagwaver password ‘new-password’

    Alternatively you can run:
    ./bin/mysql_secure_installation

    which will also give you the option of removing the test
    databases and anonymous user created by default. This is
    strongly recommended for production servers.

    See the manual for more instructions.

    You can start the MySQL daemon with:
    cd . ; ./bin/mysqld_safe &

    You can test the MySQL daemon with mysql-test-run.pl
    cd ./mysql-test ; perl mysql-test-run.pl

    Please report any problems with the ./bin/mysqlbug script!

    The latest information about MySQL is available at http://www.mysql.com/
    Support MySQL by buying support/licenses from http://shop.mysql.com/

    Can you help me? I’ve followed the previous instruction at http://dev.mysql.com/doc/refman/5.1/en/installing-binary.html

    Thanks

  9. Matt Says:
    April 10th, 2009 at 11:24 pm

    I’m getting the same error as Santhosh above: “unterminated quoted string,” etc.

  10. Romeo Says:
    December 12th, 2009 at 11:32 am

    i want to know how to configure a web server on kubuntu.i have already installed apache2,mysql and php.Please note that i am using virtual box and the kubuntu is running on it.

  11. Mike Teff Says:
    February 3rd, 2010 at 12:49 pm

    my Asus Eee PC broke down a couple of months ago. I bought a new one which is still an Asus Eee, i love this netbook.

Comments