MySQL Problems - Dev Articles

Dev Articles Community Forums Sponsor:

Stay one step ahead of the competition. Evaluate and give feedback on some of the hottest web development tools on the market today. Make your opinion heard! Click Here

February 8th, 2004, 10:53 AM

BrencelJ

Registered User

Join Date: Feb 2004

Posts: 6

Time spent in forums: < 1 sec
Reputation Power: 0

MySQL Problems

Can you help me with this errors:

Warning: mysql_connect(): Unknown MySQL Server Host 'root@localhost' (11001) in G:\htdocs\Game Page\mysql\povezava.php on line 2

Warning: Missing argument 2 for send_sql() in G:\htdocs\Game Page\mysql\funkcije.php on line 2
Unknown database 'ime_podatkovne_zbirke'

This are the programs:

PHP Code:


		
			
<?php

function send_sql($db,$sql)

{

if (! $res=mysql_db_query($db,$sql))

{

echo mysql_error();

exit;

}

return $res;

}

?>

PHP Code:


		
			
<?php

$link=mysql_connect("root@localhost","admin","zelva");

$db="ime_podatkovne_zbirke";

?>

PHP Code:


		
			
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">

<html>

<head>

<title>Untitled Document</title>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">

</head>

<body>

<?php

include ("funkcije.php");

include ("povezava.php");

$sql="...SQL-ukazi...";

If ($res=send_sql($db)){

echo "SQL-ukaz je bil izveden";

}

?>

</body>

</html>

February 9th, 2004, 06:53 AM

dhouston

Contributing User

Dev Articles Beginner (1000 - 1499 posts)

Join Date: May 2003

Location: Tennessee

Posts: 1,355

Time spent in forums: < 1 sec
Reputation Power: 7

Your server name needs to be just "localhost" rather than "root@localhost."

__________________
Please don't PM me asking for solutions outside the scope of a thread.
Keeping all responses in a thread stands to help others who come along later,
which is after all what this forum's all about.

February 9th, 2004, 08:48 AM

BrencelJ

Registered User

Join Date: Feb 2004

Posts: 6

Time spent in forums: < 1 sec
Reputation Power: 0

Now the error is like this

Quote:

Warning: mysql_connect(): Access denied for user: 'admin@localhost' (Using password: YES) in G:\htdocs\Game Page\mysql\povezava.php on line 2

Warning: Missing argument 2 for send_sql() in G:\htdocs\Game Page\mysql\funkcije.php on line 2
Unknown database 'ime_podatkovne_zbirke'

February 9th, 2004, 10:20 AM

dhouston

Contributing User

Join Date: May 2003

Location: Tennessee

Posts: 1,355

Time spent in forums: < 1 sec
Reputation Power: 7

Ok, so now you need to make sure that user is a valid user and has access to the database in question. Go to mysql.com and look up the syntax for "GRANT." You can also manually update the row for the given user in the mysql user database/table and flush privileges to force the changes.

February 9th, 2004, 11:42 AM

BrencelJ

Registered User

Join Date: Feb 2004

Posts: 6

Time spent in forums: < 1 sec
Reputation Power: 0

Could you be more specific becaus I'm new with this operation pleas.

Could you tell me what do I do with GRANT I foun it in mysql.com and is just a program what can I do with it or coud you tell me more specific how can I do this

Quote:

You can also manually update the row for the given user in the mysql user database/table and flush privileges to force the changes.

February 9th, 2004, 11:57 AM

dhouston

Contributing User

Join Date: May 2003

Location: Tennessee

Posts: 1,355

Time spent in forums: < 1 sec
Reputation Power: 7

Actually, it's not a program but a command. You need to log into your mysql server as the root user (or a user with grant privileges) and issue the grant command at the prompt. I presume you had to have either command line access or some other way of creating your database initially. Whatever utility you used should also allow you to modify privileges, either manually using the grant command or updating the user table. I don't think I can boil it down beyond that.

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread: