Mysql complètement bloqué
Riverdance
-
Riverdance -
Riverdance -
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 ç
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 ç
13 réponses
-
Salut,
tu as un accès root à ton système? -
-
-
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) -
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre question -
C'est peut être mysqld
fait unls /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 -