Copying MySQL Usernames and Database Priveleges

Now that I’m the nominal MySQL DBA for PSU, it became my job to jimmy up the MySQL user privileges so that the new web server could connect. I’m not sure if this is the fastest, most efficient way to do it, but it worked quickly enough:

``` CREATE TABLE mysql.user_copy SELECT * FROM mysql.user; DELETE FROM mysql.user_copy WHERE Host NOT LIKE 'OLD_HOST_NAME'; UPDATE mysql.user_copy SET Host = 'NEW_HOST_NAME'; INSERT INTO mysql.user SELECT * FROM mysql.user_copy; DROP TABLE mysql.user_copy;   CREATE TABLE mysql.db_copy SELECT * FROM mysql.db; DELETE FROM mysql.db_copy WHERE Host NOT LIKE 'OLD_HOST_NAME'; UPDATE mysql.db_copy SET Host = 'NEW_HOST_NAME'; INSERT INTO mysql.db SELECT * FROM mysql.db_copy; DROP TABLE mysql.db_copy;   FLUSH PRIVILEGES; ```

Simply replace the OLD_HOST_NAME and NEW_HOST_NAME with the appropriate values. Most importantly, I didn’t have to know the passwords for each user to do this. This script simply copied the user info and gave them access from the new server.

Dell Tells Linux Users Where To Put It

Holy smokes. As Dell’s sales slump and stock remains flat, the famously unimaginative company is trying to tap into the Mob for ideas about what new shade of grey to deliver its hardware in next. And what did the Dell IdeaStorm mob say?

“Give us Linux!”

“Give Us OpenOffice.”

And how did Dell respond?

No. No. And, No.”

John Naughton reports on the story for The Guardian, explaining:

more than 85,000 people took the trouble to register with IdeaStorm in order to tell Mr Dell that they wanted him to ship his computers with Linux pre-installed. Moreover, 55,000 revealed that they would like the free open-source office software suite, OpenOffice, pre-installed on their shiny new Dell machines.

And all Michael Dell could say was that there are too many variants of Linux. Of course that doesn’t explain why the company, who’s biggest contribution to the technology world was an online store that allowed customers to chose computer configurations from a dizzying array of options, doesn’t simply allow customers to buy their PCs with no software at all.

Users vs. Network Printers in WinXP

It’s been a problem we’ve struggled with here for much longer than we should have, and it took a hotshot new guy in desktop support to show us the answer. But if you know the right magic, you can add a printer to Windows XP and make it available to all users. See, if you […] » about 300 words