MY SQL Errors on 4.0.2

[pau1knopp]

I am not able to start mysql using

/etc/init.d/mysql start

I get errors saying that /usr/bin/mysqladmin cannot connect to localhost and that "can't connect to local mysql server through socket /var/run/mysqld/mysqld.sock"

the old lamp server floppy (knoppix-webserver-setup.zip) no longer seems to work.

I have a work project that needs mysql.

any advise greatly appreciated.

paul[/img]

[pau1knopp]

here's the fix:

Using mySQL with Knoppix 4.0.2

As root edit /etc/mysql/my.cnf

Comment out the line old_passwords = 1

#old_passwords = 1

You can now use

/etc/init.d/mysql start
and
/etc/init.d/mysql stop

to control the service.

To start the client open a new shell and type

mysql

You should see the sql prompt

mysql>

[chiasc]

I am facing similar problem with knoppix 4.01 hd installed.Not only that,
the localhost cannot be reached by typing http://localhost and networking configure tool
hang-up after clicking <apply> to finish configure my ethernet ip.
A lot of tweaking/manual works have to be done with httpd.conf ,modules.conf and interfaces files,and restart again.
Is there anyway to automate apache and mysql at start-up?
Generally,as a newbie,I found that knoppix is not user friendly as compare to mandrake or
even fedora.

thank you.
chiasc.

[pau1knopp]

you should start a new thread if you want effective help with other issues that the topic posted (just a suggestion, do as you will)

i run 4.0.2 from cd, but its the same for hd install

to start the apache web server, i run (as root)

/etc/init.d/apache start

you can then open http://localhost in your browser

not sure about your network card hang up. try configuring using ifconfig and route from the command line. tough if you claim to be a newbie, but a worthwhile learning exercise and will most likely be a workaround to netcardconfig (IMHO).

to automate things, i create a script that does ALL my manual tasks (stopping and starting services, creating symlinks, etc). I keep that on a hd partition or thumbdrive and run it when I start. i have heard you can edit the knoppix .sh startup file, but I prefer to do it this way.

i also have not found knoppix as user friendly as mandrake or fedora. that's why i switched... i didn't want a friend, i wanted an embedded operating system

hope this info is helpful.