mysql_connect

phaksp · Post by **phaksp** » Sat Dec 24, 2005 6:01 am

hi, i'm getting this error message, got any idea on how to fix it ?
Do i just have to restart the configuration process of zm ?

Warning: mysql_connect(): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) in /home/netbijoux/zm-1.21.3/web/zm_db.php on line 21
Could not connect to database: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

Post by **cordel** » Sat Dec 24, 2005 8:02 am

Did you make sure that mysql is started?

Regards,
Corey

phaksp · Post by **phaksp** » Fri Dec 30, 2005 4:29 am

user@host:/root$ /usr/sbin/mysqld
051229 14:11:02 [Warning] Can't create test file /var/lib/mysql/netbijoux.lower-test
051229 14:11:02 [Warning] One can only use the --user switch if running as root

/usr/sbin/mysqld: File '/var/log/mysql/mysql-bin.1' not found (Errcode: 13)
051229 14:11:02 [ERROR] Could not use /var/log/mysql/mysql-bin for logging (error 13). Turning logging off for the whole duration of the MySQL server process. To turn it on again: fix the cause, shutdown the MySQL server and restart it.
051229 14:11:02 [ERROR] Aborting

051229 14:11:02 [Note] /usr/sbin/mysqld: Shutdown complete

so... yes, it's not started and it doesn't want to

phaksp · Post by **phaksp** » Mon Jan 02, 2006 4:21 pm

ok, i'm trying with mysql 4.0.25

after unpacking i launch that mysqld it's give me :

host:~# /usr/bin/mysqldumpslow
/usr/share/man/man1/mysqldumpslow.1.gz
Can't find '/var/lib/mysql/*-slow.log'
host:~# /usr/sbin/mysqld
060102 12:53:21 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
060102 12:53:21 InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 44812.
InnoDB: Doing recovery: scanned up to log sequence number 0 44858
InnoDB: Last MySQL binlog file position 0 79, file name /var/log/mysql/mysql-bin .000099
060102 12:53:21 InnoDB: Flushing modified pages from the buffer pool...
060102 12:53:21 InnoDB: Started; log sequence number 0 44858
060102 12:53:21 [ERROR] Fatal error: Can't open and lock privilege tables: Table './mysql/user' was created with a different version of MySQL and cannot be read

phaksp · Post by **phaksp** » Fri Jan 13, 2006 2:45 pm

i heard they are some tools to convert DB from a version of mysql to another.