我本来是打算自己去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)