Pages

Sunday 21 April 2013

Mysql2 installation and password reset


MySQL is a powerful database management system used for organizing and retrieving data.

To install MySQL, open terminal and type in these commands:

         sudo apt-get update
         sudo apt-get install mysql-server


During the installation, MySQL will ask you to set a root password. If you miss the chance to set the password while the program is installing, it is very easy to set the password later from within the MySQL shell with this command:

UPDATE mysql.user SET Password = PASSWORD('password') WHERE User = 'root';


No comments:

Post a Comment