Доброго времени суток. Ставлю мускуль5 под линух (Mandriva 2008), установка вродь без проблем.....но при попытке запустить mysql_install_db выдает ошибку конфил с опциями: Код (Text): --with-charset=utf8 --with-extra-charset=all вот что пишет консоль: Код (Text): [root@localhost scripts]# ./mysql_install_db Installing MySQL system tables... 081031 15:56:03 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295 081031 15:56:03 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295 ERROR: 1062 Duplicate entry 'localhost-' for key 1 081031 15:56:03 [ERROR] Aborting помогите плиз
аналогичная проблема. читал в нете про эту ошибку, пишут такая-то вот мол ошибка связано с тем-то, но никто реально не указал как ее исправить... жду ответов... заранее спс)
admyx спс конечно за совет... но это не ответ на вопрос и не решение проблемы... если знаеш с чем связана ошибка и как ее решить жду ответов. P/S: в забугровом форуме прочитал что это как-то связано с хостом (localhost). там предлажили сменить хост командой hostname имя хоста и заново запустить mysql_install_db я нехотел менять имя хоста но все таки попробовал в итоге [root@localhost mysql]# hostname host [root@localhost mysql]# bin/mysql_install_db WARNING: The host 'host' could not be looked up with resolveip. This probably means that your libc libraries are not 100 % compatible with this binary MySQL version. The MySQL daemon, mysqld, should work normally with the exception that host name resolving will not work. This means that you should use IP addresses instead of hostnames when specifying MySQL privileges ! Installing MySQL system tables... 081225 14:28:46 [Warning] option 'max_join_size': unsigned value 184467440737095 51615 adjusted to 4294967295 081225 14:28:46 [Warning] option 'max_join_size': unsigned value 184467440737095 51615 adjusted to 4294967295 OK Filling help tables... 081225 14:28:46 [Warning] option 'max_join_size': unsigned value 184467440737095 51615 adjusted to 4294967295 081225 14:28:46 [Warning] option 'max_join_size': unsigned value 184467440737095 51615 adjusted to 4294967295 OK To start mysqld at boot time you have to copy support-files/mysql.server to the right place for your system PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! To do so, start the server, then issue the following commands: /usr/local/mysql/bin/mysqladmin -u root password 'new-password' /usr/local/mysql/bin/mysqladmin -u root -h host password 'new-password' Alternatively you can run: /usr/local/mysql/bin/mysql_secure_installation which will also give you the option of removing the test databases and anonymous user created by default. This is strongly recommended for production servers. See the manual for more instructions. You can start the MySQL daemon with: cd /usr/local/mysql ; /usr/local/mysql/bin/mysqld_safe & You can test the MySQL daemon with mysql-test-run.pl cd mysql-test ; perl mysql-test-run.pl Please report any problems with the /usr/local/mysql/bin/mysqlbug script! The latest information about MySQL is available on the web at http://www.mysql.com Support MySQL by buying support/licenses at http://shop.mysql.com [root@localhost mysql]# bin/mysqld_safe & [1] 4944 [root@localhost mysql]# nohup: ignoring input and redirecting stderr to stdout Starting mysqld daemon with databases from /usr/local/mysql/var STOPPING server from pid file /usr/local/mysql/var/host.pid 081225 14:30:49 mysqld ended и чтоже теперь?(((