Find the answer to your Linux question:
Results 1 to 3 of 3
I hane just installed mandriva 2009 in my desktop, whenever I am trying to use Mysql it shows some error like given below.... [root@localhost chaami]# service mysqld start ls: cannot ...
Enjoy an ad free experience by logging in. Not a member yet? Register.
  1. #1
    Just Joined!
    Join Date
    Jan 2009
    Location
    Kerala
    Posts
    1

    Error in Mysql


    I hane just installed mandriva 2009 in my desktop, whenever I am trying to use
    Mysql it shows some error like given below....

    [root@localhost chaami]# service mysqld start
    ls: cannot access /var/lib/mysql/mysql: No such file or directory
    ERROR: hostname cannot be localhost, mysql_install_db is quite unstable
    https://qa.mandriva.com/show_bug.cgi?id=38398
    [root@localhost chaami]# mysql
    ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
    please help me....

  2. #2
    Linux Guru Lakshmipathi's Avatar
    Join Date
    Sep 2006
    Location
    3rd rock from sun - Often seen near moon
    Posts
    1,743
    Have you tried to restart mysql server


    /etc/init.d/mysqld restart
    And then try to connect it again using
    mysql
    command
    First they ignore you,Then they laugh at you,Then they fight with you,Then you win. - M.K.Gandhi
    -----
    FOSS India Award winning ext3fs Undelete tool www.giis.co.in. Online Linux Terminal http://www.webminal.org

  3. #3
    Just Joined!
    Join Date
    Oct 2006
    Location
    Surrey, UK
    Posts
    22
    Try the following (as root):

    1. rpm -e mysql
    2. rm -f /var/lib/mysql/mysql/*
    3. /bin/hostname 127.0.0.1
    4. urpmi mysql
    5. service mysqld start

    Hope that helps
    Terry

Posting Permissions

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