MySQL Forums
Forum List  »  General

Re: access denied ''@'localhost' error
Posted by: Hydi Nabil
Date: July 10, 2013 08:10AM

this my test sample which gives me that error at insert into table step
i'v added $server_connect to mysql_query, but still gives me the same error
-------------
<?php
/**
* @author Hydi Nabil
* @copyright 2013
*/
// ====================================================================
$db_name="hydi";
$server_connect=mysql_connect('localhost', 'root', 'nabil');
// ====================================================================
$db_drop=mysql_query("DROP DATABASE hydi ", $server_connect);
$db_create=mysql_query("CREATE DATABASE hydi ", $server_connect);
$tb_create=mysql_query("CREATE TABLE hydi.persons (FirstName CHAR(30),LastName CHAR(30),Age INT)", $server_connect);
// ====================================================================
$db_select=mysql_select_db("hydi", $server_connect);
$db_close=mysql_close($server_connect);
// ====================================================================
// connect database
if (!$server_connect)
{ die('Could not connect: ' . mysql_error()); }
// end
// ====================================================================
// drop database
if ($db_drop)
{ echo " Database ", $db_name, " was successfully dropped "; }
else
{ die(' Error dropping database: ' . mysql_error()); }
//mysql_query('FLUSH PRIVILEGES');
// end
// =====================================================================
// create db
if ($db_create)
{ echo " Database ", $db_name, " created successfully "; }
else
{ die('Error creating database: ' . mysql_error()); }
// end
// ====================================================================
if ($tb_create)
{ echo " Table persons created successfully "; }
else
{ die('Error creating table persons : ' . mysql_error()); }
// end
// ====================================================================
// inserting row
if ($db_select)
{ echo " database ", $db_name, " selected successfully "; }
else
{ die('Error selecting database: ' . mysql_error()); }

if (mysql_query("INSERT INTO hydi.persons (FirstName,LastName,Age) VALUES ('hydi','nabil',34)"))
{ echo " row inserted successfully "; }
else
{ die(' Error inserting row : ' . mysql_error()); }
// end
// =====================================================================
if ($db_close)
{ echo " database closed successfully "; }
else
{ die('Error closing database : ' . mysql_error()); }
// end
// =====================================================================
?>

Options: ReplyQuote


Subject
Written By
Posted
Re: access denied ''@'localhost' error
July 10, 2013 08:10AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.