-
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.
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
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
Cisco Catalyst C9300-24UX-A 24 Port 10G/mGig UPOE Network Switch, no module
$349.97
ARUBA J9772A 2530-48G PoE+ 48 PORT ETHERNET SWITCH W/ RACK EARS J9772-60301
$125.69
Cisco WS-C3750G-24PS-S Catalyst 3750G 24-Port Gigabit Ethernet Network Switch
$59.99
Fortinet FortiSwitch FS-124D-POE 24 Port Gigabit Ethernet Switch UNREGISTERED
$99.97
New Linksys SE3005 5-port Gigabit Ethernet Switch
$18.99
NETGEAR GS305300PAS 5 Port Gigabit Ethernet Unmanaged Switch
$15.99
Linksys SE3008 8 Ports Rack Mountable Gigabit Ethernet Switch
$21.99
Cudy 5-Port 10/100Mbps Fast Ethernet Desktop Unmanaged Switch | FS105D
$12.99
NetGear ProSafe GS752TP V1H1 52-Port Gigabyte PoE Ethernet Network Switch
$109.99
HPE OfficeConnect 1950 24-Port + 2SFP & 2XGT Network Switch JG960A
$69.99