Resetting a MySQL root password (or other password, for that matter) is easy enough if you have admin access to the server.
First go to the command line (Start > Run > "cmd") and type "mysqladmin" – and see a bunch of output text, you're good to go. otherwise you'le need to locate mysqladmin.exe and navigate to that folder.
Once there, enter the following command:
mysqladmin -u root password NEWPASSWORD
and you're good to go!
Importing a spreadsheet, or its comma separated (CSV) equivalent, into a MySQL database can be enourmously challenging and frustrating.
After many attempts at the solutions available through online searches, I determined that the most effective way was to save the spreadsheet in comma-separated format and write a PHP script to read the file row by row and insert the records in the database.
You'll need to adapt this script to your situation, the example below is keyed to the table I've been working with.
< ?php // --------------------------------------------------------------------------------------------------------------------- // IMPORT A .CSV FILE INTO A MYSQL DATABASE // --------------------------------------------------------------------------------------------------------------------- // Assumptions: // - The input file is a .xls spreadsheet saved as .csv, comma delimited with data fields not quoted // - The first line of the input file contains accurate column names // Note: // - All fields will be imported as string values or NULL, any requirement for other data types will have to wait // --------------------------------------------------------------------------------------------------------------------- // ~~~~~~~~~~~~~~~~~~~~~~~~~ GET INPUT ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ // // identify the input file $file1 = "test_packages.csv"; // read the file into an array of lines $lines = file($file1); // ~~~~~~~~~~~~~~~~~~~~~~~~ /get input ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ // include("includes/connect-string.inc.php"); // ~~~~~~~~~~~~~~~~~~~~~~~~~ CREATE ATTRIBUTE LIST ~~~~~~~~~~~~~~~~~~~~~~~~~ // // the first line should be the attribute names, so we want to read it and // create a list of attributes for the first part of the INSERT statements. $first_line = trim($lines[0]); // read the first line in the array, trimming whitespace as we go array_shift($lines); // remove first element from array - we don't want it read again. $values = explode(",",$first_line); // split the line into an array // now loop through the array, adding the elements to the values() section of the insert statement foreach ($values as &$value) { $attribute_list .= "'" . mysql_escape_string($value) . "',"; } // now lop off the trailing string... $attribute_list = substr($attribute_list,0,-1); echo "~~ $attribute_list ~~<br />"; // ~~~~~~~~~~~~~~~~~~~~~~~~~ /create attribute list ~~~~~~~~~~~~~~~~~~~~~~~~~ // // ~~~~~~~~~~~~~~~~~~~~~~~~~ PROCESS DATA LINES ~~~~~~~~~~~~~~~~~~~~~~~~~~~~ // foreach($lines as $line_num => $line) { // trim the line - any whitespace can complicate life later $line = trim($line); // explode the line into an array, splitting it on the commmas in the csv. $values = explode(",",$line); // prepare the beginning of the INSERT statement $insert_statement = "INSERT INTO packages ($attribute_list) VALUES ("; $insert_statement = "INSERT INTO packages (attribute_one,attribute_two,attribute_three,attribute_4,attribute_5) VALUES ("; // now loop through the array, adding the elements to the values() section of the insert statement foreach ($values as &$value) { // according to // <a href="http://bytes.com/groups/php/1146-insert-null-not-blank-into-mysql-php-script">http://bytes.com/groups/php/1146-insert-null-not-blank-into-mysql-php-script</a> // this will insert null for empty elements if ($value) { $insert_statement .= "'" . mysql_escape_string($value) . "'"; } else { $insert_statement .= "NULL"; // in the SQL query "NULL" will NOT be quoted } $insert_statement .= ","; } // now lop off the trailing string... $insert_statement = substr($insert_statement,0,-1); // ... and close the statement $insert_statement .= ");"; // now we'll either execute the statement or display it onscreen // (by default we only display onscreen for debugging - user must pass query string to execute) if ($_GET['execute'] == "1") { // if the execute instruction is passed in the query string, "?execute=true", execute the insert statement against the database $result = mysql_query($insert_statement); echo "Inserted record<br />"; } else { // otherwise, display the insert statement onscreen for debug purposes echo $insert_statement; echo "<br>"; } } // ~~~~~~~~~~~~~~~~~~~~~~~~~ /process data lines ~~~~~~~~~~~~~~~~~~~~~~~~~~~ // ? >
WordPress introduced a new password hashing method in version 2.5. For those who wished to piggyback authentication of another webapp onto WordPress, this can cause a problem. This plugin will restore MD5 password hashing for wordpress.
This plugin reverts storage of user passwords back to using MD5 hashing instead of the newer phpass hashing introduced in 2.5.
It is useful for people who need to maintain MD5 as the hashing type due to sharing of the WordPress user tables with other applications which require it.
If some of your passwords are already converted to phpass, do not fear. The next time those users log in to WordPress their passwords will be converted back to MD5.
