**This is an old revision of the document!** ----

====== MySQL Server: Installation & Management ====== The last fundamental piece of our web development environment is, of course, a database management system of choice: MySQL. ===== Install MySQL Server ===== Installing MySQL server is an easy task, simply issue the following commands in a Terminal window: <code> sudo apt-get install mysql-server </code> You will be asked to enter the password you wish to set for the mysql root user.\\ Once the install process has completed, verify that mysql is running using: <code> sudo service mysql status </code> Easy! ===== Let Your MySQL Server Be Accessed From the Outside ===== In order for other computers on your network to view the server you have created, you must first edit the "Bind Address". Begin by opening up Terminal to edit the my.cnf file. <code> sudo gedit /etc/mysql/my.cnf </code> Change the line <code> bind-address = 127.0.0.1 </code> Changing the 127.0.0.1 to your IP address. ===== In Case You Did Not Provide a Password ===== It is fundamental to protect access to you databases, setting a root password is essential to this point. In case the installer didn't ask you for a password, or you left it blank, you'll have to set it "manually", here is how:\\ Note that the same procedure can be used to **change the current root user's password**. <code> mysql -u root mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('yourpassword'); </code> Make sure to change yourpassword to a password of your choice.