1. Login to your server via SSH
2. Proceed with Scenerio 1 or Scenerio 2 below:
Scenerio 1: If your server has no root password, open up the MySQL: # mysql
Scenerio 2: If your server has a root password, open up MySQL: # mysql -uroot -p
Press the enter key and input your existing MySQL password (our OwnCloud servers use changeme123!)
3. Enter the following at the mysql> prompt: FLUSH PRIVILEGES;
4. Enter the following at the mysql> prompt: SET PASSWORD FOR 'root'@'localhost' = PASSWORD('YourNewPass');