我本來是打算自己去MySQL網站抓下來照doc寫的灌 但他們網站寫說建議我用apt-get來灌 所以我就照著作 點點點就灌好了 很輕鬆 但是... 在要下mysql_install_db的時候卻出現了這樣的問題: Installing MySQL system tables... ERROR: 1062 Duplicate entry '%-test-' for key 1 070723 2:24:56 [ERROR] Aborting 070723 2:24:56 [Note] /usr/sbin/mysqld: Shutdown complete Installation of system tables failed! /* 一些註解 Examine the logs in /var/lib/mysql for more information. You can try to start the mysqld daemon with: /usr/sbin/mysqld --skip-grant & and use the command line tool /usr/bin/mysql to connect to the mysql database and look at the grant tables: shell> /usr/bin/mysql -u root mysql mysql> show tables Try 'mysqld --help' if you have problems with paths. Using --log gives you a log in /var/lib/mysql that may be helpful. The latest information about MySQL is available on the web at http://www.mysql.com Please consult the MySQL manual section: 'Problems running mysql_install_db', and the manual section that describes problems on your OS. Another information source is the MySQL email archive. Please check all of the above before mailing us! And if you do mail us, you MUST use the /usr/bin/mysqlbug script! */ 休息一下休息一下休息一下休息一下休息一下休息一下休息一下休息一下休息一下休息.. 上網神了很多 還是都沒辦法 也去看過my.cnf了 裡面mysqld.sock的path去找了也在那個位子 = = 請問有前輩知道怎麼辦嗎 下面是我的my.cnf 我也看不懂哪裡有問題 唉 (我有把一些應該不重要的註解去掉了) ------------------------------------------------------------------------------ [client] port = 3306 socket = /var/run/mysqld/mysqld.sock # Here is entries for some specific programs # The following values assume you have at least 32M ram # This was formally known as [safe_mysqld]. Both versions are currently parsed. [mysqld_safe] socket = /var/run/mysqld/mysqld.sock nice = 0 [mysqld] user = mysql pid-file = /var/run/mysqld/mysqld.pid socket = /var/run/mysqld/mysqld.sock port = 3306 basedir = /usr datadir = /var/lib/mysql tmpdir = /tmp language = /usr/share/mysql/english skip-external-locking key_buffer = 16M max_allowed_packet = 16M thread_stack = 128K thread_cache_size = 8 query_cache_limit = 1M query_cache_size = 16M log_bin = /var/log/mysql/mysql-bin.log expire_logs_days = 10 max_binlog_size = 100M #binlog_do_db = include_database_name #binlog_ignore_db = include_database_name [mysqldump] quick quote-names max_allowed_packet = 16M [mysql] #no-auto-rehash # faster start of mysql but no tab completition [isamchk] key_buffer = 16M # # * IMPORTANT: Additional settings that can override those from this file! # !includedir /etc/mysql/conf.d/ -- 謝謝大家的指導 --

※ 發信站: 批踢踢實業坊(ptt.cc) ◆ From: 61.228.80.9 謝謝 這樣有比較好嗎? ※ 編輯: penguin0322 來自: 61.228.80.9 (07/23 03:37) ※ 編輯: penguin0322 來自: 61.228.80.9 (07/23 03:39)