English Deutsch Français Italiano Español Português 繁體中文 Bahasa Indonesia Tiếng Việt ภาษาไทย
All categories

Why I can't acces my database from client computer? The database which is available just information_schema. Though I have give all permission for the user to acces all database. Help me. Thanks.

2007-05-22 15:59:55 · 2 answers · asked by Anida E 1 in Computers & Internet Programming & Design

2 answers

Insufficient data to answer.
You should be doing something like:
function dbconnect()
{
$link = mysql_connect("localhost", "username", "password") or die(" Could not connect : " . mysql_error());
mysql_select_db("db_name") or die("Could not select database");
return($link);
}

Use the $link to close the data-base afterwards:
mysql_close($link);

2007-05-22 22:22:58 · answer #1 · answered by just "JR" 7 · 0 0

If the privileges are not working, try doing the following command.

FLUSH PRIVILEGES; This statement will refresh all the prermissions. Then Grant again your access privilege
GRANT ALL PRIVILEGES ON dbname.* TO user@host;

Background
==========
probably the access might be required in combination of system name + user id. (where system name is the client system name).

2007-05-22 17:49:09 · answer #2 · answered by Venkat K 2 · 0 0

fedest.com, questions and answers