Dan Atrill's blog site
I was hunting for a few easy to follow commands for command line MySQL having been using Webmin and phpmyadmin for a while now. This site http://www.pantz.org/software/mysql/mysqlcommands.html came up trumps. Lots of other useful sysadmin stuff on there. Thanks pantz, you saved me hours.
Wed, December 16 2009 » MySQL » No Comments
In very few lines it’s possible to search and replace text in MySQL:
UPDATE table_name SET column_name = replace(column_name,”find_this”,”replace_with_this”)
Thanks to Torkil Johnsen’s Search and replace in MySQL article
Wed, August 8 2007 » MySQL » No Comments
Eventually the truth appeared in the guise of config files in Moveable Type and phpMyAdmin that contained out of date passwords. Which means that the previous entry: MySQL and the lost root password – part two was a little misleading. Flushing passwords and running MySQL in ’safe mode’, skipping grant tables, simply avoids the [...]
Sat, October 1 2005 » MySQL » No Comments
OK, so two days back from a wonderful honeymoon and a little rusty on the system, I did ’something’ relating to investigating an old Moveable Type installation which wasn’t working, in phpmyadmin which in turn knocked on to some other applications all based around MySQL. The gist being that I had a wrong password for [...]
Thu, August 25 2005 » MySQL » No Comments
OK – so far so good. Flushing passwords worked OK. The next bit – setting a root password again might cause the same error. But it’s working locally, away from the internet, so for today it stays.
Note: restarting the mysqld_safe process requires killing the mysqld process that is running.
Thu, August 26 2004 » MySQL » No Comments
Things that might not work as you expect in MySQL have been collected together at this site devoted to things database: MySQL Gotchas
Sat, May 29 2004 » MySQL » Comments Off