Arch Linux

hammerol

Member

Registered: 2007-12-14

Posts: 2

mysql_install db error on fresh archlinux

hi all~

I got this error when trying to install mysql on my fresh new archlinux

ERROR: 1062  Duplicate entry 'localhost-' for key 1

This is a very weird error

And i recalled that when i was trying to install mysql the other day, it was all ok
But this time this error came up

I followed the instructions in
http://wiki.archlinux.org/index.php/LAMP

So are there some steps that i forgot to perform this time?
Or is this some kind of bug?

Thanks in advance~

kozzi

Member

Registered: 2006-06-24

Posts: 16

Re: mysql_install db error on fresh archlinux

I have the same problem. It seems like a bug.

---

Linux je jako mušketýři "jeden za všechny, všichni za jednoho"

kozzi

Member

Registered: 2006-06-24

Posts: 16

Re: mysql_install db error on fresh archlinux

Problem is in /usr/share/mysql/mysql_system_tables_data.sql. You must remove this 2 lines:
INSERT INTO tmp_user (host,user) VALUES ('localhost','');
INSERT INTO tmp_user (host,user) VALUES (@@hostname,'');

---

Linux je jako mušketýři "jeden za všechny, všichni za jednoho"

hammerol

Member

Registered: 2007-12-14

Posts: 2

Re: mysql_install db error on fresh archlinux

i solved this problem by changing the hostname in /etc/rc.conf to something other than 'localhost'
it seems like a bug...