Access denied - Creating MySQL

[bokhalifa]

I am want to create a mySQL database from a PHP script using mysql_create_db. when I test the scripts on my local computer it works fine and creates the database, but when I upload the script to my webhost the script cant create the database it gets a "Access Denied to..." error.

I have unlimeted mysql in I have Dedicated Server, I can create them manualy from the CPANEL but cant create them with my php script.

What can I do to be able to create mySQL databases from a PHP Script.

Thanks 🙂

[bokhalifa]

up🙂

[mrhappiness]

even if you have unlimited databases it is possible that you can't create them via php

normally php get's executed with the same user your webserver runs (let's call him wwwrun)
this user normally has very less rights

if you create a database using confixx or whatever you can use teh database is created using perl or something like that
important fact is that this script does not run as user wwwrun but as user your_loginname_you_use_for_accessing_your_ftp_for_example