Too many connections in MariaDB after CI and PHP upgrade

If you upgraded xampp then you need to redo your database settings xampp will over write all
of the previous settings

You can re-setup your database by doing the following, all of your databases will be gone with 
an xampp upgrade!

1) Exit your MySQL Server
2) Edit your  C:\xampp\mysql\bin\my.ini
3) Add the below to the file.

Code:

# The MySQL server
[mysqld]
##
## SET PASSWORD FOR 'root'@'localhost' = PASSWORD('Your_new_password');
##
skip-grant-tables

4) Re-start your MySQL Server
5) Run phpMyAdmin - you should be able to get in now
6) Run the following SQL Query in phpMyAdmin

Code:

SET PASSWORD FOR 'root'@'localhost' = PASSWORD('Your_new_password');

7) Exit your MySQL Server
8) Edit C:\xampp\mysql\bin\my.ini
9) Remark out the skip-grant-tables ( #skip-grant-tables )
10) You should be good to go.

What did you Try? What did you Get? What did you Expect?

Joined CodeIgniter Community 2009.  ( Skype: insitfx )