Database connecting error

Anon

Hi,

I have been using php/mysql on windows without any database passwords. I have been fine just using the commands:

$link= mysql_connect() or die ("error");
echo "Connected";

if (mysql_create_db ("db"))echo "DB created";
else printf ("Error", mysql_error());
.....
But now, I have been assigned a unix webspace, with a username/password.
The connection line seems to work, but when it comes to mysql_create_db, I get the error message: Access denied for user: '@' to database 'sharemap'.

So could anyone help by telling me how I need to reformat the code for unix?

Cheers, Jim.

Anon

When you say a username/password do you mean a database username/password or merely a shell account? Did your service provider/database admin already create a database for you? Your account may not have privelege to actually create NEW db's on the server.

Tim Frank

Anon

Like Tim says, check your ISP to see if you have the right at all to create your own DB.

Usually, a user is given one database with which you can play.

Use an SQL statement to create a table instead, "CREATE TABLE [table_name]..."

If however, you should be able to create your own DB:

either one of those two should work:

mysql_connect("localhost", "your_given_login", "your_given_password");

or:

mysql_connect ("", "your_given_login", "your_given_password");

To be sure you could add this line directly below the thing that fails:

echo "<p>" . mysql_error() . "</p>";

This will tell you (perhaps) in more detail what is wrong.

Anon

Thanks for your help everyone.

When I say username/password:
The username/password I have been allocated allows me to FTP to the webspace directory.
Howevere they appear to not to work in establishing a mysql connection.
But I have noticed now that I can connect to the mysql server using no username/password parameters, AND administer a single database named "test" without using any username/password. I achieve this by putting the mysql queries into a php file within the same webspace.
So I use the username/password to FTP the PHP files, and then I can administer the mysql "test" database from an unpassworded connection to the mysql file from those php files in my webspace.
Does this mean that outside users could also administer the database?

Cheers,