Getting started with MySQL

• Install MySQL. If necessary, install mysql-server.
• Start MySQL (/etc/init.d/mysqld start)
• Setup root password

        shell> mysql -u root
        mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('newpwd‘);
        mysql> SET PASSWORD FOR 'root'@'host_name‘ = PASSWORD(’newpwd‘);
      

• Create a normal user

        mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'localhost'
        ->     IDENTIFIED BY 'some_pass'
       

• Don't forget to flush privileges

        mysql> FLUSH PRIVILEGES;