Re: MySQL - nie moze sie polaczyc?
> A co w syslogu?
coś takiego w jednej z lini :
/usr/sbin/mysqld: unknown variable 'old_passwords=1'
oraz
Installation of grant tables failed!
Aug 4 10:34:33 localhost mysqld_safe[5770]: Preparing db table
Aug 4 10:34:33 localhost mysqld_safe[5770]: Preparing host table
Aug 4 10:34:33 localhost mysqld_safe[5770]: Preparing user table
Aug 4 10:34:33 localhost mysqld_safe[5770]: Preparing func table
Aug 4 10:34:33 localhost mysqld_safe[5770]: Preparing tables_priv table
Aug 4 10:34:33 localhost mysqld_safe[5770]: Preparing columns_priv table
Aug 4 10:34:33 localhost mysqld_safe[5770]: Installing all prepared tables
Aug 4 10:34:33 localhost mysqld_safe[5770]: 050804 10:34:33 /usr/sbin/mysqld:
unknown variable 'old_passwords=1'
Aug 4 10:34:33 localhost mysqld_safe[5770]:
Aug 4 10:34:33 localhost mysqld_safe[5770]: Installation of grant tables
failed!
Aug 4 10:34:33 localhost mysqld_safe[5770]:
Aug 4 10:34:33 localhost mysqld_safe[5770]: Examine the logs
in /var/lib/mysql for more information.
Aug 4 10:34:33 localhost mysqld_safe[5770]: You can also try to start the
mysqld daemon with:
Aug 4 10:34:33 localhost mysqld_safe[5770]: /usr/sbin/mysqld --skip-grant &
Aug 4 10:34:33 localhost mysqld_safe[5770]: You can use the command line tool
Aug 4 10:34:33 localhost mysqld_safe[5770]: /usr/bin/mysql to connect to the
mysql
Aug 4 10:34:33 localhost mysqld_safe[5770]: database and look at the grant
tables:
Aug 4 10:34:33 localhost mysqld_safe[5770]:
Aug 4 10:34:33 localhost mysqld_safe[5770]: shell> /usr/bin/mysql -u root
mysql
Aug 4 10:34:33 localhost mysqld_safe[5770]: mysql> show tables
Aug 4 10:34:33 localhost mysqld_safe[5770]:
Aug 4 10:34:33 localhost mysqld_safe[5770]: Try 'mysqld --help' if you have
problems with paths. Using --log
Aug 4 10:34:33 localhost mysqld_safe[5770]: gives you a log in /var/lib/mysql
that may be helpful.
Aug 4 10:34:33 localhost mysqld_safe[5770]:
Aug 4 10:34:33 localhost mysqld_safe[5770]: The latest information about
MySQL is available on the web at
Aug 4 10:34:33 localhost mysqld_safe[5770]: http://www.mysql.com
Aug 4 10:34:33 localhost mysqld_safe[5770]: Please consult the MySQL manual
section: 'Problems running mysql_install_db',
Aug 4 10:34:33 localhost mysqld_safe[5770]: and the manual section that
describes problems on your OS.
Aug 4 10:34:33 localhost mysqld_safe[5770]: Another information source is the
MySQL email archive.
Aug 4 10:34:33 localhost mysqld_safe[5770]: Please check all of the above
before mailing us!
Aug 4 10:34:33 localhost mysqld_safe[5770]: And if you do mail us, you MUST
use the /usr/bin/mysqlbug script!
Aug 4 10:34:33 localhost mysqld_safe[5793]: 050804 10:34:33 /usr/sbin/mysqld:
unknown variable 'old_passwords=1'
Aug 4 10:34:33 localhost mysqld_safe[5793]:
Aug 4 10:34:33 localhost mysqld_safe[5797]: 050804 10:34:33 /usr/sbin/mysqld:
unknown variable 'old_passwords=1'
Aug 4 10:34:33 localhost mysqld_safe[5797]:
Aug 4 10:34:34 localhost mysqld_safe[5864]: started
Aug 4 10:34:34 localhost mysqld[5868]: 050804 10:34:34 /usr/sbin/mysqld:
unknown variable 'old_passwords=1'
Aug 4 10:34:34 localhost mysqld[5868]:
Aug 4 10:34:34 localhost mysqld_safe[5870]: ended
Aug 4 10:34:40 localhost /etc/init.d/mysql[5933]: 0 processes alive and
'/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Aug 4 10:34:40 localhost /etc/init.d/mysql[5933]: ^G/usr/bin/mysqladmin:
connect to server at 'localhost' failed
Aug 4 10:34:40 localhost /etc/init.d/mysql[5933]: error: 'Can't connect to
local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Aug 4 10:34:40 localhost /etc/init.d/mysql[5933]: Check that mysqld is
running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Aug 4 10:34:40 localhost /etc/init.d/mysql[5933]:
Reply to: