Please i need assistance, MYSQL ACCESS ERROR

I

iyobosa

Newbie

Jul 14, 2013

35

7

• Aug 2, 2013

• #1

i have a php script, which i downloaded somewhere for auto-blog-commenting. Added mysql user,pass and database name and i uploaded it to my server host. I keep on getting error report page:

Warning: mysql_connect() [function.mysql-connect]: Access denied for username (using password: YES) in ...line 10

Warning: mysql_select_db() [function.mysql-connect]: Access denied for user 'root'(at)'localhost' (using password: NO) in... line 11

Warning: mysql_select_db() [function.mysql-connect]: A link to the server could not be established in ...line 11

i don't know what to do, as am not too familiar with this, but i understand that my user,pass and database name are correct.
please send your helpful response!

 

WORK@HOME

Senior Member

Apr 25, 2013

1,013

479

• Aug 2, 2013

• #2

Do you have it setup as:

databasename_name
password
databaseuser_user

Also you may need to put a / at the end of your URL

 

K

kuerten

Newbie

Apr 23, 2013

41

13

• Aug 2, 2013

• #3

iyobosa said:

i don't know what to do, as am not too familiar with this, but i understand that my user,pass and database name are correct.

Click to expand...

No they aren't... Double check

 

makinsales

Regular Member

Jul 23, 2011

368

284

• Aug 2, 2013

• #4

your username, pass, and or server aren't correct. Without seeing the code, cant help.

PHP does a good job telling you where to look.. Problems are on line 10, and line 11..

Did you setup a mysql database?

 

M

mteun

Newbie

Jul 12, 2013

19

1

• Aug 8, 2013

• #5

First, you need to setup MySQL database correctly, test it first using the MySQL client tool, then link it using PHP code.

 

Q

qlwik

Newbie

Aug 18, 2011

48

10

• Aug 8, 2013

• #6

Maybe MySQL server address is wrong?

 

M

methylenebl

Newbie

Aug 6, 2013

22

5

• Aug 21, 2013

• #7

Cant really say much more without being able to view the actual code but it seems that the information you are using to access the database is wrong. or the database is refusing connections which would be a mysql config error.

 

V

ventr

Newbie

Jan 29, 2013

28

4

• Aug 21, 2013

• #8

Also chech if your server can connect to the DB server. Sometimes you need to add another user like mike (at) 123.11.12.13 with privileges to certain DB's to be able to connect to mysql server from ip 123.11.12.13