TLS acesso phpmyadmin negado & banco de dados mysql não é executado

Question

Eu instalei o XAMPP no Ubuntu 16.04.1 por meio de estas instruções . Problemas são:

1. Não é possível acessar localhost/phpmyadmin .

   

2. ObancodedadosMySQLnãoseráexecutado.

3. Quando abro Configure > Abra o log do banco de dados MySQL XAMPP GUI. Aqui está o resultado.

   2016-10-16 09:54:30 8005 mysqld_safe Starting mysqld daemon with databases from /opt/lampp/var/mysql 
   2016-10-16  9:54:31 139780487444288 [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. 
   2016-10-16  9:54:31 139780487444288 [Note] /opt/lampp/sbin/mysqld (mysqld 10.1.16-MariaDB) starting as process 8152 ... 
   2016-10-16  9:54:31 139780487444288 [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.
   2016-10-16  9:54:31 139780487444288 [Note] InnoDB: Using mutexes to ref count buffer pool pages 
   2016-10-16  9:54:31 139780487444288 [Note] InnoDB: The InnoDB memory heap is disabled 
   2016-10-16  9:54:31 139780487444288 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 
   2016-10-16  9:54:31 139780487444288 [Note] InnoDB: Memory barrier is not used 
   2016-10-16  9:54:31 139780487444288 [Note] InnoDB: Compressed tables use zlib 1.2.8 
   2016-10-16  9:54:31 139780487444288 [Note] InnoDB: Using generic crc32 instructions 
   2016-10-16  9:54:31 139780487444288 [Note] InnoDB: Initializing buffer pool, size = 16.0M 
   2016-10-16  9:54:31 139780487444288 [Note] InnoDB: Completed initialization of buffer pool 
   2016-10-16  9:54:31 139780487444288 [Note] InnoDB: Highest supported file format is Barracuda. 
   2016-10-16  9:54:32 139780487444288 [Note] InnoDB: 128 rollback segment(s) are active. 
   2016-10-16  9:54:32 139780487444288 [Note] InnoDB: Waiting for purge to start 
   2016-10-16  9:54:32 139780487444288 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.30-76.3 started; log sequence number 1762733 
   2016-10-16  9:54:32 139780096513792 [Note] InnoDB: Dumping buffer pool(s) not yet started 
   2016-10-16  9:54:32 139780487444288 [Note] Plugin 'FEEDBACK' is disabled. 
   2016-10-16  9:54:32 139780487444288 [Note] Server socket created on IP: '::'. 
   2016-10-16  9:54:32 139780487444288 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 98: Address already in use 
   2016-10-16  9:54:32 139780487444288 [ERROR] Do you already have another mysqld server running on port: 3306 ? 
   2016-10-16  9:54:32 139780487444288 [ERROR] Aborting
   2016-10-16 09:54:34 8005 mysqld_safe mysqld from pid file /opt/lampp/var/mysql/laptop.pid ended 
   2016-10-16 10:04:30 9155 mysqld_safe Starting mysqld daemon with databases from /opt/lampp/var/mysql 
   2016-10-16 10:04:30 140396037838656 [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. 
   2016-10-16 10:04:30 140396037838656 [Note] /opt/lampp/sbin/mysqld (mysqld 10.1.16-MariaDB) starting as process 9299 ... 
   2016-10-16 10:04:30 140396037838656 [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.
   2016-10-16 10:04:30 140396037838656 [Note] InnoDB: Using mutexes to ref count buffer pool pages 
   2016-10-16 10:04:30 140396037838656 [Note] InnoDB: The InnoDB memory heap is disabled 
   2016-10-16 10:04:30 140396037838656 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 
   2016-10-16 10:04:30 140396037838656 [Note] InnoDB: Memory barrier is not used 
   2016-10-16 10:04:30 140396037838656 [Note] InnoDB: Compressed tables use zlib 1.2.8 
   2016-10-16 10:04:30 140396037838656 [Note] InnoDB: Using generic crc32 instructions 
   2016-10-16 10:04:30 140396037838656 [Note] InnoDB: Initializing buffer pool, size = 16.0M 
   2016-10-16 10:04:30 140396037838656 [Note] InnoDB: Completed initialization of buffer pool 
   2016-10-16 10:04:30 140396037838656 [Note] InnoDB: Highest supported file format is Barracuda. 
   2016-10-16 10:04:30 140396037838656 [Note] InnoDB: 128 rollback segment(s) are active. 
   2016-10-16 10:04:30 140396037838656 [Note] InnoDB: Waiting for purge to start 
   2016-10-16 10:04:30 140396037838656 [Note] InnoDB:  Percona XtraDB (http://www dot percona dot com) 5.6.30-76.3 started; log sequence number 1762743 
   2016-10-16 10:04:30 140395652552448 [Note] InnoDB: Dumping buffer pool(s) not yet started 
   2016-10-16 10:04:30 140396037838656 [Note] Plugin 'FEEDBACK' is disabled. 
   2016-10-16 10:04:30 140396037838656 [Note] Server socket created on IP: '::'. 
   2016-10-16 10:04:30 140396037838656 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 98: Address already in use 
   2016-10-16 10:04:30 140396037838656 [ERROR] Do you already have another mysqld server running on port: 3306 ? 
   2016-10-16 10:04:30 140396037838656 [ERROR] Aborting
   2016-10-16 10:04:32 9155 mysqld_safe mysqld from pid file /opt/lampp/var/mysql/laptop.pid ended
   

Alguém pode me ajudar com isso?

UPDATE

Embora na GUI do XAMPP o mysql não funcione, quando eu o executo no terminal ele funciona. Então eu não sei em qual deles eu deveria acreditar.

$ sudo /opt/lampp/xampp start
Starting XAMPP for Linux 7.0.9-1...
XAMPP: Starting Apache...already running. 
XAMPP: Starting MySQL...ok.
XAMPP: Starting ProFTPD...ok.

XAMPP reinstalado:

O banco de dados MySQL está em execução, Servidor Web Apache Interrompido.

Starting XAMPP for Linux 7.0.9-1...    
XAMPP: Starting Apache...fail.    
XAMPP:  Another web server is already running.    
XAMPP: Starting MySQL...already running.    
XAMPP: Starting ProFTPD...fail.    
XAMPP:  Another FTP daemon is already running.

    

Answer 1

Eu tive esse problema uma vez quando eu estava usando o Linux mint 19, eu fiz uma pesquisa no google sobre isso, mas nunca realmente entendi qual é a causa desse problema, mesmo depois que eu soube da solução.

Depois de algum tempo, percebi que existe algo chamado Unit mysql.service em conflito com o meu próprio banco de dados MySQL.

Como resolver isso?

Eu posso notar que você está rodando o Ubuntu, então os diretórios de instalação do XAMPP, MySQL ... devem ser os mesmos abaixo:

• Instale o XAMPP corretamente.
• Abra o terminal e digite o comando sudo /opt/lampp/lampp start para executar os serviços do XAMPP.
• Abra uma nova janela de terminal e digite este comando: sudo service mysql stop .
• Reinicie os serviços do XAMPP: sudo /opt/lampp/lampp restart .

Agora você pode acessar o phpMyAdmin via browser, e o seu monitor de banco de dados via Terminal.

% bl0ck_qu0te%     

Answer 2

etapa 1: abra o arquivo /opt/lampp/etc/my.cnf
etapa 2: adicionar código innodb_force_recovery = 1
passo 3: reinicie ou inicie o MySql.