Hi all,
I have a MySQL database 'mydb' and I can perfectly access it via telnet. I
have one database and I have full access to it. I can't create user and
other databases, but its fine.
Problem is that I write a PHP script and I can't access my sql database
using that script! I got 'Access Denied' Error.
I've tried MySQL grant commands e.g.
Grant ALL PRIVILEGES
ON mydb.*
TO imran@%; (replaced % with my hostname etc. too)
command is executed properly.
Here is the PHP script:
include("passwords.php");
$openConn2db = mysql_connect( "$hostname:$port", "$username","$password" );
$dbSelected = mysql_select_db( $dbname, $openConn2db );
$result = mysql_db_query ($dbname,"select * from Girls");
while ($row = mysql_fetch_array ($result))
{
$sFace = $row["face"];
print("<tr><td><font face='Arial' size='1'>$sFace</font></td></tr>");
}
How can I configure mysql so I can access it with my web applications too,
not just telnet?
And anyone knows how to make mysql accessible via GUI clients like mascon or
myadmin etc.???? Some of my MySQL databases got accessible by them and some
just telnet? depending on different provides?
Merci a bunch!
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
