Mysql complètement bloqué

Fermé
Riverdance - 4 janv. 2008 à 15:01
 Riverdance - 5 janv. 2008 à 00:36
Bonjour,

J'ai un problème avec un serveur basé sur debian dont je n'ai pas fait la configuration.

J'ai un serveur Mysql (installé dans /usr/local/mysql) que je ne peux pas gérer !

En effet, je ne peux me connecter qu'avec un login appellé "my_site", qui ne peut pas créer de bases de données.

Lorsque je veux me connecter via phpmyadmin avec root ou un autre compte unix, j'ai un denied.
Lorsque je veux faire un mysqladmin, j'ai aussi un denied, quel que soit le compte et le mot de passe...

Et comme je l'ai dit "my_site" ne peut pas gérer mysql (pas assez de droits).

Quelqu'un à une idée ?

Merci ç
A voir également:

13 réponses

lami20j Messages postés 21331 Date d'inscription jeudi 4 novembre 2004 Statut Modérateur, Contributeur sécurité Dernière intervention 30 octobre 2019 3 567
4 janv. 2008 à 15:18
Salut,

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

Mais lorsque je veux l'utiliser pour me connecter à mysql, ça coince !
0
lami20j Messages postés 21331 Date d'inscription jeudi 4 novembre 2004 Statut Modérateur, Contributeur sécurité Dernière intervention 30 octobre 2019 3 567
4 janv. 2008 à 15:27
0
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)
0

Vous n’avez pas trouvé la réponse que vous recherchez ?

Posez votre question
lami20j Messages postés 21331 Date d'inscription jeudi 4 novembre 2004 Statut Modérateur, Contributeur sécurité Dernière intervention 30 octobre 2019 3 567
4 janv. 2008 à 15:45
C'est peut être mysqld

fait un
 ls /etc/init.d/mysql*
--

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

La haine.
0
lami20j Messages postés 21331 Date d'inscription jeudi 4 novembre 2004 Statut Modérateur, Contributeur sécurité Dernière intervention 30 octobre 2019 3 567
4 janv. 2008 à 16:16
find / -name '*mysql*' 2>/dev/null
et affiche le résultat
0
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
0
lami20j Messages postés 21331 Date d'inscription jeudi 4 novembre 2004 Statut Modérateur, Contributeur sécurité Dernière intervention 30 octobre 2019 3 567
4 janv. 2008 à 16:53
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
0
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...
0
lami20j Messages postés 21331 Date d'inscription jeudi 4 novembre 2004 Statut Modérateur, Contributeur sécurité Dernière intervention 30 octobre 2019 3 567
4 janv. 2008 à 17:04
Affiche le résultat de ps aux | grep mysql
et quitte top
0
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
0
Résolu.
0