SQL DB won't connect even though database is set up properly.
I am moving my calendar from an old server to a new server. It is currently working with no problem on a server running
PHP ==> 4.4.0
MYSQL ==> 4.14
I connect to the db no problem by using the localhost for a server and user name and password that I setup on MYSQL.
In moving to the new server I am now using:
PHP ==> 5.1.2
MYSQL ==> 5.0.18
I setup a user on MYSQL by using the MYSQL utility. As root I entered the following in the command line mysql utility.
grant all privileges on *.* to <USERNAME>@localhost identified by '<PASSWORD>';
What I entered <USERNAME> and <PASSWORD> is what I ented in my setup username and passowrd.
I logged in via mysql login to verify that I can use that account.
When I change the setup in PHP Calendar for the mysql database, the setup page no longer fully loads. All I see is the header with my login name. I look at the source code and it ends the page on an open <TD> tag. I get no error message at all. It just stops creating the page.
It still works fine on my old server and I would like to bring that server down - however I have spent the last 3 hours trying to figure out why this is happening.
The main differences are the SQL and PHP versions - I made sure the user was setup on MYSQL. I also made sure I downloaded the PHP 5 version.
I am using the ioncube decoder.
I am getting ready to punt - any help will be apprecited!