You can change the MySQL root password either with the mysqladmin command or through an SQL query.
You probably tried to login with your root password and got this error: Access denied for user 'root'@'localhost'
Consider the following table schema:
Let's say you want to connect to a remote MySQL server from your home computer. Consider the following configuration: