access denied

[onlayn]

can some1 help me with these errors?


Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'root'@'cossacks.x10hosting.com' (using password: NO) in /home/kendyo/public_html/tides.conf on line 6

Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in /home/kendyo/public_html/tides.conf on line 7


here is the code of tides.conf
---
$db_host = "localhost";
$db_name = "kendyo_cvsutides";
$db_user = "root";
$db_pass = "";
$db_link = mysql_connect($db_host,$db_user,$db_pass);
mysql_select_db($db_name,$db_link);
----

i will really appreciate if you could help me with this..
tnx

[Zubair]

Correct this

$db_host = "localhost";
$db_name = "kendyo_cvsutides";
$db_user = "kendyo_yourdbuser";
$db_pass = "yourpassword";
$db_link = mysql_connect($db_host,$db_user,$db_pass);
mysql_select_db($db_name,$db_link); 

Remember to create new user from database management in cpanel.. if you not created yet..

and then add user to database with all privileges

[onlayn]

still the same..i checked the dbase name and dbase user..


Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'kendyo_kendyo'@'cossacks.x10hosting.com' (using password: NO) in /home/kendyo/public_html/tides.conf on line 6

[gamesake]

I'm pretty sure you have to have a password.

[Zubair]

(using password: NO)

You are still not using any password.

did you create user in database management???

[onlayn]

yah.i did create a user in the dbase..

i can view it on my localhost even i dont have password..

[Zubair]

yah.i did create a user in the dbase..

i can view it on my localhost even i dont have password..

This is not possible.. because you can`t create user without password..




open this http://cossacks.x10hosting.com:2082/...sql/index.html to view the database management page

[onlayn]

okay..now i understand. tnx a lot

i still have one question left..
i want to import my dtabase but it always says

----#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'þ
' at line 1

the type of dbase is visual basic

[misson]

i want to import my dtabase

How are you attempting this? Are you using phpMyAdmin's import feature? (See also the many threads on this topic.)

but it always says
----#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'þ
' at line 1

It's rather hard to answer questions about code without seeing it. However, "þ" isn't used in any SQL keyword. Possibilities include: the text isn't an SQL query, there's an unquoted string.

the type of dbase is visual basic

Visual Basic is a programming language, not a database. Are you using something else as a database, or are you storing the data in a datastructure within the VM program?