Description:
Bonjour,
Données sur mysql
MySQL 5.0.75-0ubuntu10.2
localhost
127.0.0.1
main problems
1)system unable to stop mysql at any moment
2)access denied even though root is ok
3)update impossible (because unable to stop the server)
Example
bruno@bruno:~$ sudo /etc/init.d/mysql stop
[sudo] password for bruno:
Stopping MySQL database server mysqld [fail]
Mysql-admin (gui) works though but unable to stop mysql even launched as root. Mysql works though, able to install tables on local host.
Udpate problem :
E: /var/cache/apt/archives/mysql-server_5.1.30really5.0.75-0ubuntu10.2_all.deb: le sous-processus pre-installation script a retourné une erreur de sortie d'état 1
If I want to uninstall all mysql synaptic or apt wants to remove all kde !
sudo apt-get --purge remove mysql-server
doesn't fare better :
Suppression de mysql-server-5.0 ...
* Stopping MySQL database server mysqld [fail]
invoke-rc.d: initscript mysql, action "stop" failed.
dpkg : erreur de traitement de mysql-server-5.0 (--purge) :
le sous-processus pre-removal script a retourné une erreur de sortie d'état 1
* Stopping MySQL database server mysqld [fail]
invoke-rc.d: initscript mysql, action "stop" failed.
* Starting MySQL database server mysqld [ OK ]
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'debian-sys-maint'@'localhost' (using password: YES)'
Des erreurs ont été rencontrées pendant l'exécution :
mysql-server-5.0
E: Sub-process /usr/bin/dpkg returned an error code (1)
3 users for mysql : root, with passwd ok and full rights, bruno et debain-sys-maint which i reckon is installed by the deb package.
A root command fails and report a problem with this :
error: 'Access denied for user 'debian-sys-maint'@'localhost' (using password: YES)'
even though debian-sys-maint is not in user list of the system.
Other exapme
bruno@bruno:~$ sudo mysqladmin variables
[sudo] password for bruno:
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'
Other got similar problems : http://ubuntuforums.org/archive/index.php/t-1126169.html
system Infos :
kern.log
Aug 6 16:04:47 bruno kernel: [10368.138422] mysqld[10035]: segfault at 0 ip 00000000008a4e79 sp 00007fffe80a31f0 error 4 in mysqld[400000+75d000]
daemon.log
Aug 7 13:57:33 bruno mysqld_safe[2460]: started
Aug 7 13:57:33 bruno mysqld[2463]: 090807 13:57:33 InnoDB: Started; log sequence number 0 971208
Aug 7 13:57:33 bruno mysqld[2463]: 090807 13:57:33 [Note] /usr/sbin/mysqld: ready for connections.
Aug 7 13:57:33 bruno mysqld[2463]: Version: '5.0.75-0ubuntu10.2' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu)
Aug 7 13:57:34 bruno /etc/mysql/debian-start[2502]: Upgrading MySQL tables if necessary.
Aug 7 13:57:34 bruno /etc/mysql/debian-start[2508]: Looking for 'mysql' as: /usr/bin/mysql
Aug 7 13:57:34 bruno /etc/mysql/debian-start[2508]: Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck
Aug 7 13:57:34 bruno /etc/mysql/debian-start[2508]: Running 'mysqlcheck'...
Aug 7 13:57:34 bruno /etc/mysql/debian-start[2508]: /usr/bin/mysqlcheck: Got error: 1045: Access denied for user 'debian-sys-maint'@'localhost' (using password: YES) when trying to connect
Aug 7 13:57:34 bruno /etc/mysql/debian-start[2508]: FATAL ERROR: Upgrade failed
Aug 7 13:57:34 bruno /etc/mysql/debian-start[2609]: Checking for insecure root accounts.
Tous les logs contentant 'mysl'. Mysql ne lance pas de err je ne sais pas comment faire.
2009-08-07 10:49:59 bruno mysqld[2463] 090807 10:49:59 [ERROR] /usr/sbin/mysqld: Table './spip/spip_meta' is marked as crashed and should be repaired
2009-08-07 10:49:59 bruno mysqld[2463] 090807 10:49:59 [Warning] Checking table: './spip/spip_meta'
2009-08-07 13:57:32 bruno kernel [ 11.562015] type=1505 audit(1249646251.224:10): operation="profile_load" name="/usr/sbin/mysqld" name2="default" pid=1976
2009-08-07 13:57:32 bruno kernel [ 11.575194] type=1505 audit(1249646251.236:11): operation="profile_load" name="/usr/sbin/mysqld-akonadi" name2="default" pid=1980
2009-08-07 13:57:33 bruno mysqld_safe[2460] started
2009-08-07 13:57:33 bruno mysqld[2463] 090807 13:57:33 InnoDB: Started; log sequence number 0 971208
2009-08-07 13:57:33 bruno mysqld[2463] 090807 13:57:33 [Note] /usr/sbin/mysqld: ready for connections.
2009-08-07 13:57:33 bruno mysqld[2463] Version: '5.0.75-0ubuntu10.2' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu)
2009-08-07 13:57:34 bruno /etc/mysql/debian-start[2502] Upgrading MySQL tables if necessary.
2009-08-07 13:57:34 bruno /etc/mysql/debian-start[2508] Looking for 'mysql' as: /usr/bin/mysql
2009-08-07 13:57:34 bruno /etc/mysql/debian-start[2508] Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck
2009-08-07 13:57:34 bruno /etc/mysql/debian-start[2508] Running 'mysqlcheck'...
2009-08-07 13:57:34 bruno /etc/mysql/debian-start[2508] /usr/bin/mysqlcheck: Got error: 1045: Access denied for user 'debian-sys-maint'@'localhost' (using password: YES) when trying to connect
2009-08-07 13:57:34 bruno /etc/mysql/debian-start[2508] FATAL ERROR: Upgrade failed
2009-08-07 13:57:34 bruno /etc/mysql/debian-start[2609] Checking for insecure root accounts.
How to repeat:
Well this repeats all the time.