Have you ever been in a position where you have lost or been presented with the loss of the mysql root password. Oh yes, much fun and this happened when someone in authority needed mysql access.

We I tried the –skip grant tables, did not work so time for a different approach, enter the realm of the sever bodge (a bodge I would use in future unless other sites would be affected)

1. OK, log into the sever with SSH
2. find the mysql files, on fedora they are in /var/lib/mysql/mysql
3. Change the name of the three files user.frm, user.MYD and user.MYI, don’t delete them, call them user1.frm etc.
4. Log into another server with which has mysql and and you know the password and download the three user files. Transfer them to the original server.
5. Change the owner and group to mysql

chown mysql:mysql mysql

6. Change the chmod to the same as the other files in that directory, probably, 660
7. No you are nearly ready to go, you need to restart mysql so that the new password if activated as you need to flush the old privileges

Service mysqld restart

8. Right, if you have live sites on there this is the fly by the seat of the your pants bit as any of the usernames and passwords wont be present. So now open up phpmyadmin and use the root UN/PS. Bada Bing, your in. Got to the mysql db and look, you should see the new table called “user1”. Go into that and do a dump. Now take that dump and put it back into and sql window. Make sure you remove the root sql insert as you wont be able to overwrite this and quite frankly you don’t want to be able to either. If you don’t want to go through this last stage I suppose you could add the missing users before you do 5.

Hope that helps.

Have you ever had to reinstall your system, of course you have! Well one of the most important things is getting profiles back for things like the great SSH package, WinSCP.

Most things are fine but WinSCP is a bit of a bugger to sort. WinSCP has an import option, which is tickety boo if you have file to import! So it would seem logical that an Export option would be available. No, that’s too much to ask.

When you have as many WinSCP SSH profiles that I have it would be a ball ache of biblical proportions to find all those settings.

Well here is a quick guide to doing the task, after al there is no ini file, or something hidden in the windows local data settings.

Go to Start and Run
Type in “RegEdit” in the little box.
Then go to top left and click my computer
Then Click Edit > Find
Now search for “Martin Prikryl” (he must be the dude that made the software)
Then Right click and export the key and contents.
Now copy this file onto your new system
Go to RegEdit again and import the key (File > Import) and locate the file

May I make one suggestion that when messing with the registry, back that mutha up, as without a working one you could be heading for a reinstall and many hours of fun.

Well all over for another year, and if you were not able to make it this time, or as one person did not realise your passport was out of date, what the freak is wrong with you, get it sorted chief!!!

The Venue

The venue was something else, after driving through one of the most expensive areas of Copenhagen we ended up at a scene from Mad Max, which for me seemed to be a worry for my taxi driver, but hark a sign, “this is the place, let me out”

So after a little bit of mooching around, you can find what reports to be a lift, a few seconds later after taking the plunge and ignoring the worrying grinding sound I arrived at the top floor and was greated with some great graffiti, free cold Tuborg and a bunch of old and new faces.

The Faces

As always the SEO Roadshow brings together a stunning range of SEO names and good mates. I am sure we would get arrested if we all went out in public during the day!

The Finale

Well Copenhagen was unseasonally warm, with no real clouds the whole week I was there. So to recap, good people, good food, good venue, good company, good location, basically, a good un!

Thanks due to the vikings for sorting the whole gig, your efforts were appreciated.

Well hopefully this can be made to be a little different, different in that I am going to make the focus interview type sessions with prominent people in the search world. I have a few in the offing already so watch this space.

Another avenue I am going to pursue here at some point will be usability, I always find myself thinking “what ignoramus designed the processes on this site, they are shite”. So as I travel around the web and come across something I reckon I could do better I will make a note and hopefully put the details up here. A glorified moaning spot really.

Anyway, I hope you enjoy what I have planned, if not there is always SEO Blogs List

Cheers

ukgimp