|MySQL Connection failure.||Wednesday 21st September 2005|
I run a MYSQL daemon on my PC at work, for tinking and general messing about with stuff. Although today when I tried to logon I couldn't. Producing this error:|
ERROR 1130 HY000 Host 'localhost' is not allowed to connect to this MySQL server
Which was great fun. It didn't matter how many different combinations of username, hostnames and passwords I tried. No luck.
A quick search on Google resulted in numerous people with the problem, but no fix. So I had to figure it out the hard way. Luckily it's not that hard. This is what you need to do.
Stop mysqld and restart it with the switch '--skip-grant-tables'. This will mean the server will bypass authentification when clients connect. You will now find that you can logon to MySQL in the normal way.
I found if I did a select on mysql.user, nothing was returned. Which was the cause of the problem. Alas the GRANT option doesn't work when the server is started without grant tables.
What you need to do is manually insert a user record. This script will insert a user record for "root" with the password of "password" (make sure you change it after).
INSERT INTO user VALUES ('%', 'root', PASSWORD('password'),'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','',DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT);
You then need to shutdown the MySQL daemon, but the password will have taken affect, so quit MySQL and run this command:
mysqladmin -u root -p shutdown
Enter "password" when prompted.
Hey presto, you now have root back in place and you can set about using GRANT again after starting up MySQL in the normal fashion.
|Dead Themaltake PSU||Saturday 10th September 2005|
It seems the thing that I go through the most on my computer is PSU (Power Supply Units). They are rated to get somewhere over 50,000 hours out of them, but I don't think I get far over 1,000.|
My most recent one has lasted me for just over 2 years. It's a 420Watt Themaltake Purepower. Then just the other day it died. It looks like one of the 12V rails has gone capput. It still powers the motherboard when the system is "off", but when I try and boot there is just a arcing noise and nothing happens.
I went to look up the warrenty on it, alas they are an American company, that (a) charge you $25 for something, and (b), you have to arrange postage. So this is PSU is going in the bin.
I have been talking to some people and it looks like the good brands at the moment are Hiper, Tagen, and of course, Antec. I think I will go with an Antec 480Watt TruePower 2, which has got a lot of good reviews.
|DVD Menus and trailers||Thursday 8th September 2005|
The one thing I hate about DVD's are the copyright menus that you are forced to watch, or even worse being forced to watch trailers.|
I think finally somebody came to their senses and allowed the use of the Menu button in the Hitchhikers Guide to the Galaxy! Although the massive number of trailers they bombared you with if you don't hit menu is mind boggling.
Still, why do they bother? I like trailers, just not when I am watching a film. I just skip them. Why not just put them into a special features menu? I buy a DVD for the film, occasionally special features are nice, but copyright notices and trailers? Who cares. Put the copyright notice in the sleeve or something.