Results 1 to 1 of 1

Thread: MySQL error on login

  1. #1
    Just burned his ISO
    Join Date
    Jan 2010

    Default MySQL error on login

    I'm trying to get a lamp stack running on Backtrack 4. It looks like everything so far is working, that is linux, apache, and php, but I get an error when I login to MySQL. It looks like this:

    root@bt:~# mysql -u root
    ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
    Then I try this:
    root@bt:~# mysqld
    InnoDB: The log sequence number in ibdata files does not match
    InnoDB: the log sequence number in the ib_logfiles!
    100216 18:52:17  InnoDB: Database was not shut down normally!
    InnoDB: Starting crash recovery.
    InnoDB: Reading tablespace information from the .ibd files...
    InnoDB: Restoring possible half-written data pages from the doublewrite
    InnoDB: buffer...
    100216 18:52:17  InnoDB: Started; log sequence number 0 43655
    100216 18:52:17 [ERROR] Can't start server : Bind on unix socket: No such file or directory
    100216 18:52:17 [ERROR] Do you already have another mysqld server running on socket: /var/run/mysqld/mysqld.sock ?
    100216 18:52:17 [ERROR] Aborting
    100216 18:52:17  InnoDB: Starting shutdown...
    100216 18:52:18  InnoDB: Shutdown completed; log sequence number 0 43655
    100216 18:52:18 [Note] mysqld: Shutdown complete
    Anyone have any ideas?


    I got it to work by:

    root@bt:~# mysqld_safe
    nohup: ignoring input and redirecting stderr to stdout
    Starting mysqld daemon with databases from /var/lib/mysql
    mysqld_safe[9111]: started
    #new window

    HTML Code:
    root@bt:~# mysql -u root -p
    Enter password:
    Welcome to the MySQL monitor.  Commands end with ; or \g.
    Your MySQL connection id is 1
    Server version: 5.0.67-0ubuntu6 (Ubuntu)
    Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
    Last edited by Archangel-Amael; 02-17-2010 at 11:31 AM.

Similar Threads

  1. i tried to login using default what did i do wrong
    By sealed777 in forum Beginners Forum
    Replies: 7
    Last Post: 03-30-2010, 09:43 PM
  2. Resetting root password without login
    By xX_Spiidey_Xx in forum BackTrack Howtos
    Replies: 11
    Last Post: 03-27-2010, 05:30 AM
  3. can login
    By rotleader in forum Beginners Forum
    Replies: 6
    Last Post: 02-17-2010, 07:45 AM
  4. How to know what kind of login?
    By giansbu in forum Beginners Forum
    Replies: 2
    Last Post: 02-16-2010, 12:55 PM

Posting Permissions

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