Mysql: erreur port 3306 (sous solaris) Fermé

Question

Bonjour, 

je ne peux pas démarrer mysql sous solaris
avec cette commande:

cd /usr/local/mysql ; /usr/local/mysql/bin/mysqld_safe &

dans le fichier /usr/local/mysql/var/nom_du_server.err
je trouve ces erreurs:

101029 10:12:53  mysqld started
101029 10:12:53 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
101029 10:12:53 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
101029 10:12:53 [Warning] option 'thread_stack': unsigned value 65536 adjusted to 131072
InnoDB: Unable to lock /usr/local/mysql/var/ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
101029 10:12:53  InnoDB: Retrying to lock the first data file
InnoDB: Unable to lock /usr/local/mysql/var/ibdata1, error: 11
B: Unable to lock /usr/local/mysql/var/ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock /usr/local/mysql/var/ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock /usr/local/mysql/var/ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock /usr/local/mysql/var/ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: Unable to lock /usr/local/mysql/var/ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock /usr/local/mysql/var/ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
101029 10:14:51  InnoDB: Unable to open the first data file
InnoDB: Error in opening /usr/local/mysql/var/ibdata1
101029 10:14:51  InnoDB: Operating system error number 11 in a file operation.
InnoDB: Error number 11 means 'Resource temporarily unavailable'.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/refman/5.0/en/operating-system-error-codes.html
InnoDB: Could not open or create data files.
InnoDB: If you tried to add new data files, and it failed here,
InnoDB: you should now edit innodb_data_file_path in my.cnf back
InnoDB: to what it was, and remove the new ibdata files InnoDB created
InnoDB: in this failed attempt. InnoDB only wrote those files full of
InnoDB: zeros, but did not yet use them in any way. But be careful: do not
InnoDB: remove old data files which contain your precious data!
101029 10:14:51 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use
101029 10:14:51 [ERROR] Do you already have another mysqld server running on port: 3306 ?
101029 10:14:51 [ERROR] Aborting

101029 10:14:51 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete

101029 10:14:51  mysqld ended



je ne sais pas comment faire
merci de m'aider


Configuration: Windows XP / Firefox 3.6.10

mamiemando · Answer

Peux-tu nous donner le résultat de la commande : 

netstat -ntlp

Par ailleurs, si c'est comme sous linux, n'as-tu pas un script shell dans /etc/init.d qui te permettrait de l'instancier plus facilement ? 

/etc/init.d/mysql restart

Bonne chance

Mysql: erreur port 3306 (sous solaris)

1 réponse

Discussions similaires