MySQL errors after installing FOG

Recently, I converted a decently spec’d terminal server into an ESXi server after doing a P2V on the TS. After that, it was time to play. I installed a fresh copy of Ubuntu 9.04 server and then installed FOG. If you don’t know what FOG is, you may want to read FOG’s overview here. Once I got it all installed I kept getting an error when connecting to the web-based management interface. I have pasted in the error and resolution below, including credit on the source of the resolution.


Warning: mysql_connect() [function.mysql-connect]: Access denied for user ‘root’@’localhost’ (using password: NO) in /var/www/fog/management/index.php on line 34
Unable to connect to Database

I am not sure what else to tell you from here, I am at a standstill. Thanks for any help you can offer up.

RE: Problem with mySQL database after install
By: microleaks (microleaksProject AdminAccepting Donations) – 2008-02-06 15:52
All you need to do is go to /var/www/html/fog/commons/config.php and change the mysql password in that file you match whatever you set it as.

MySQL – Poor Man’s Database

MySQL is a relational database management system that runs on a wide variety of platforms including MS Windows. There is an estimated install base of over 11 million. Practical operation is the same as other SQL server applications, whereas multi-user sessions can simultaneously access stored data.
Previously owned as a subsidiary of Sun Microsystems, as of April 20th, 2009, Oracle has announced intentions to purchase Sun. Oracle Buys Sun
One of the most popular uses of MySQL is for web applications and is used by many high transaction websites such Facebook. MySQL is fully OBDC compliant as well.
MySQL has consistantly be shown to be very fast performing and highly reliable, both critical to use in a production business environment.
Currently MySQl is available in two license formats: Community Server and Enterprise Subscription.
For the minimal annual fee of $599/server/year Enterprise offers a consistent monthly and quarterly release schedule. Compare to other sql server apps and you will quickly appreciate the value.
Community Server is available for download at no charge and has sporadic updates.