You are not logged in.
Hello everybody. I have a problem with my MySQL server. Just installed it, ant when i try to start it:
[root@localhost html]# /etc/rc.d/mysqld start
:: Adding mysql group [DONE]
:: Adding mysql user [DONE]
Installing MySQL system tables...
ERROR: 1062 Duplicate entry 'localhost-' for key 1
071223 22:35:05 [ERROR] Aborting
071223 22:35:05 [Note] /usr/sbin/mysqld: Shutdown complete
Installation of system tables failed!
I tryed to search some info in google, havent found anything.
Does anybody has some ideas?
Last edited by neXTPeer (2007-12-23 08:38:09)
Offline
Tryed to remove /var/lib/mysql tables, and run
# mysql_install_db --datadir=/var/lib/mysql
But same happens...
Offline
did you alter the my.cnf at all?
seems it is complaining about a duplicate entry 'localhost-'
*shrugs*
haven't seen that error before.
you might also check your hostname, in /etc/hosts
see if anything looks unusual in there..
(not exactly sure where mysql gets some of its initial hostname type data from)
"Be conservative in what you send; be liberal in what you accept." -- Postel's Law
"tacos" -- Cactus' Law
"t̥͍͎̪̪͗a̴̻̩͈͚ͨc̠o̩̙͈ͫͅs͙͎̙͊ ͔͇̫̜t͎̳̀a̜̞̗ͩc̗͍͚o̲̯̿s̖̣̤̙͌ ̖̜̈ț̰̫͓ạ̪͖̳c̲͎͕̰̯̃̈o͉ͅs̪ͪ ̜̻̖̜͕" -- -̖͚̫̙̓-̺̠͇ͤ̃ ̜̪̜ͯZ͔̗̭̞ͪA̝͈̙͖̩L͉̠̺͓G̙̞̦͖O̳̗͍
Offline
No, i havent changed anything in my.cnf (i have no idea, what i need to change).
/etc/hosts seems good(I think...)
127.0.0.1 myhost.domain.org localhost.localdomain localhost myhost
Offline
Problem solved. hostname in rc.conf can't be localhost.
Offline
I have a huge problem, it seems I can't login to my own mysql server
mysql -u root -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
The first time I started mysqld I got the same error as above. The script that should create an account stopped. Because of this I didn't set a root password. I think I never set a root password, but somehow mysqld expects one.
Could someone help?
btw: my host in rc.conf is not localhost and it's corresponding with the hostname in /etc/hosts
-edit--
I just tried these steps: http://dev.mysql.com/doc/refman/5.0/en/ … sions-unix
But this also didn't work
--edit2--
Seems that there isn't a root account at all!
Last edited by Vrieskist (2008-02-07 02:21:24)
Offline
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
realy suxx
Offline
Have you tried:
1. Stop mysqld and restart it with the --skip-grant-tables --user=root options (Windows users omit the --user=root portion).
2. Connect to the mysqld server with this command: mysql -u root
3. Issue the following statements in the mysql client:
mysql> UPDATE mysql.user SET Password=PASSWORD('newpwd') WHERE User='root';
mysql> FLUSH PRIVILEGES;
*Replace "newpwd" with the actual root password that you want to use.
You should be able to connect using the new password.
Matt
"It is very difficult to educate the educated."
Offline
didnt work...
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
no problems on debian but arch-linux mysql drives me crazy...
Last edited by badbrain (2008-09-22 23:25:12)
Offline
didnt work...
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)no problems on debian but arch-linux mysql drives me crazy...
I'd backup the raw tables of /var/lib/mysql/tablenames by just copying the folders to another directory, then uninstall mysql, and reinstall it. and then just copy the folders back into that directory and you'll be fine.
Offline
and sometimes...
just a reboot helps ;-)
Offline