Page 2 of 2 FirstFirst 12
Results 11 to 18 of 18

Thread: MySQL

  1. #11
    Senior Member registered user
    Join Date
    Apr 2003
    Location
    Iowa U.S.A.
    Posts
    226
    Greeting mezz et al.

    My first thought was that perhaps the heat wave is getting to them over there. Check to be sure the DVD is not melting, reboot -- no better shut down and let it cool off for 1 hour -- take a cold shower ...

    Sorry you have to put up with my humor.

    Thy this method:
    Open one shell and type
    • su
      mysqld

    The shell will hang up but that is expected. Leave it open.
    Now open a new shell and type
    • mysql

    You should see
    • mysql>

    Best Wishes
    paradocs

  2. #12
    Junior Member registered user
    Join Date
    Jul 2003
    Location
    Belgium
    Posts
    16
    Quote Originally Posted by paradocs
    Thy this method:
    Open one shell and type
    • su
      mysqld

    The shell will hang up but that is expected. Leave it open.
    Now open a new shell and type
    • mysql

    You should see
    • mysql>
    Thanks for humor, paradocs!!. Yes, it has been rather hot around here... But even your best wishes do not help! Get still the same message :
    '
    ERROR 2002: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
    '
    I think there is something rotten in the state of Knoppix DVD and MySQL ...

    Edwin, I agree with you : odder and odder. See what I get when I start MySQL on the 2003-07-26 CD
    '
    sudo less /ramdisk/var/log/mysql/mysql.err
    30808 11:23:47 Error at /KNOPPIX/etc/init.d/mysql\n^G/usr/bin/mysqladmin: conn
    ect to server at 'localhost' failed
    error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysq
    ld.sock' (2)'
    Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock'
    exists!
    030808 11:23:47 mysqld started
    030808 11:23:48 Error at /KNOPPIX/etc/init.d/mysql\n^G/usr/bin/mysqladmin: conn
    ect to server at 'localhost' failed
    error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysq
    ld.sock' (2)'
    Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock'
    exists!
    Warning: Ignoring user change to 'mysql' because the user was set to 'mysql' ear
    lier on the command line
    /usr/sbin/mysqld: ready for connections.
    Version: '4.0.13-log' socket: '/var/run/mysqld/mysqld.sock' port: 0
    '
    But for the rest everything goes fine ...

    Wishing you all the best as well!

    Regards,

    Georges.

  3. #13
    Member registered user
    Join Date
    Jul 2003
    Location
    Delft, the Netherlands
    Posts
    76
    mzee,

    I only spotted this just now (must be the heat), so I give it another try.

    When attempting to copy the host.* files you used:

    Code:
    sudo cp -f /mnt/floppy/host.frm /KNOPPIX/var/lib/mysql/mysql
    cp: cannot remove `/KNOPPIX/var/lib/mysql/mysql/host.frm': Read-only file system
    You used '/KNOPPIX' as root for the destination where I used '/' This is a session from a CD boot:

    Code:
    knoppix@ttyp0[knoppix]$ sudo cp -f /mnt/floppy/host.frm /KNOPPIX/var/lib/mysql/mysql
    cp: cannot remove `/KNOPPIX/var/lib/mysql/mysql/host.frm': Read-only file system
    knoppix@ttyp0[knoppix]$ cat /KNOPPIX/var/lib/mysql/mysql/host.frm
    cat: /KNOPPIX/var/lib/mysql/mysql/host.frm: Permission denied
    knoppix@ttyp0[knoppix]$ sudo cp -f /mnt/floppy/host.frm /var/lib/mysql/mysql
    knoppix@ttyp0[knoppix]$  cat /var/lib/mysql/mysql/host.frm
    This is a test file
    This is not a MySql-table-description file
    knoppix@ttyp0[knoppix]$
    I don't know what this '/KNOPPIX' is (on the CD?) but we are clearly not supposed to mess with it. Using plain '/' as root works BTW. After my little sabotage-act MySql wouldn't start, complaining about incorrect information in host.frm.

    Regards,

    - - Edwin

  4. #14
    Junior Member registered user
    Join Date
    Jul 2003
    Location
    Belgium
    Posts
    16
    Quote Originally Posted by Edwin
    This is a session from a CD boot:

    Code:
    knoppix@ttyp0[knoppix]$ sudo cp -f /mnt/floppy/host.frm /KNOPPIX/var/lib/mysql/mysql
    cp: cannot remove `/KNOPPIX/var/lib/mysql/mysql/host.frm': Read-only file system
    knoppix@ttyp0[knoppix]$ cat /KNOPPIX/var/lib/mysql/mysql/host.frm
    cat: /KNOPPIX/var/lib/mysql/mysql/host.frm: Permission denied
    knoppix@ttyp0[knoppix]$ sudo cp -f /mnt/floppy/host.frm /var/lib/mysql/mysql
    knoppix@ttyp0[knoppix]$  cat /var/lib/mysql/mysql/host.frm
    This is a test file
    This is not a MySql-table-description file
    knoppix@ttyp0[knoppix]$
    Thank you for keeping on!

    I followed your advice but with the same results :
    '
    030808 20:54:05 Error at /KNOPPIX/etc/init.d/mysql\n^G/usr/bin/mysqladmin: conn
    ect to server at 'localhost' failed
    error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysq
    ld.sock' (2)'
    Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock'
    exists!
    030808 20:54:06 Error at /KNOPPIX/etc/init.d/mysql\n^G/usr/bin/mysqladmin: conn
    ect to server at 'localhost' failed
    error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysq
    ld.sock' (2)'
    Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock'
    exists!
    '
    Suggest we drop the subject. The Knoppix LinuxTag DVD is nice but MySQL on it doesn't work ....

    Happily MySQL works with the 20030606 and 20030726 Live CD's, although in a strange way : see my previous mail.

    Wish to thank you and the others for kind attention.

    Best Regards,

    Georges.

  5. #15
    Junior Member
    Join Date
    Jun 2005
    Posts
    1

    ERROR MYSQL EN UBUNTU

    Quote Originally Posted by Edwin
    I am not familiair with the DVD version, but does it start the mysql daemon automaticly at boot? Or do you start it manually? If the first go through the boot messages with 'dmesg' in a console. Look for error messages. If the last, what does it say after you start it?

    Also check if the deamon is running with 'ps -A | grep mysql'. If this returns some processes have a look at /var/log/mysql/mysql.err (as root). Do you have a mysql.pid file in /var/run/mysqld?

    HTH

    - - Edwin
    Hi, yo tambien tengo el mismo error.
    Y no, no tengo el mysql.pid...
    No se cual pueda ser el probelma.
    Slds

  6. #16
    Junior Member
    Join Date
    Sep 2005
    Posts
    2

    mysql not running Konppix 4.0.1

    Hi,

    I just downloaded the 4.0.1 DVD version of knoppix and have the same problems to run mysql

    As there is no mysqld_safe file on the system, i tried to start it via "/etc/init.d/mysql start" as root. There must be a problem in this compilation

    Starting MySQL database server: mysqld...failed.
    Please take a look at the syslog.
    /usr/bin/mysqladmin: connect to server at 'localhost' failed
    error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
    Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!

    If I tried to start via mysqld_safe I get the following:
    root@3[www]# Starting mysqld daemon with databases from /var/lib/mysql
    mysqld_safe[14763]: started
    STOPPING server from pid file /var/run/mysqld/mysqld.pid
    mysqld_safe[14769]: ended


    Does anyone have a solution now for that?

    Thanks,
    Wolfixx

  7. #17
    Junior Member
    Join Date
    Oct 2005
    Posts
    3
    You have to edit /etc/mysql/my.cnf

    Uncomment the line with: old_passwords = 1

  8. #18
    Junior Member
    Join Date
    Sep 2005
    Posts
    2

    thx

    Hi Impf,

    Thank you very much; now it works

    Wolfixx

Page 2 of 2 FirstFirst 12

Similar Threads

  1. apache and mysql
    By dr_rude in forum General Support
    Replies: 2
    Last Post: 10-11-2004, 02:37 AM
  2. MySQL Error
    By sniker in forum Hdd Install / Debian / Apt
    Replies: 2
    Last Post: 10-08-2004, 03:50 AM
  3. [MySQL] Export a DB From PHPMyAdmin to /var/lib/mysql
    By Coume in forum General Support
    Replies: 5
    Last Post: 08-06-2003, 06:42 AM
  4. [mysql] how do I use it???
    By Coume in forum Hdd Install / Debian / Apt
    Replies: 3
    Last Post: 08-04-2003, 07:00 AM
  5. Get me going with MySQL
    By Terry@nz in forum General Support
    Replies: 3
    Last Post: 06-09-2003, 10:01 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
  •  


A-Tech 8GB DDR3 1600 PC3-12800 Laptop SODIMM 204-Pin Memory RAM PC3L DDR3L 1x 8G picture

A-Tech 8GB DDR3 1600 PC3-12800 Laptop SODIMM 204-Pin Memory RAM PC3L DDR3L 1x 8G

$13.99



HyperX FURY RAM DDR4 16GB 8GB 32GB 4GB 3200 2666 2400 2133 Desktop Memory DIMM picture

HyperX FURY RAM DDR4 16GB 8GB 32GB 4GB 3200 2666 2400 2133 Desktop Memory DIMM

$9.64



A-Tech 8GB PC3-12800 Desktop DDR3 1600 MHz Non ECC 240-Pin DIMM Memory RAM 1x 8G picture

A-Tech 8GB PC3-12800 Desktop DDR3 1600 MHz Non ECC 240-Pin DIMM Memory RAM 1x 8G

$13.99



CRUCIAL DDR3L 8GB 16GB 32GB 1600 MHz PC3-12800 Laptop Memory RAM SODIMM 204-Pin picture

CRUCIAL DDR3L 8GB 16GB 32GB 1600 MHz PC3-12800 Laptop Memory RAM SODIMM 204-Pin

$14.35



Team T-FORCE VULCAN Z 16GB (2 x 8GB) 288-Pin PC RAM DDR4 3200 (PC4 25600) Intel picture

Team T-FORCE VULCAN Z 16GB (2 x 8GB) 288-Pin PC RAM DDR4 3200 (PC4 25600) Intel

$35.99



A-Tech 16GB 2 x 8GB PC3-12800 Laptop SODIMM DDR3 1600 Memory RAM PC3L 16G DDR3L picture

A-Tech 16GB 2 x 8GB PC3-12800 Laptop SODIMM DDR3 1600 Memory RAM PC3L 16G DDR3L

$27.98



A-Tech 16GB 2x 8GB PC3-12800 Desktop DDR3 1600 MHz 240pin DIMM Memory RAM 16G 8G picture

A-Tech 16GB 2x 8GB PC3-12800 Desktop DDR3 1600 MHz 240pin DIMM Memory RAM 16G 8G

$27.98



HMT84GL7AMR4C-RD 32GB DDR3 Server Memory RAM 14900L ECC REG 4Rx4 SK Hynix Cisco picture

HMT84GL7AMR4C-RD 32GB DDR3 Server Memory RAM 14900L ECC REG 4Rx4 SK Hynix Cisco

$13.99



A-Tech 32GB 2x 16GB PC4-25600 Laptop SODIMM DDR4 3200 MHz Non-ECC Memory RAM 32G picture

A-Tech 32GB 2x 16GB PC4-25600 Laptop SODIMM DDR4 3200 MHz Non-ECC Memory RAM 32G

$59.99



Hynix 64GB 4Rx4 PC4-2133P-L LRDIMM DDR4-17000 ECC Load Reduced Server Memory RAM picture

Hynix 64GB 4Rx4 PC4-2133P-L LRDIMM DDR4-17000 ECC Load Reduced Server Memory RAM

$64.99