Question: I am completely new to forecasting and I am working with arrears figures and collection rates and have been asked to produce a forecast of performance over the next 12 months.
I have access to Excel and SQL Server - can anyone recommend an accurate method to complete this?
I need figures as opposed to graphs.

Answer: 
If you are very new with MySQL I recommended to install phpMyAdmin on your server to manage your databases and privileges. 

---

**Solution 1 phpMyAdmin:**

Login to your server console using root and run the following commands:

```
rpm -Uvh http://rpms.famillecollet.com/enterprise/remi-release-6.rpm 

```

then 

```
yum --enablerepo=remi install phpMyAdmin

```

Finally, edit configurations to allow access.

```
nano /etc/httpd/conf.d/phpMyAdmin.conf 

```

Search for `127.0.0.1` and replace with your server IP address 

Final command restart Apache:

```
service httpd restart

```

Now access phpMyAdmin from browser using root information:

<http://serverIP/phpMyAdmin/>

---

**Or to fix your issue (restore MySQL password), follow the commands below:**

```
sudo /etc/init.d/mysql stop

```

then

```
sudo /etc/init.d/mysqld stop

```

**Next** we need to start MySQL in safe mode - that is to say, we will start MySQL but skip the user privileges table. Again, note that you will need to have sudo access for these commands so you don't need to worry about any user being able to reset the MySQL root password:

```
sudo mysqld_safe --skip-grant-tables &

```

All we need to do now is to log into MySQL and set the password.

```
mysql -u root

```

**Note:** No password is required at this stage as when we started MySQL we skipped the user privileges table.

**Next** instruct MySQL which database to use:

```
use mysql;

```

Enter the new password for the root user as follows:

```
update user set password=PASSWORD("mynewpassword") where User='root';

```

and finally, flush the privileges:

```
flush privileges;

```

Now the password has been reset, we need to restart MySQL by logging out:

```
quit

sudo /etc/init.d/mysqld stop

sudo /etc/init.d/mysql start

```

Test the new password by logging in:

```
mysql -u root -p

```

You will be prompted for your new password.
Please check "/root/.mysql\_secret" file.
root's password is in this file.

like this:

```
sudo cat /root/.mysql_secret

```