#1 Le 10/07/2017, à 23:20
- LeDebutant31
[Résolu] Xampp mysql ne demarre pas !
Bonsoir, je poste ce message car je n'arrive plus a utilise mysql de xampp. J'ai une erreur a chaque lancement
Toute les manipulations son faite en root !
/opt/lampp/lampp start
Starting XAMPP for Linux 5.6.30-0...
XAMPP: Starting Apache...already running.
XAMPP: Starting MySQL...ok.
XAMPP: Starting ProFTPD...already running.
┌ root@ledebutant - dir:~ 22:57:30 - READY
└ $ /opt/lampp/bin/mysqld_safe_helper: Can't create/write to file '/opt/lampp/var/mysql/ledebutant.err' (Errcode: 13 "Permission denied")Vue que il y avais une "Permission denied" j'ai chmod le fichier en '777' et l'erreur a disparue, mais mysql ne ce lancer toujours pas.
J'ai vue sur le net que on pouvais lancer mysql via mysql.server qui ce trouve dans le dossier '/opt/lampp/bin'
./mysql.server start
Starting MySQL
.2017-07-10 23:11:19 7137 mysqld_safe Logging to '/opt/lampp/var/mysql/ledebutant.err'.
2017-07-10 23:11:19 7137 mysqld_safe Starting mysqld daemon with databases from /opt/lampp/var/mysql
* Le contenue de '/opt/lampp/var/mysql/ledebutant.err'.
2017-07-10 23:11:19 7137 mysqld_safe Starting mysqld daemon with databases from /opt/lampp/var/mysql
2017-07-10 23:11:20 140144872340352 [Note] Using unique option prefix 'key_buffer' is error-prone and can break in the future. Please use the full name 'key_buffer_size' instead.
2017-07-10 23:11:20 140144872340352 [Note] /opt/lampp/sbin/mysqld (mysqld 10.1.21-MariaDB) starting as process 7279 ...
2017-07-10 23:11:20 140144872340352 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.
2017-07-10 23:11:20 140144872340352 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2017-07-10 23:11:20 140144872340352 [Note] InnoDB: The InnoDB memory heap is disabled
2017-07-10 23:11:20 140144872340352 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-07-10 23:11:20 140144872340352 [Note] InnoDB: GCC builtin __sync_synchronize() is used for memory barrier
2017-07-10 23:11:20 140144872340352 [Note] InnoDB: Compressed tables use zlib 1.2.8
2017-07-10 23:11:20 140144872340352 [Note] InnoDB: Using SSE crc32 instructions
2017-07-10 23:11:20 140144872340352 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2017-07-10 23:11:20 140144872340352 [Note] InnoDB: Completed initialization of buffer pool
2017-07-10 23:11:20 140144872340352 [ERROR] InnoDB: /opt/lampp/var/mysql/ibdata1 can't be opened in read-write mode
2017-07-10 23:11:20 140144872340352 [ERROR] InnoDB: The system tablespace must be writable!
2017-07-10 23:11:20 140144872340352 [ERROR] Plugin 'InnoDB' init function returned error.
2017-07-10 23:11:20 140144872340352 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2017-07-10 23:11:20 140144872340352 [ERROR] mysqld: File '/opt/lampp/var/mysql/aria_log_control' not found (Errcode: 13 "Permission denied")
2017-07-10 23:11:20 140144872340352 [ERROR] mysqld: Got error 'Can't open file' when trying to use aria control file '/opt/lampp/var/mysql/aria_log_control'
2017-07-10 23:11:20 140144872340352 [ERROR] Plugin 'Aria' init function returned error.
2017-07-10 23:11:20 140144872340352 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2017-07-10 23:11:20 140144872340352 [Note] Plugin 'FEEDBACK' is disabled.
2017-07-10 23:11:20 140144872340352 [ERROR] Unknown/unsupported storage engine: InnoDB
2017-07-10 23:11:20 140144872340352 [ERROR] Aborting
2017-07-10 23:11:20 7137 mysqld_safe mysqld from pid file /opt/lampp/var/mysql/ledebutant.pid endedAu final malgré tout mais tentative rien n'y fait .... Je vous demande donc de l'aide 
.
Merci
Dernière modification par LeDebutant31 (Le 11/07/2017, à 23:53)
Hors ligne
#3 Le 11/07/2017, à 23:53
- LeDebutant31
Re : [Résolu] Xampp mysql ne demarre pas !
J'ai fait sa grigouille, j'ai juste pris le temps de récupérer mais base de donnée ensuite j'ai migrer vers lamp. Je mais le sujet en Résolu.
Hors ligne