MySQL

[mzee]

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.

[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

[kaplanfx]

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.

[mzee]

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.

[Edwin]

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:

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.

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

[mzee]

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.

[Edwin]

 
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

[paradocs]

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

[mzee]

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.

[Edwin]

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:

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:

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:

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