Avec la configuration par défaut de MariaDB sous Debian tu devrais
pouvoir te connecter de la façon suivante:
sudo mysql -u root
Est-ce que cela fonctionne ?
Si oui tu peux essayer ensuite de changer le mot de passer de tes
utilisateurs, par exemple:
SET PASSWORD FOR 'zuthos'@'localhost' = PASSWORD('newpass');
Paul
Le 01/03/2019 à 05:49, Zuthos a écrit :
On pourrait avoir les messages d'erreur lorsque tu essayes de redémarrer
MySQL ou un extrait des logs ?
Voici le message losque j'essaye de me connectyer a roundcube:
DATABASE ERROR: CONNECTION FAILED!
Unable to connect to the database!
Please contact your server-administrator.
Avec phpmyadmin:
mysqli_real_connect(): (HY000/1698): Access denied for user
'zuthos'@'localhost'
#1698 - Access denied for user 'zuthos'@'localhost'
Je ne sais pas ou regarder ailleur
le fichier de log:
2019-03-01 14:16:41 140382442050688 [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.
2019-03-01 14:16:42 140382442050688 [Note] InnoDB: Using mutexes to ref count
buffer pool pages
2019-03-01 14:16:42 140382442050688 [Note] InnoDB: The InnoDB memory heap is
disabled
2019-03-01 14:16:42 140382442050688 [Note] InnoDB: Mutexes and rw_locks use GCC
atomic builtins
2019-03-01 14:16:42 140382442050688 [Note] InnoDB: GCC builtin
__atomic_thread_fence() is used for memory barrier
2019-03-01 14:16:42 140382442050688 [Note] InnoDB: Compressed tables use zlib
1.2.8
2019-03-01 14:16:42 140382442050688 [Note] InnoDB: Using Linux native AIO
2019-03-01 14:16:42 140382442050688 [Note] InnoDB: Using SSE crc32 instructions
2019-03-01 14:16:42 140382442050688 [Note] InnoDB: Initializing buffer pool,
size = 128.0M
2019-03-01 14:16:42 140382442050688 [Note] InnoDB: Completed initialization of
buffer pool
2019-03-01 14:16:42 140382442050688 [Note] InnoDB: Highest supported file
format is Barracuda.
2019-03-01 14:16:42 140382442050688 [Note] InnoDB: The log sequence number
1616737 in ibdata file do not match the log sequence number 1616777 in the
ib_logfiles!
2019-03-01 14:16:42 140382442050688 [Note] InnoDB: Restoring possible
half-written data pages from the doublewrite buffer...
2019-03-01 14:16:43 140382442050688 [Note] InnoDB: 128 rollback segment(s) are
active.
2019-03-01 14:16:43 140382442050688 [Note] InnoDB: Waiting for purge to start
2019-03-01 14:16:43 140382442050688 [Note] InnoDB: Percona XtraDB
(http://www.percona.com) 5.6.41-84.1 started; log sequence number 1616777
2019-03-01 14:16:43 140382442050688 [Note] Plugin 'FEEDBACK' is disabled.
2019-03-01 14:16:43 140381807179520 [Note] InnoDB: Dumping buffer pool(s) not
yet started
2019-03-01 14:16:43 140382442050688 [Note] Recovering after a crash using tc.log
2019-03-01 14:16:43 140382442050688 [Note] Starting crash recovery...
2019-03-01 14:16:43 140382442050688 [Note] Crash recovery finished.
2019-03-01 14:16:43 140382442050688 [Note] Server socket created on IP:
'127.0.0.1'.
2019-03-01 14:16:44 140382442050688 [Note] /usr/sbin/mysqld: ready for
connections.
Version: '10.1.37-MariaDB-0+deb9u1' socket: '/var/run/mysqld/mysqld.sock'
port: 3306 Debian 9.6
2019-03-01 14:32:26 140382441264896 [Note] /usr/sbin/mysqld: Normal shutdown
2019-03-01 14:32:26 140382441264896 [Note] Event Scheduler: Purging the queue.
0 events
2019-03-01 14:32:26 140381874267904 [Note] InnoDB: FTS optimize thread exiting.
2019-03-01 14:32:26 140382441264896 [Note] InnoDB: Starting shutdown...
2019-03-01 14:32:27 140382441264896 [Note] InnoDB: Waiting for page_cleaner to
finish flushing of buffer pool
2019-03-01 14:32:28 140382441264896 [Note] InnoDB: Shutdown completed; log
sequence number 1616787
2019-03-01 14:32:28 140382441264896 [Note] /usr/sbin/mysqld: Shutdown complete
2019-03-01 14:32:29 140231966717056 [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.
2019-03-01 14:32:29 140231966717056 [Note] InnoDB: Using mutexes to ref count
buffer pool pages
2019-03-01 14:32:29 140231966717056 [Note] InnoDB: The InnoDB memory heap is
disabled
2019-03-01 14:32:29 140231966717056 [Note] InnoDB: Mutexes and rw_locks use GCC
atomic builtins
2019-03-01 14:32:29 140231966717056 [Note] InnoDB: GCC builtin
__atomic_thread_fence() is used for memory barrier
2019-03-01 14:32:29 140231966717056 [Note] InnoDB: Compressed tables use zlib
1.2.8
2019-03-01 14:32:29 140231966717056 [Note] InnoDB: Using Linux native AIO
2019-03-01 14:32:29 140231966717056 [Note] InnoDB: Using SSE crc32 instructions
2019-03-01 14:32:29 140231966717056 [Note] InnoDB: Initializing buffer pool,
size = 128.0M
2019-03-01 14:32:29 140231966717056 [Note] InnoDB: Completed initialization of
buffer pool
2019-03-01 14:32:29 140231966717056 [Note] InnoDB: Highest supported file
format is Barracuda.
2019-03-01 14:32:29 140231966717056 [Note] InnoDB: 128 rollback segment(s) are
active.
2019-03-01 14:32:29 140231966717056 [Note] InnoDB: Waiting for purge to start
2019-03-01 14:32:29 140231966717056 [Note] InnoDB: Percona XtraDB
(http://www.percona.com) 5.6.41-84.1 started; log sequence number 1616787
2019-03-01 14:32:29 140231966717056 [Note] Plugin 'FEEDBACK' is disabled.
2019-03-01 14:32:29 140231349106432 [Note] InnoDB: Dumping buffer pool(s) not
yet started
2019-03-01 14:32:29 140231966717056 [Note] Server socket created on IP:
'127.0.0.1'.
2019-03-01 14:32:29 140231966717056 [Note] /usr/sbin/mysqld: ready for
connections.
Version: '10.1.37-MariaDB-0+deb9u1' socket: '/var/run/mysqld/mysqld.sock'
port: 3306 Debian 9.6
2019-03-01 14:42:38 140231932110592 [Note] /usr/sbin/mysqld: Normal shutdown
2019-03-01 14:42:38 140231412012800 [Note] InnoDB: FTS optimize thread exiting.
2019-03-01 14:42:38 140231932110592 [Note] InnoDB: Starting shutdown...
2019-03-01 14:42:39 140231932110592 [Note] InnoDB: Waiting for page_cleaner to
finish flushing of buffer pool
2019-03-01 14:42:41 140231932110592 [Note] InnoDB: Shutdown completed; log
sequence number 1616797
2019-03-01 14:42:41 140231932110592 [Note] /usr/sbin/mysqld: Shutdown complete
2019-03-01 14:42:42 139992997708928 [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.
2019-03-01 14:42:42 139992997708928 [Note] InnoDB: Using mutexes to ref count
buffer pool pages
2019-03-01 14:42:42 139992997708928 [Note] InnoDB: The InnoDB memory heap is
disabled
2019-03-01 14:42:42 139992997708928 [Note] InnoDB: Mutexes and rw_locks use GCC
atomic builtins
2019-03-01 14:42:42 139992997708928 [Note] InnoDB: GCC builtin
__atomic_thread_fence() is used for memory barrier
2019-03-01 14:42:42 139992997708928 [Note] InnoDB: Compressed tables use zlib
1.2.8
2019-03-01 14:42:42 139992997708928 [Note] InnoDB: Using Linux native AIO
2019-03-01 14:42:42 139992997708928 [Note] InnoDB: Using SSE crc32 instructions
2019-03-01 14:42:42 139992997708928 [Note] InnoDB: Initializing buffer pool,
size = 128.0M
2019-03-01 14:42:42 139992997708928 [Note] InnoDB: Completed initialization of
buffer pool
2019-03-01 14:42:42 139992997708928 [Note] InnoDB: Highest supported file
format is Barracuda.
2019-03-01 14:42:42 139992997708928 [Note] InnoDB: 128 rollback segment(s) are
active.
2019-03-01 14:42:42 139992997708928 [Note] InnoDB: Waiting for purge to start
2019-03-01 14:42:42 139992997708928 [Note] InnoDB: Percona XtraDB
(http://www.percona.com) 5.6.41-84.1 started; log sequence number 1616797
2019-03-01 14:42:42 139992997708928 [Note] Plugin 'FEEDBACK' is disabled.
2019-03-01 14:42:42 139992387024640 [Note] InnoDB: Dumping buffer pool(s) not
yet started
2019-03-01 14:42:42 139992997708928 [Note] Server socket created on IP:
'127.0.0.1'.
2019-03-01 14:42:42 139992997708928 [Note] /usr/sbin/mysqld: ready for
connections.
Version: '10.1.37-MariaDB-0+deb9u1' socket: '/var/run/mysqld/mysqld.sock'
port: 3306 Debian 9.6
