Page 1 of 2 12 LastLast
Results 1 to 10 of 18

Thread: MySQL

  1. #1
    Junior Member registered user
    Join Date
    Jul 2003
    Location
    Belgium
    Posts
    16

    MySQL

    Am not able to start the DVD MySQL. Getting following messages:
    QUOTE
    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!
    UNQUOTE
    And indeed : ther is no '/var/run/mysqld/mysqld.sock'
    Do not experience the same problem with hte "2003/07/26" CD.

    Any help or hint?

    Thank you!

    Georges.

  2. #2
    Member registered user
    Join Date
    Jul 2003
    Location
    Delft, the Netherlands
    Posts
    76
    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

  3. #3
    Junior Member registered user
    Join Date
    Apr 2003
    Location
    Santa Barbara, CA
    Posts
    24

    starting mysqld

    if MySQL does not start automatically you can usually start it with a script in /etc/init.d/ look in that folder for mysql or mysqld. If either is there, su to root and type: /etc/init.d/mysql start or /etc/init.d/mysqld start depending on which file you found, this should start mysql server and allow you to connect.

  4. #4
    Junior Member registered user
    Join Date
    Jul 2003
    Location
    Belgium
    Posts
    16
    Thank you for prompt reaction.

    The problem is the DVD! With the 2003.06.06 and 2003-07-26 CD's I can start MySQL.

    I start MySQL manually in a konsole : sudo /etc/init.d/mysql start
    With the 2003-07-10 DVD the error messages I quoted appear in the error-file : "/var/log/mysql/mysql.err "

    Another question : can you add another user (not 'root') with MySQL under Knoppix? I was unable to do so.

    By the way : what means ' HTH'? Apologizing for my ignorance ...

    Thanks beforehand for more hints and help on MySQL - Knoppix.

    Dank!

    Regards,

    Georges.

  5. #5
    Member registered user
    Join Date
    Jul 2003
    Location
    Delft, the Netherlands
    Posts
    76
    Quote Originally Posted by mzee
    I start MySQL manually in a konsole : sudo /etc/init.d/mysql start
    With the 2003-07-10 DVD the error messages I quoted appear in the error-file : "/var/log/mysql/mysql.err "
    Odd. I tried this command on a 20030726 CD boot. No errors in the console, but the error-log showed:

    Code:
    030805 13:00:35  Error at /etc/init.d/mysql\n/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!
    030805 13:00:35  mysqld started
    Warning: Ignoring user change to 'mysql' because the user was set to 'mysql' earlier on the command line
    /usr/sbin/mysqld: ready for connections.
    Version: '4.0.13-log'  socket: '/var/run/mysqld/mysqld.sock'  port: 0
    As you can see the same errors, but MySql is started. Maybe this command is not the right way to start the server (the man page does not list the 'start' command). I always use 'sudo mysqld' (full path: /usr/sbin/mysqld). Try that and see if it helps.

    Quote Originally Posted by mzee
    Another question : can you add another user (not 'root') with MySQL under Knoppix? I was unable to do so.
    It did work for me with 'mysqladmin'. Check the permissions on the databasefiles in /var/lib/mysql/mysql.

    Hope This Helps (HTH)

    - - Edwin

  6. #6
    Junior Member registered user
    Join Date
    Jul 2003
    Location
    Belgium
    Posts
    16
    Indeed, very odd. With the 20030726 CD and the 20020606 CD I get the same errorfile and MySQL starts. Whereas with the DVD I get the same errorfile but MySQL does not start.

    According to my info : 'sudo /etc/init.d/mysql start' is the right way to start.
    I also tried your : /usr/sbin/mysqld. With the follwing error :
    QUOTE
    Warning: Ignoring user change to 'mysql' because the user was set to 'mysql' earlier on the command line
    030805 18:55:27 Fatal error: Can't open privilege tables: Incorrect information in file: './mysql/host.frm'
    030805 18:55:27 Aborting
    UNQUOTE

    Dank.

    Regards,

    Georges.

  7. #7
    Member registered user
    Join Date
    Jul 2003
    Location
    Delft, the Netherlands
    Posts
    76
    Code:
     
    030805 18:55:27  Fatal error: Can't open privilege tables: Incorrect information in file: './mysql/host.frm'
    030805 18:55:27  Aborting
    So you have a corrupt table. The file host.frm holds the description (format) for the mysql.host table. This table is used to stores the privileges at the host level.

    Worth a shot: copy the three files which make up this table from a CD version to /var/lib/mysql/mysql in the DVD-version and set the permissions to rwx for everyone. The table is empty so it fits on a floppy easily. See what happens. Use the 'mysqld' command as it seems to give some usefull information.

    Succes

    - - Edwin

  8. #8
    Senior Member registered user
    Join Date
    Apr 2003
    Location
    Iowa U.S.A.
    Posts
    226
    Hi mzee,
    Hi All,

    I have the original test DVD which is likely the same
    as the Linux Tag version.

    I run the DVD - not installed - and it apears to work.
    Yes, I get the same entry in /mysql.err
    but

    mysql
    and enter gives the prompt
    mysql>
    and
    mysql> SELECT VERSION();
    responds wth a table showing 4.0.13-log

    Did you do a hard drive install, are you working
    from the DVD, or from the DVD image copied to a hard drive?

    Best Wishes
    paradocs

  9. #9
    Junior Member registered user
    Join Date
    Jul 2003
    Location
    Belgium
    Posts
    16
    Thank you for kind reactions.

    Edwin, followed your advice and tried to copy the 'host.*'-files. But since I am working from the DVD got following message:
    '
    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
    '
    Tried also a symbolic link : to no avail ...
    sudo ln -s ./sql/host.frm /var/lib/mysql/mysql/host.frm

    As for Paradocs, tried to enter mysql but :
    '
    ERROR 2002: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
    '

    Anyway, thank your for kind attention,

    Regards,

    Georges.

  10. #10
    Member registered user
    Join Date
    Jul 2003
    Location
    Delft, the Netherlands
    Posts
    76
    This is getting odder by the day. You might be right there is something wrong with your DVD. Here is what I did: I made a simple text file and put it on a floppy as 'host.frm' Then I booted a 20030726 CD. Opened a shell and:

    Code:
    knoppix@ttyp0[knoppix]$ sudo cp -f /mnt/floppy/host.frm /var/lib/mysql/mysql
    knoppix@ttyp0[knoppix]$ ls /var/lib/mysql/mysql | grep host
    host.MYD
    host.MYI
    host.frm
    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]$
    In other words: operation succeeded. As it should have for the /var directory is stored on a RAM-disk. It holds the databases, so one should be able to write to it.

    But here is the funny part. I rebooted in a root-account (there is a handy tip on the Tips forum on how to do that). Opened a shell and:

    Code:
    root@0[root]# cp -f /mnt/floppy/host.frm /var/lib/mysql/mysql
    cp: overwrite `/var/lib/mysql/mysql/host.frm', overriding mode 0660? y
    cp: skipping file `/mnt/floppy/host.frm', as it was replaced while being copied
    root@0[root]# cat /var/lib/mysql/mysql/host.frm
    The output from the last command clearly showed that the copy had failed. Good, not the same error as you had, but getting close. So next I did:

    Code:
    root@0[root]# mv /var/lib/mysql/mysql/host.frm /var/lib/mysql/mysql/host.frm.old
    root@0[root]# cp /mnt/floppy/host.frm /var/lib/mysql/mysql
    root@0[root]# ls /var/lib/mysql/mysql | grep host
    host.MYD
    host.MYI
    host.frm
    host.frm.old
    root@0[root]# cat /var/lib/mysql/mysql/host.frm
    This is a test file
    This is not a MySql-table-description file
    root@0[root]#
    So first renaming and then copying works here. You might want to give this a try, as Knoppix (using sudo) or as root. Apart from that I am out of options.

    Maybe the gentleman offering DVD's in this forum can shed some light?

    Regards,

    - - Edwin

Page 1 of 2 12 LastLast

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
  •