mySQL connection error

[Danno7]

Can't find the same error on search, so I will ask you:

Warning: Access denied for user: '[email protected]' (Using password: YES) in /usr44/home/hwdesign/public_html/php_test/install.php on line 175

Warning: MySQL Connection Failed: Access denied for user: '[email protected]' (Using password: YES) in /usr44/home/hwdesign/public_html/php_test/install.php on line 175
Cannot connect to database server with given data

I have been able to get connected with a myAdmin connection and just localhost, but the install script says I needed to modify it to localhost.addr.com and this is what I get...

Any Help?

[Daniel D.]

Check your password and username, it says that it can't connect with the given data.

[Danno7]

I have.  It works with the mySQLAdmin, but not with this...the mySQLAdmin works with just 'localhost'

[Danno7]

Here is the error when I use the 'localhost' reference instead:

Warning: Can't connect to local MySQL server through socket 'please specify localhost.addr.com as the hostname' (2) in /usr44/home/hwdesign/public_html/yabbse/install.php on line 175

Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket 'please specify localhost.addr.com as the hostname' (2) in /usr44/home/hwdesign/public_html/yabbse/install.php on line 175
Cannot connect to database server with given data

[mediman]

instead of localhost you have to use sql.myserver.com or anything like this!

if you don´t know the mysql server adress, so ask your isp!

[Danno7]

the email says that  I should use mysql.addr.com and I get:

YaBB SE Installer

Warning: Access denied for user: '[email protected]' (Using password: YES) in /usr44/home/hwdesign/public_html/yabbse/install.php on line 175

Warning: MySQL Connection Failed: Access denied for user: '[email protected]' (Using password: YES) in /usr44/home/hwdesign/public_html/yabbse/install.php on line 175
Cannot connect to database server with given data  

[mediman]

which version? 100 or 110?

[Danno7]

100 - it said that safe mode was disabled

[mediman]

in line 175 in install.php (V 1.0.0 no safe) you will find this

Code Select Expand

$linkid = mysql_connect($dbserver, $dbuser, $dbpassword);
so if your dbserver mysql.addr.com and username and password ok, there can only 2 things wrong!

1. you have no db created (install.php will not do that for you)!

2. your account is disabled or the mysql-server is offline!

[mediman]

you are right with mysql.addr.com look here!

please, first create a db with any name, then start the install.php again! install.php will ask you a name of an exististing db! all was install.php does is write in this db tables and inserts!

check your mysql server and database with tihs script:

Code Select Expand

<?php$DBName = "(your data base name)";$DBUser = "(your data base user name)";$DBPass = "(your data base password)";$DBHost = "mysql.addr.com";$link = mysql_connect ( $DBHost, $DBUser, $DBPass )or die ( "Could notconnect<br><br>" );print ( "Connected to mysql server successfully<br><br>" );mysql_select_db ( $DBName )or die ( "Could not select database<br><br>" );print ( "Connected to database successfully<br><br>" );mysql_close ( $link );?>

mediman

[Danno7]

Got it.  The host has not activated the account properly.  I used a different database and it worked.  Now I get a login issue...will post as new.  Thanks for the help!!