How to change your root MySQL password

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');

  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

Previewing your website before transferring it to your VPS - hosts file

Below is a guide to using the hosts file to preview your site before transferring / before DNS...

Connecting to your Linux server via SSH (Shell Access)

An SSH (Secure Shell) session is a useful means of direct communication with your Virtual Server,...

Text Editor on Linux

In order to edit files on the command line you will have to use a text editor.There are many text...

Start/stop web services - Apache, Postfix, MySQL, etc

You can restart application services via SSH. Below are some examples: [Redhat based...

Installing/updating packages on Debian/Ubuntu

Before you search/install a package please refresh the package list using this command - apt-get...