install Problem with hosted account and MySQL 5.0.18

[estbiostudent]

I have a "deluxe hosting" account with godaddy.com and I am trying to install SugarCRM version 4.5.0d.


According to the phpinfo() return I have php version 5.1.4 and mysql version 5.0.18. During step 3 of the install I receive the following error:

"MySQL version 4.0.27 is not supported. Only MySQL 4.1.x and higher is supported."

The system is pruportedly a Linux system 2.4.21-40.ELsmp #1 SMP Thu Feb 2 22:22:39 EST 2006 i686
web server is Apache/1.3.33


The hosting system is such that creation of new databases must be done through the hosting software "control panel". and can not be done directly via php. additionally creation of new users can not be done outisde of this "contol panel". based on my experience with other software, tables and fields within tables can be created, but only on existing databases and only through an existing account. Additionally new accounts can not be created for an individual database either through the "control panel" or otherwise.

I have entered the correct host name, database name, username and password in the fields for step 3 and receieved the above error.
If I enter a nonsense username and password with the correct database name, i receive the folowing error:
SugarCRM database user name and/or password is invalid (Error 1045: Access denied for user
If I enter a nonsense database with the correct username and password I receive the following error:
Database specified does not exist
If i enter a nonsense database and nonsense username/password I receive error 1045 again.

Any help would be greatly appreciated

[kpit]

I have used godaddy for SugarCRM. Unfortunately without virtual dedicated or dedicated server you will not be able to upgrade mysql as the latest version of SugarCRM requires you to have at least MySQL 4.1.2 or greater. You could install SugarCRM 4.2.1 and it will mostly work in shared hosting.

These are some of the problems with GoDaddy Shared hosting.

• Security is tight on the servers outgoing ports are blocked.
• You can not use SMTP email to send emails you have to use sendmail.
• You are limited in Sending 250 emails a day per email address that is hosted with GoDaddy. This limit can be raised by paying for it.
• Inbound emails can not access email servers that are not hosted by GoDaddy on a shared host due to port blocking.
• No cron jobs available unless you have a local machine call out every minute to the cron.php file.

Good things about GoDaddy:

• Good tech support
• severs are up 99.99% of the time.
• Severs are generally secure.
• Best of all Price is low!

[estbiostudent]

I understand that SugarCRM won't work with older versions of mysql... However the version i'm running is apparently 5.0.18, as this is what phpinfo() returns....



et