Mysql: erreur port 3306 (sous solaris)
Bonjour,
je ne peux pas démarrer mysql sous solaris
avec cette commande:
dans le fichier /usr/local/mysql/var/nom_du_server.err
je trouve ces erreurs:
je ne sais pas comment faire
merci de m'aider
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
1 réponse
-
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-
Merci de votre réponse
1)
pour la commande netstat -ntlp :
# netstat -ntlp
netstat: illegal option -- t
usage: netstat [-anv] [-f address_family]
netstat [-n] [-f address_family] [-P protocol] [-g | -p | -s [interval [count]]]
netstat -m [-v] [interval [count]]
netstat -i [-I interface] [-an] [-f address_family] [interval [count]]
netstat -r [-anv] [-f address_family|filter]
netstat -M [-ns] [-f address_family]
netstat -D [-I interface] [-f address_family]
je choisi quel option?
2)
# /etc/init.d/mysql restart
/etc/init.d/mysql: introuvable
merci -
Ah mon dieu solaris... ce ne sont pas les mêmes options :-( Et pas de script pour le lancer... Tente un :
netstat -n | grep 3306 ps aux | grep mysql
Le but est de vérifier si tu n'as pas déjà un serveur mysql qui tourne et qui occupe le port 3306.
Bon voilà déjà pour l'installation :
https://dev.mysql.com/doc/refman/8.0/en/solaris-installation.html
Pour le lancer
https://dev.mysql.com/doc/refman/8.0/en/mysqld-safe.html
Bonne chance -
-
Toujours la même erreur ? Que donne :
netstat -n | grep 3306
Si le port 330- semble déjà occupé, essaye d'utiliser un autre port en corrigeant /etc/mysql/my.cnf pour voir si ça vient de là (mets 3307 par exemple).
Bonne chance
-
