simoneg
Posts: 11
|
| Posted: 01/25/2006, 12:59 PM |
|
I have a MySql server on my local machine and a duplicate database on mybesthost.com mysql server.
The connection works fine on local but I am not able to connect to remote server
this is the error:
Warning: mysql_connect(): Access denied for user: 'simgiu@mybesthost.com' (Using password: YES) in /home/www/simgiu.mybesthost.com/db_mysql.php on line 99
Database error: cannot connect to Database Access denied for user: 'simgiu@mybesthost.com' (Using password: YES)
MySQL Error
Session halted.
this are the parameters:
database name: simgiu_jam
host: mybesthost.com
login: simgiu
pw: ********
how can I configure connection to work ??
thanks ...
|
 |
 |
peterr
Posts: 5971
|
| Posted: 01/25/2006, 1:20 PM |
|
You may need to configure security in MySQL to specifically allow connections for the host "mybesthost.com".
Though by default MySQL should allow connections from localhost, so I would leave the host field blank/empty since your database is on the same server as PHP programs.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
simoneg
Posts: 11
|
| Posted: 01/25/2006, 3:43 PM |
|
Quote peterr:
You may need to configure security in MySQL to specifically allow connections for the host "mybesthost.com".
I really don't knok how to do this !!
Quote peterr:
... I would leave the host field blank/empty since your database is on the same server as PHP programs.
I did this and not the error is ...
Warning: mysql_pconnect(): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) in /home/www/simgiu.mybesthost.com/db_mysql.php on line 97
Database error: cannot connect to Database Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
MySQL Error
Session halted.[/I]
|
|
|
|
peterr
Posts: 5971
|
| Posted: 01/25/2006, 3:53 PM |
|
Hmm, this could be some MySQL configuration issue, or I just don't know the answer. Maybe someone else could help.
Though please also try:
1. Making both Host and Port/Socket blank.
or
2. Seting the Host to localhost , and Port/Socket to 3306.
I would also recommed that you find out the proper MySQL connection settings from your Web hosting company and test it with a small PHP program, without using CCS. Once you know that you can connect to MySQL then you can put those settings into CCS.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
simoneg
Posts: 11
|
| Posted: 01/25/2006, 4:20 PM |
|
These are results:
Quote peterr:
1. Making both Host and Port/Socket blank
Parse error: parse error in /home/www/simgiu.mybesthost.com/Common.php on line 1478
Fatal error: Class clsmessaggidatasource: Cannot inherit from undefined class clsdbconnessionejam in /home/www/simgiu.mybesthost.com/messaggi.php on line 340
Quote :
2. Seting the Host to localhost , and Port/Socket to 3306.
Warning: mysql_pconnect(): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) in /home/www/simgiu.mybesthost.com/db_mysql.php on line 97
Database error: cannot connect to Database Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
MySQL Error
Session halted.
|
|
|
|
peterr
Posts: 5971
|
| Posted: 01/25/2006, 5:00 PM |
|
OK. One more idea:
Try seting the Host to 127.0.0.1 , and Port/Socket to 3306.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
simoneg
Posts: 11
|
| Posted: 01/25/2006, 5:18 PM |
|
Quote peterr:
OK. One more idea:
Try seting the Host to 127.0.0.1 , and Port/Socket to 3306.
Warning: mysql_pconnect(): Access denied for user: 'simgiu_jam@localhost' (Using password: YES) in /home/www/simgiu.mybesthost.com/db_mysql.php on line 97
Database error: cannot connect to Database Access denied for user: 'simgiu_jam@localhost' (Using password: YES)
MySQL Error
Session halted.
|
|
|
|
peterr
Posts: 5971
|
| Posted: 01/25/2006, 5:44 PM |
|
OK, the problem looks resolved now because this is more common message indicating that you are connecting to MySQL properly, just with a wrong login/password. So you will need to use the correct login and password, or set it up in MySQL. This error message is also discussed on half a million pages on the Internet, so you should have no problem finding an answer  http://www.google.com/search?hl=en&lr=&safe=off&q=MySQL...er%22+localhost
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
