PHP Session error on linux

JasonBright · 03-03-2011, 04:19 AM

Hi, I'm new to hosting websites on linux servers and I saw that it's a bit different than windows servers.

I have a website that works perfectly on local, but that doesn't work anymore on my webhost.

The exact error message is:

Quote:

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'syste136'@'localhost' (using password: NO) in /home/syste136/public_html/mescommandes.php on line 16
Could not connect: Access denied for user 'syste136'@'localhost' (using password: NO)

Now I saw on internet that a php.ini file would probably solve this issue, but I really don't have time to learn how it works.

Do any of you have an ini file ready for use ?

Smokey_justme · 03-03-2011, 04:45 AM

This has nothing to do with Windows or Linux.

Do you have the mysql user "syste136"?

You didn't use any password... Is this how the user was made?

Do you have just a simple "mysql_connect()" line in you php files and expect to use the default user and password from php.ini.

The unrecommanded way of connecting to the database is by editing your php.ini. Basically you need to set up at least "mysql.default_user=" and "mysql.default_password=". This is however a global setting and is recommanded only if you use just one custom made web-site.

The recommanded way is by passing these values on every attept to connect. Like this "mysql_connect(host,user,name)" (assuming your not using mysqli).

One last recommandation, if you don't mind: Make time. This is a simple issue. If you don't have time for something like this than probably you don't have time and ignored a lot of other stuff too (some may be with harmfull results).

JasonBright · 03-03-2011, 06:53 AM

Quote:

Originally Posted by Smokey_justme

Do you have the mysql user "syste136"?

You didn't use any password... Is this how the user was made?

No, I don't have a "syste136" but a "syste136_admin". I don't understand that either.
But I do have a password.

Quote:

Originally Posted by Smokey_justme

Do you have just a simple "mysql_connect()" line in you php files and expect to use the default user and password from php.ini.

No, I use session variables for that, like that:

Code:

//Starts session
@session_start();

//Database settings [Server]
$_SESSION['host'] = '127.0.0.1';
$_SESSION['database'] = 'database';
$_SESSION['user'] = 'syste136_admin';
$_SESSION['sql_password'] = 'pass';

Quote:

Originally Posted by Smokey_justme

One last recommandation, if you don't mind: Make time. This is a simple issue. If you don't have time for something like this than probably you don't have time and ignored a lot of other stuff too (some may be with harmfull results).

Well I don't have time to look at it now because of the due date for the project, but I sure will make the time once it's finished !