Results 1 to 6 of 6

Thread: MySQL starting problem

  1. #1
    Join Date
    Sep 2006
    Posts
    102
    Thanks
    5
    Qt products
    Qt3
    Platforms
    Unix/X11

    Default MySQL starting problem

    hii friends,

    i have freshly installed Fedora Core-6. with that MySql is installed bydefault. The version of mysql is 5.0.22
    now whenever i try to start mysql from the terminal by typing "mysql" it shows the following error :

    Error 2002 [HY000] : Cant connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

    i've checked this directory /var/lib/mysql/
    and there is no such file called mysql.sock

    by typing the command "/etc/init.d/mysqld status" on the shell it returns -->
    mysqld stopped

    and by typing the command "/etc/init.d/mysqld start" on the shell the following is shown on the terminal :

    Initializing MySQL database : Neither host 'root' nor 'localhost' could be looked up with /usr/bin/resolveip'. Please configure the 'hostname' command to return a correct hostname. If yoiu want to solve this at a later stage restart this script with --force option


    i think the mysql service is not started bydefault when the OS starts and i have to configure the hostname etc. but i dont know how to do so. also the mysql.sock file is not getting created.

    please suggest a possible solution.
    There are 10 kinds of people in this world. Those who understand binary, and those who dont.

    regards
    shamik

  2. #2
    Join Date
    Apr 2007
    Posts
    1
    Qt products
    Qt4
    Platforms
    Unix/X11 Windows

    Default Re: MySQL starting problem

    maybe you can edit the file /etc/hostname using your favorite text editor, usually one can set the hostname by editing this file

  3. #3
    Join Date
    Sep 2006
    Posts
    102
    Thanks
    5
    Qt products
    Qt3
    Platforms
    Unix/X11

    Default Re: MySQL starting problem

    what exactly should i write in that file??
    There are 10 kinds of people in this world. Those who understand binary, and those who dont.

    regards
    shamik

  4. #4
    Join Date
    Jan 2006
    Location
    Warsaw, Poland
    Posts
    33,364
    Thanks
    3
    Thanked 5,014 Times in 4,792 Posts
    Qt products
    Qt3 Qt4 Qt5 Qt/Embedded
    Platforms
    Unix/X11 Windows Android Maemo/MeeGo
    Wiki edits
    10

    Default Re: MySQL starting problem

    I guess this problem is solved now by changing /etc/hosts to include an entry with localhost, right?

  5. #5
    Join Date
    Apr 2007
    Posts
    23
    Thanks
    6
    Qt products
    Qt4
    Platforms
    Unix/X11

    Default Re: MySQL starting problem

    edit....you solved it!
    Last edited by markcole; 24th April 2007 at 18:12.

  6. #6
    Join Date
    Sep 2006
    Posts
    102
    Thanks
    5
    Qt products
    Qt3
    Platforms
    Unix/X11

    Default Re: MySQL starting problem

    Thankyou all for the help

    this problem is now solved.
    There are 10 kinds of people in this world. Those who understand binary, and those who dont.

    regards
    shamik

Similar Threads

  1. MySql Problem
    By vishesh in forum Installation and Deployment
    Replies: 7
    Last Post: 19th April 2007, 21:16
  2. My Mysql 5 and Qt 4.2.2 Problem (Driver not loaded)
    By fengtian.we in forum Qt Programming
    Replies: 4
    Last Post: 9th February 2007, 08:11
  3. MySql Stored Procedures Woes
    By stevey in forum Qt Programming
    Replies: 9
    Last Post: 19th October 2006, 12:58
  4. Qt 4.1.4 & Mysql 5 on Linux x64
    By bothapn in forum Installation and Deployment
    Replies: 7
    Last Post: 4th August 2006, 13:23
  5. Replies: 16
    Last Post: 7th March 2006, 15:57

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
  •  
Digia, Qt and their respective logos are trademarks of Digia Plc in Finland and/or other countries worldwide.