Posts Tagged ‘MYSQL’

MySQL replication is quite straight forward. Here are the setup steps:

MySQL database has a handy and simple string function REPLACE() that allows table data with the matching string (from_string) to be replaced by new string (to_string). This is useful if there is need to search and replace a text string which affects many records or rows, such as change of company name, postcode, URL or […]

Recovering a lost Mysql root password

Posted: 11th August 2010 by Babar Shafiq in Security
Tags: , ,

Lost MySQL root password Recovery /etc/init.d/mysql stop mysqld_safe –skip-grant-tables & This stops MySQL and reloads it without the authentication (grant) tables, so we can connect to MySQL without a password. Beware this locks out all of your applications until the password reset process is completed. Now we need to go in an reset the password […]