Re: access denied ''@'localhost' error
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
// =====================================================================
?>