-
Senior Member
registered user
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
The shell will hang up but that is expected. Leave it open.
Now open a new shell and type
You should see
Best Wishes
paradocs
-
Junior Member
registered user
Originally Posted by
paradocs
Thy this method:
Open one shell and type
The shell will hang up but that is expected. Leave it open.
Now open a new shell and type
You should see
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.
-
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
-
Junior Member
registered user
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.
-
ERROR MYSQL EN UBUNTU
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
-
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
-
You have to edit /etc/mysql/my.cnf
Uncomment the line with: old_passwords = 1
-
thx
Hi Impf,
Thank you very much; now it works
Wolfixx
Similar Threads
-
By dr_rude in forum General Support
Replies: 2
Last Post: 10-11-2004, 02:37 AM
-
By sniker in forum Hdd Install / Debian / Apt
Replies: 2
Last Post: 10-08-2004, 03:50 AM
-
By Coume in forum General Support
Replies: 5
Last Post: 08-06-2003, 06:42 AM
-
By Coume in forum Hdd Install / Debian / Apt
Replies: 3
Last Post: 08-04-2003, 07:00 AM
-
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
-
Forum Rules
Crucial 8GB 1x8GB PC RAM PC3L 12800U DDR3 1600MHz Desktop Memory DIMM
$8.36
Crucial 8GB SO-DIMM PC3-12800 (DDR3-1600) Memory
$9.49
A-Tech 8GB DDR3 1600 PC3-12800 Laptop SODIMM 204-Pin Memory RAM PC3L DDR3L 1x 8G
$13.99
Micron 16GB DDR4-2400 SODIMM MTA16ATF2G64HZ-2G3E1 Laptop Memory RAM
$21.99
Crucial DDR3L 16GB 1600 2x 8GB PC3-12800 Laptop SODIMM Memory RAM PC3 16G DDR3
$22.45
G.Skill Ripjaws V 2 x 16GB DDR4-3200 PC4-25600 CL16 Dual Channel Desktop Memory
$49.99
1 x 16GB SK Hynix PC4-2666V DDR4 ECC REG Server Memory HMA82GR7CJR8N-VK (SK4
$15.80
Team T-FORCE VULCAN Z 32GB (2 x 16GB) PC RAM DDR4 3200 (PC4 25600) Memory
$54.99
Samsung M393A8G40AB2-CWE 64GB 2Rx4 PC4-25600 ECC Registered Server Memory RAM
$134.99
A-Tech 64GB 2x 32GB 2Rx4 PC4-23400R DDR4 2933MHz ECC REG RDIMM Server Memory RAM
$109.98