[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

Re: MYSQL

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


Reply to: