On Friday 28 Jan 2011 14:24:45 Per Jessen wrote:
Bob Williams wrote:
My problem is getting the server to start. The reset password instructions say to stop the server by ...
--quote-- Locate the .pid file that contains the server's process ID. The exact location and name of this file depend on your distribution, host name, and configuration. Common locations are /var/lib/mysql/, /var/run/mysqld/, and /usr/local/mysql/data/. Generally, the file name has an extension of .pid and begins with either mysqld or your system's host name.
You can stop the MySQL server by sending a normal kill (not kill -9) to the mysqld process, using the path name of the .pid file in the following command:
shell> kill `cat /mysql-data-directory/host_name.pid` --end quote--
I found the pid in /var/lib/mysql/localhost.pid
Hi Bob,
hmm, I would have expected to find it in:
/var/run/mysql/mysqld.pid
but if I try to restart the server (as root), I get
barrowhillfarm:~ # /etc/init.d/mysql start Starting service MySQL warning: /var/run/mysql/mysql.sock didn't appear within 30 seconds
Check the mysqld log file - probably in /var/log/mysql/mysqld.log or /var/lib/mysql/mysqld.log
I would guess something isn't quite right in /etc/my.cnf
You're quite right. It didn't like the load-infile option (unknown) so it kept aborting. OK, I'm only going to be creating small databases, so I can insert each record one by one. However, after removing the offending line from /etc/my.cnf, I still can't start the server. The last few lines of the mysqld.log say ... 110128 14:51:30 [ERROR] Plugin 'InnoDB' init function returned error. 110128 14:51:30 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 110128 14:51:30 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use 110128 14:51:30 [ERROR] Do you already have another mysqld server running on port: 3306 ? 110128 14:51:30 [ERROR] Aborting 110128 14:51:30 [Note] /usr/sbin/mysqld: Shutdown complete 110128 14:51:30 mysqld_safe mysqld from pid file /var/run/mysql/mysqld.pid ended but I can't see that there's another server instance running. If there was, I should be able to use it? Bob -- Registered Linux User #463880 FSFE Member #1300 GPG-FP: A6C1 457C 6DBA B13E 5524 F703 D12A FB79 926B 994E openSUSE 11.3 64-bit, Kernel 2.6.36.90-desktop, KDE 4.5.3 Intel Core2 Quad Q9400 2.66GHz, 8GB DDR RAM, nVidia GeForce 9600GT -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org