Web-Site-Scripts.com - MySQL http://web-site-scripts.com/knowledge-base/category/82 en-us KnowlageBase RSS Generator How to set the root password on MySQL http://web-site-scripts.com/knowledge-base/article/AA-00692 There are two ways of setting a new password for the root user.

Setting Password via Command Line

Run "MySQL Command Line Client"


Then run this query. Replace "root_password" with the desired password for the root user first.

SET PASSWORD FOR 'root'@'localhost' = PASSWORD('root_password');

Setting Password via Instance Config Wizard

Run "MySQL Server Instance Config Wizard".


Go through several steps of configuration and it will ask if you would like to change the root password:


Complete the wizard and the password will be changed.

]]> Thu, 11 Aug 2011 16:16:45 +0000 http://web-site-scripts.com/knowledge-base/article/AA-00692 Database extensions for PHP (MySQL, Microsoft SQL) http://web-site-scripts.com/knowledge-base/article/AA-00595 KMP uses MySQL or MS SQL database to store most of its data. You would need to have a database driver (realized as a PHP extension) to enable KMP connect to a database server. Chose the link below which matches your web server operation system and desired database type.



]]> Mon, 29 Nov 2010 17:10:02 +0000 http://web-site-scripts.com/knowledge-base/article/AA-00595 Download MySQL http://web-site-scripts.com/knowledge-base/article/AA-00496 Knowledgebase Manager Pro uses MySQL for database storage. You can download MySQL Community Server for free from the official website.

Download installation package for your platform (e.g. MSI for Windows, RPM for RedHat Linux, etc). 

We recommend to use full MySQL package (without "-essential" or "-noinstall" in the filename).

Launch the MSI installer and it will guide you through the installation process.

MySQL settings

There is one option in MySQL settings that needs your attention. Check this article for details.



]]> Thu, 25 Feb 2010 12:41:11 +0000 http://web-site-scripts.com/knowledge-base/article/AA-00496