Results 1 to 10 of 10

Thread: Can't configure MySQL.

  1. #1
    Join Date
    Jul 2008
    Location
    Netherlands
    Posts
    1,140

    Default Can't configure MySQL.

    Following my own wiki article I attempted to configure MySQL but when I run mysql_install_db --user=mysql and hit enter at the very first step I get
    Code:
    ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (2)
    (openSUSE 11.2 milestone 1, x86_64)
    Special effects <- KDE 4.2 Showing off
    More KDE -> PINK KDE

  2. #2
    Join Date
    Jun 2008
    Location
    Finland, European Union
    Posts
    1,879

    Default Re: Can't configure MySQL.

    You wouldn't happen to be running MySQL 5.1 by any chance?

    rpm -q mysql

    If not, have you started the MySQL server with rcmysql start ?

  3. #3
    Join Date
    Jul 2008
    Location
    Netherlands
    Posts
    1,140

    Default Re: Can't configure MySQL.

    Umm yes I am, 5.1.34-29.1 I shouldn't be?

    Going by the wiki article it doesn't need to run at this stage yet, starting it is the next step.
    So should I downgrade to 5.0?
    Special effects <- KDE 4.2 Showing off
    More KDE -> PINK KDE

  4. #4
    Join Date
    Jun 2008
    Location
    Finland, European Union
    Posts
    1,879

    Default Re: Can't configure MySQL.

    The sock path in 5.1 changed - the easy way would be to downgrade to 5.0, 5.1 came out a bit raw anyway.

  5. #5
    Join Date
    Jul 2008
    Location
    Netherlands
    Posts
    1,140

    Default Re: Can't configure MySQL.

    Alright, I'll just downgrade then.
    Just need it working, can't say I care much about the version

    Thanks for the answer.
    Special effects <- KDE 4.2 Showing off
    More KDE -> PINK KDE

  6. #6
    Join Date
    Jul 2008
    Location
    Netherlands
    Posts
    1,140

    Default Re: Can't configure MySQL.

    Why can't it ever go smooth?
    Downgraded to 5.0.67-16.1 and still getting the same error, even rebooted to no avail.

    [edit]
    I just scrolled up it isn't entirely the same..
    Code:
    ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
    Path changed, other than that it's the same.
    Special effects <- KDE 4.2 Showing off
    More KDE -> PINK KDE

  7. #7
    Join Date
    Jun 2008
    Location
    Finland, European Union
    Posts
    1,879

    Default Re: Can't configure MySQL.

    rcmysql status and then if it's not running rcmysql start

  8. #8
    Join Date
    Jul 2008
    Location
    Netherlands
    Posts
    1,140

    Default Re: Can't configure MySQL.

    Status was unused so I ran the start command.

    mysql_install_db --user=mysql
    still gave me Installation of system tables failed!

    But /usr/bin/mysql_secure_installation ran smoothly, so I guess it's all good.

    Thanks again.
    Special effects <- KDE 4.2 Showing off
    More KDE -> PINK KDE

  9. #9
    Join Date
    Jun 2008
    Location
    Finland, European Union
    Posts
    1,879

    Default Re: Can't configure MySQL.

    By the way, to make it automatically start on system start; chkconfig mysql on

  10. #10
    Join Date
    Jul 2008
    Location
    Netherlands
    Posts
    1,140

    Default Re: Can't configure MySQL.

    I'm a clicker usually set it to autostart under YaST > Configure Runlevels.
    And now that I posted anyways, I can confirm mysql does run fine despite the warning earlier both the command line client and phpMyAdmin connecting fine

    Guess I'm in for a treat tomorrow, might have to install postgresql as well, and didn't pull that off successfully yet.. ever.
    Special effects <- KDE 4.2 Showing off
    More KDE -> PINK KDE

Posting Permissions

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