Ersin Acar

Stop the mysqld daemon process. Start the mysqld daemon process with the–skip-grant-tables option. Start the mysql client with the -u rootoption. Execute the UPDATE mysql.user SET Password=PASSWORD(‘password’) WHERE User=’root’; Execute the FLUSH PRIVILEGES;command. These steps reset the password for the “root” account to “password”. To change the password for a different account, or to set a different password, [...]

Part 1 of this article looked at the fulltext index, and how to search on it using an ordinary MATCH() AGAINST(). Even more powerful, (although only available on the newer MySQL version 4), is the ability to do a boolean search. Part 2 of this article examines the possibilities. You’ll use the same table you [...]

One of the more useful MySQL features is the ability to search for text using a FULLTEXT index. Currently this is only available if you use the MyISAM table type (which is the default table type, so if you don’t know what table type you’re using, it’ll most likely be MyISAM). A fulltext index can [...]

Sometimes, especially when moving data from one server to another, you might find that you have your MySQL database incorrectly encoded. Problem with this first show itself if you have the database and encoded in one charset set to display your website in another. If this is the case then you will find strange characters [...]

To find duplicate values you need to use the MySQL COUNT() function and then pick out all of the counts that are greater than one. SELECT VALUE,COUNT(VALUE) AS COUNT FROM test GROUP BY VALUE HAVING (COUNT(VALUE) > 1) ORDER BY COUNT DESC; Conversely you can also select the rows that only have a single entry.

Sometimes, especially when moving data from one server to another, you might find that you have encoded your MySQL database incorrectly. This problem with first show itself if you have the database encoded in one charset and your website set to display in another. If this is the case then you will find strange characters [...]