推 PsMonkey:建議在你的文章中加上分隔線或顏色，不然看的有點痛苦 07/23 03:09
謝謝 這樣有比較好嗎?
※ 編輯: penguin0322 來自: 61.228.80.9 (07/23 03:37)
※ 編輯: penguin0322 來自: 61.228.80.9 (07/23 03:39)
我本來是打算自己去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