Mysql complètement bloqué

Salut,

tu as un accès root à ton système?

Oui...

Mais lorsque je veux l'utiliser pour me connecter à mysql, ça coince !

Alor, essaie ça
http://www.commentcamarche.net/forum/affich 2755583 galere a n en plus finir avec l acces a mysql#11

Lorsque je souhaite quitter mysql :

ns39682:/home/wood# /etc/init.d/mysql stop
bash: /etc/init.d/mysql: Aucun fichier ou r?pertoire de ce type

ou

ns39682:/home/wood# /usr/local/mysql/bin/mysql stop
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

C'est peut être mysqld

fait un

 ls /etc/init.d/mysql*

--

lami20j

ns39682:/home/woodgate# ls /etc/init.d/mysql*
ls: /etc/init.d/mysql*: Aucun fichier ou r?pertoire de ce type

La haine.

find / -name '*mysql*' 2>/dev/null

et affiche le résultat

Voilà :

ns39682:/home/wood# find / -name '*mysql*' 2>/dev/null
/home/xorilog/site/Scripts/mysql.php
/etc/mysql
/tmp/mysql.sock
/usr/bin/mysql_explain_log
/usr/bin/mysql
/usr/bin/mysql_fix_extensions
/usr/bin/mysql_find_rows
/usr/bin/mysqlmanager-pwgen
/usr/bin/mysql_tableinfo
/usr/bin/mysql_waitpid
/usr/bin/mysqlaccess
/usr/bin/mysqladmin
/usr/bin/mysqlbug
/usr/bin/mysqlcheck
/usr/bin/mysqldump
/usr/bin/mysqldumpslow
/usr/bin/mysqlimport
/usr/bin/mysqlmanager
/usr/bin/mysqlmanagerc
/usr/bin/mysqlshow
/usr/lib/perl5/auto/DBD/mysql
/usr/lib/perl5/auto/DBD/mysql/mysql.so
/usr/lib/perl5/auto/DBD/mysql/mysql.bs
/usr/lib/perl5/Bundle/DBD/mysql.pm
/usr/lib/perl5/DBD/mysql.pm
/usr/lib/perl5/DBD/mysql
/usr/lib/libmysqlclient.so.12.0.0
/usr/lib/libmysqlclient_r.so.12.0.0
/usr/lib/libmysqlclient_r.so.12
/usr/lib/libmysqlclient.so.12
/usr/local/mysql
/usr/local/mysql/bin/mysql_waitpid
/usr/local/mysql/bin/mysqld
/usr/local/mysql/bin/mysqld-debug
/usr/local/mysql/bin/mysql_tzinfo_to_sql
/usr/local/mysql/bin/mysqlmanager
/usr/local/mysql/bin/mysql
/usr/local/mysql/bin/mysqlshow
/usr/local/mysql/bin/mysqladmin
/usr/local/mysql/bin/mysqldump
/usr/local/mysql/bin/mysqlimport
/usr/local/mysql/bin/mysqltest
/usr/local/mysql/bin/mysqlcheck
/usr/local/mysql/bin/mysqlbinlog
/usr/local/mysql/bin/mysql_upgrade
/usr/local/mysql/bin/mysql_client_test
/usr/local/mysql/bin/mysqltestmanagerc
/usr/local/mysql/bin/mysqltestmanager-pwgen
/usr/local/mysql/bin/mysqltestmanager
/usr/local/mysql/bin/safe_mysqld
/usr/local/mysql/bin/msql2mysql
/usr/local/mysql/bin/mysql_config
/usr/local/mysql/bin/mysql_convert_table_format
/usr/local/mysql/bin/mysql_explain_log
/usr/local/mysql/bin/mysql_find_rows
/usr/local/mysql/bin/mysql_fix_extensions
/usr/local/mysql/bin/mysql_fix_privilege_tables
/usr/local/mysql/bin/mysql_fix_privilege_tables_sql.c
/usr/local/mysql/bin/mysql_secure_installation
/usr/local/mysql/bin/mysql_setpermission
/usr/local/mysql/bin/mysql_tableinfo
/usr/local/mysql/bin/mysql_upgrade_shell
/usr/local/mysql/bin/mysql_zap
/usr/local/mysql/bin/mysqlaccess
/usr/local/mysql/bin/mysqlaccess.conf
/usr/local/mysql/bin/mysqlbug
/usr/local/mysql/bin/mysqld_multi
/usr/local/mysql/bin/mysqld_safe
/usr/local/mysql/bin/mysqldumpslow
/usr/local/mysql/bin/mysqlhotcopy
/usr/local/mysql/docs/mysql.info
/usr/local/mysql/include/mysql.h
/usr/local/mysql/include/mysql_com.h
/usr/local/mysql/include/mysql_embed.h
/usr/local/mysql/include/mysql_h.ic
/usr/local/mysql/include/mysql_time.h
/usr/local/mysql/include/mysql_version.h
/usr/local/mysql/include/mysqld_ername.h
/usr/local/mysql/include/mysqld_error.h
/usr/local/mysql/lib/libmysqlclient.a
/usr/local/mysql/lib/libmysqlclient.so
/usr/local/mysql/lib/libmysqlclient.so.15
/usr/local/mysql/lib/libmysqlclient.so.15.0.0
/usr/local/mysql/lib/libmysqlclient_r.a
/usr/local/mysql/lib/libmysqlclient_r.so
/usr/local/mysql/lib/libmysqlclient_r.so.15
/usr/local/mysql/lib/libmysqlclient_r.so.15.0.0
/usr/local/mysql/lib/libmysql.imp
/usr/local/mysql/support-files/mysql-5.0.45.spec
/usr/local/mysql/support-files/mysql-log-rotate
/usr/local/mysql/support-files/mysql.server
/usr/local/mysql/support-files/mysql.spec
/usr/local/mysql/share/mysql
/usr/local/mysql/share/mysql_fix_privilege_tables.sql
/usr/local/mysql/share/mysql_system_tables.sql
/usr/local/mysql/share/mysql_system_tables_data.sql
/usr/local/mysql/share/mysql_system_tables_fix.sql
/usr/local/mysql/share/mysql_test_data_timezone.sql
/usr/local/mysql/scripts/mysql_install_db
/usr/local/mysql/mysql-test
/usr/local/mysql/mysql-test/t/innodb_mysql.test
/usr/local/mysql/mysql-test/t/mysql.test
/usr/local/mysql/mysql-test/t/mysql_client_test.test
/usr/local/mysql/mysql-test/t/mysql_protocols.test
/usr/local/mysql/mysql-test/t/mysql_upgrade.test
/usr/local/mysql/mysql-test/t/mysqladmin.test
/usr/local/mysql/mysql-test/t/mysqlbinlog-cp932.test
/usr/local/mysql/mysql-test/t/mysqlbinlog.test
/usr/local/mysql/mysql-test/t/mysqlbinlog2.test
/usr/local/mysql/mysql-test/t/mysqlcheck.test
/usr/local/mysql/mysql-test/t/mysqldump-max.test
/usr/local/mysql/mysql-test/t/mysqldump.test
/usr/local/mysql/mysql-test/t/mysqlshow.test
/usr/local/mysql/mysql-test/t/mysqltest.test
/usr/local/mysql/mysql-test/t/system_mysql_db.test
/usr/local/mysql/mysql-test/t/system_mysql_db_fix30020.test
/usr/local/mysql/mysql-test/t/system_mysql_db_fix40123.test
/usr/local/mysql/mysql-test/t/system_mysql_db_refs.test
/usr/local/mysql/mysql-test/t/innodb_mysql-master.opt
/usr/local/mysql/mysql-test/t/mysql_client_test.opt
/usr/local/mysql/mysql-test/t/mysqlbinlog-cp932-master.opt
/usr/local/mysql/mysql-test/t/mysqlbinlog-master.opt
/usr/local/mysql/mysql-test/t/system_mysql_db_fix30020-master.opt
/usr/local/mysql/mysql-test/t/system_mysql_db_fix40123-master.opt
/usr/local/mysql/mysql-test/t/mysql_delimiter.sql
/usr/local/mysql/mysql-test/t/mysql_delimiter_19799.sql
/usr/local/mysql/mysql-test/t/mysql_delimiter_source.sql
/usr/local/mysql/mysql-test/r/have_mysql_upgrade.result
/usr/local/mysql/mysql-test/r/innodb_mysql.result
/usr/local/mysql/mysql-test/r/mysql.result
/usr/local/mysql/mysql-test/r/mysql_client_test.result
/usr/local/mysql/mysql-test/r/mysql_protocols.result
/usr/local/mysql/mysql-test/r/mysql_upgrade.result
/usr/local/mysql/mysql-test/r/mysqladmin.result
/usr/local/mysql/mysql-test/r/mysqlbinlog-cp932.result
/usr/local/mysql/mysql-test/r/mysqlbinlog.result
/usr/local/mysql/mysql-test/r/mysqlbinlog2.result
/usr/local/mysql/mysql-test/r/mysqlcheck.result
/usr/local/mysql/mysql-test/r/mysqldump-max.result
/usr/local/mysql/mysql-test/r/mysqldump.result
/usr/local/mysql/mysql-test/r/mysqlshow.result
/usr/local/mysql/mysql-test/r/mysqltest.result
/usr/local/mysql/mysql-test/r/system_mysql_db.result
/usr/local/mysql/mysql-test/r/system_mysql_db_refs.result
/usr/local/mysql/mysql-test/include/mysqltest-x.inc
/usr/local/mysql/mysql-test/mysql-test-run
/usr/local/mysql/mysql-test/mysql-test-run.pl
/usr/local/mysql/sql-bench/Comments/mysql.benchmark
/usr/local/mysql/sql-bench/limits/mysql-3.22.cfg
/usr/local/mysql/sql-bench/limits/mysql-3.23.cfg
/usr/local/mysql/sql-bench/limits/mysql-4.0.cfg
/usr/local/mysql/sql-bench/limits/mysql-4.1.cfg
/usr/local/mysql/sql-bench/limits/mysql.cfg
/usr/local/mysql/man/man1/msql2mysql.1
/usr/local/mysql/man/man1/mysql-stress-test.pl.1
/usr/local/mysql/man/man1/mysql-test-run.pl.1
/usr/local/mysql/man/man1/mysql.1
/usr/local/mysql/man/man1/mysql.server.1
/usr/local/mysql/man/man1/mysql_client_test.1
/usr/local/mysql/man/man1/mysql_client_test_embedded.1
/usr/local/mysql/man/man1/mysql_config.1
/usr/local/mysql/man/man1/mysql_convert_table_format.1
/usr/local/mysql/man/man1/mysql_explain_log.1
/usr/local/mysql/man/man1/mysql_find_rows.1
/usr/local/mysql/man/man1/mysql_fix_extensions.1
/usr/local/mysql/man/man1/mysql_fix_privilege_tables.1
/usr/local/mysql/man/man1/mysql_install_db.1
/usr/local/mysql/man/man1/mysql_secure_installation.1
/usr/local/mysql/man/man1/mysql_setpermission.1
/usr/local/mysql/man/man1/mysql_tableinfo.1
/usr/local/mysql/man/man1/mysql_tzinfo_to_sql.1
/usr/local/mysql/man/man1/mysql_upgrade.1
/usr/local/mysql/man/man1/mysql_waitpid.1
/usr/local/mysql/man/man1/mysql_zap.1
/usr/local/mysql/man/man1/mysqlaccess.1
/usr/local/mysql/man/man1/mysqladmin.1
/usr/local/mysql/man/man1/mysqlbinlog.1
/usr/local/mysql/man/man1/mysqlcheck.1
/usr/local/mysql/man/man1/mysqld_multi.1
/usr/local/mysql/man/man1/mysqld_safe.1
/usr/local/mysql/man/man1/mysqldump.1
/usr/local/mysql/man/man1/mysqlhotcopy.1
/usr/local/mysql/man/man1/mysqlimport.1
/usr/local/mysql/man/man1/mysqlman.1
/usr/local/mysql/man/man1/mysqlmanager-pwgen.1
/usr/local/mysql/man/man1/mysqlmanagerc.1
/usr/local/mysql/man/man1/mysqlshow.1
/usr/local/mysql/man/man1/mysqltest.1
/usr/local/mysql/man/man1/mysqltest_embedded.1
/usr/local/mysql/man/man1/safe_mysqld.1
/usr/local/mysql/man/man8/mysqld.8
/usr/local/mysql/man/man8/mysqlmanager.8
/usr/local/mysql/data/mysql
/usr/share/doc/mysql-common
/usr/share/doc/libmysqlclient12
/usr/share/doc/libdbd-mysql-perl
/usr/share/doc/mysql-client
/usr/share/man/man1/mysql_fix_extensions.1.gz
/usr/share/man/man1/mysql.1.gz
/usr/share/man/man1/mysql_explain_log.1.gz
/usr/share/man/man1/mysql_find_rows.1.gz
/usr/share/man/man1/mysql_tableinfo.1.gz
/usr/share/man/man1/mysql_waitpid.1.gz
/usr/share/man/man1/mysqlaccess.1.gz
/usr/share/man/man1/mysqladmin.1.gz
/usr/share/man/man1/mysqlbug.1.gz
/usr/share/man/man1/mysqlcheck.1.gz
/usr/share/man/man1/mysqldump.1.gz
/usr/share/man/man1/mysqldumpslow.1.gz
/usr/share/man/man1/mysqlimport.1.gz
/usr/share/man/man1/mysqlmanager.1.gz
/usr/share/man/man1/mysqlshow.1.gz
/usr/share/man/man1/mysqlmanagerc.1.gz
/usr/share/man/man1/mysqlmanager-pwgen.1.gz
/usr/share/man/man3/DBD::mysql.3pm.gz
/usr/share/man/man3/Bundle::DBD::mysql.3pm.gz
/usr/share/man/man3/DBD::mysql::INSTALL.3pm.gz
/usr/share/vim/vim63/syntax/mysql.vim
/usr/src/php-5.2.3/ext/date/tests/strtotime-mysql.phpt
/usr/src/php-5.2.3/ext/mysql
/usr/src/php-5.2.3/ext/mysql/php_mysql.c
/usr/src/php-5.2.3/ext/mysql/php_mysql.h
/usr/src/php-5.2.3/ext/mysql/mysql.dsp
/usr/src/php-5.2.3/ext/mysql/mysql.mak
/usr/src/php-5.2.3/ext/mysql/.libs/php_mysql.o
/usr/src/php-5.2.3/ext/mysql/php_mysql.lo
/usr/src/php-5.2.3/ext/pgsql/mysql_users.php
/usr/src/php-5.2.3/ext/pdo_mysql
/usr/src/php-5.2.3/ext/pdo_mysql/php_pdo_mysql_sqlstate.h
/usr/src/php-5.2.3/ext/pdo_mysql/pdo_mysql.c
/usr/src/php-5.2.3/ext/pdo_mysql/php_pdo_mysql.h
/usr/src/php-5.2.3/ext/pdo_mysql/php_pdo_mysql_int.h
/usr/src/php-5.2.3/ext/pdo_mysql/mysql_driver.c
/usr/src/php-5.2.3/ext/pdo_mysql/mysql_statement.c
/usr/src/php-5.2.3/ext/mysqli
/usr/src/php-5.2.3/ext/mysqli/mysqli_nonapi.c
/usr/src/php-5.2.3/ext/mysqli/mysqli_embedded.c
/usr/src/php-5.2.3/ext/mysqli/mysqli_report.c
/usr/src/php-5.2.3/ext/mysqli/mysqli_report.h
/usr/src/php-5.2.3/ext/mysqli/mysqli_api.c
/usr/src/php-5.2.3/ext/mysqli/mysqli.dsp
/usr/src/php-5.2.3/ext/mysqli/mysqli_driver.c
/usr/src/php-5.2.3/ext/mysqli/mysqli_exception.c
/usr/src/php-5.2.3/ext/mysqli/php_mysqli.h
/usr/src/php-5.2.3/ext/mysqli/mysqli_prop.c
/usr/src/php-5.2.3/ext/mysqli/mysqli_repl.c
/usr/src/php-5.2.3/ext/mysqli/mysqli_fe.c
/usr/src/php-5.2.3/ext/mysqli/mysqli.c
/usr/src/php-5.2.3/ext/mysqli/mysqli_warning.c
/var/cache/apt/archives/mysql-common_4.0.24-10sarge2_all.deb
/var/cache/apt/archives/libmysqlclient12_4.0.24-10sarge2_i386.deb
/var/cache/apt/archives/libdbd-mysql-perl_2.9006-1_i386.deb
/var/cache/apt/archives/mysql-client_4.0.24-10sarge2_i386.deb
/var/lib/dpkg/info/mysql-common.postrm
/var/lib/dpkg/info/mysql-common.list
/var/lib/dpkg/info/mysql-common.conffiles
/var/lib/dpkg/info/mysql-common.md5sums
/var/lib/dpkg/info/libmysqlclient12.shlibs
/var/lib/dpkg/info/libmysqlclient12.list
/var/lib/dpkg/info/libmysqlclient12.postinst
/var/lib/dpkg/info/libmysqlclient12.postrm
/var/lib/dpkg/info/libmysqlclient12.md5sums
/var/lib/dpkg/info/libdbd-mysql-perl.md5sums
/var/lib/dpkg/info/libdbd-mysql-perl.list
/var/lib/dpkg/info/mysql-client.md5sums
/var/lib/dpkg/info/mysql-client.list
/var/run/mysqld
/var/run/mysqld/mysqld.sock
/var/www/phpmyadmin/scripts/create_tables_mysql_4_1_2+.sql
/var/www/phpmyadmin/scripts/upgrade_tables_mysql_4_1_2+.sql
/var/www/phpmyadmin/libraries/mysql_charsets.lib.php
/var/www/phpmyadmin/libraries/dbi/mysqli.dbi.lib.php
/var/www/phpmyadmin/libraries/dbi/mysql.dbi.lib.php

Donc tu n'as pas suits la procédure complère d'installation ;-)

la 1ère commande arrête le daemon mysql

tu peux le faire avec kill ensuite tape les autres, mais adapte les commandes et les chemin à ton cas

par exemple chez toi c'est safe_mysqld

A propos du kill...

J'ai remarqué que quand je fais un "top" pour voir le PID, celui-ci (le PID de mysqld) change chaque seconde !

Donc je n'arrive pas à le couper...

Affiche le résultat de ps aux | grep mysql
et quitte top

ns39682:/home/woodgate# ps aux | grep mysql
mysql 7823 0.0 0.1 4220 1404 ? S 2007 0:00 /bin/sh ./mysqld_safe --no-defaults --old-passwords
mysql 4116 0.0 2.3 55316 23884 ? S 14:33 0:00 /usr/local/mysql/bin/mysqld --no-defaults --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --pid-file=/usr/local/mysql/data/ns39682.ovh.net.pid --skip-external-locking --old-passwords
mysql 3542 0.0 2.3 55316 23884 ? S 14:33 0:00 /usr/local/mysql/bin/mysqld --no-defaults --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --pid-file=/usr/local/mysql/data/ns39682.ovh.net.pid --skip-external-locking --old-passwords
mysql 18668 0.0 2.3 55316 23884 ? S 14:33 0:00 /usr/local/mysql/bin/mysqld --no-defaults --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --pid-file=/usr/local/mysql/data/ns39682.ovh.net.pid --skip-external-locking --old-passwords
mysql 29408 0.0 2.3 55316 23884 ? S 14:33 0:00 /usr/local/mysql/bin/mysqld --no-defaults --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --pid-file=/usr/local/mysql/data/ns39682.ovh.net.pid --skip-external-locking --old-passwords
mysql 6089 0.0 2.3 55316 23884 ? S 14:33 0:00 /usr/local/mysql/bin/mysqld --no-defaults --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --pid-file=/usr/local/mysql/data/ns39682.ovh.net.pid --skip-external-locking --old-passwords
mysql 25660 0.0 2.3 55316 23884 ? S 14:33 0:00 /usr/local/mysql/bin/mysqld --no-defaults --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --pid-file=/usr/local/mysql/data/ns39682.ovh.net.pid --skip-external-locking --old-passwords
mysql 22451 0.0 2.3 55316 23884 ? S 14:33 0:01 /usr/local/mysql/bin/mysqld --no-defaults --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --pid-file=/usr/local/mysql/data/ns39682.ovh.net.pid --skip-external-locking --old-passwords
mysql 23546 0.0 2.3 55316 23884 ? S 14:33 0:00 /usr/local/mysql/bin/mysqld --no-defaults --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --pid-file=/usr/local/mysql/data/ns39682.ovh.net.pid --skip-external-locking --old-passwords
mysql 24019 0.0 2.3 55316 23884 ? S 14:33 0:00 /usr/local/mysql/bin/mysqld --no-defaults --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --pid-file=/usr/local/mysql/data/ns39682.ovh.net.pid --skip-external-locking --old-passwords
mysql 6823 0.0 2.3 55316 23884 ? S 14:33 0:01 /usr/local/mysql/bin/mysqld --no-defaults --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --pid-file=/usr/local/mysql/data/ns39682.ovh.net.pid --skip-external-locking --old-passwords
mysql 3868 0.0 2.3 55316 23884 ? S 16:57 0:00 /usr/local/mysql/bin/mysqld --no-defaults --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --pid-file=/usr/local/mysql/data/ns39682.ovh.net.pid --skip-external-locking --old-passwords
root 28060 0.0 0.0 3208 700 pts/1 S+ 16:58 0:00 grep mysql

Résolu.