very basic connenction prob

[Anon]

i can't add data to my table.

this reeks of a dum question but i don't want to read the whole fucking manual to figure it out.

i can connect to MYSQL from the unix prompt with
pmysql -u meyerj -psomen2funny

but it tells me there are no databases. i set the host and get the same result. MySQL Web Interface lets me connect to my database and add a table and set the schemia but i cannot add any data.

any ideas why not?

please?

$host = "mysql.oit.pdx.edu";
$user = "meyerj";
$password = "somen2funny"; //that's not really it
$database = "Hhood";
$table = "links";

[mitchell]

I'm not quite sure what the problem is but when u granted access to the user did u do...

grant SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER on mydatabase.* to username@localhost identified by 'password';

AND

grant SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER on mydatabase.* to username@% identified by 'password';

and then flushed the privileges? I remember that u need to do both to allow access.

If this doesn't fix it, exactly wot error message are u getting from the MySQL server?

Mitchell

[Anon]

it was set up by a unix admin at my university so i couldn't speak to the account set up. on errors, from the web end i don't get any errors. it just says no data exists after the script runs code like the following:

$query = "INSERT INTO $table VALUES('$name', '$email', '$website', '$title', '$description', '$category')";
$result = MYSQL_QUERY($query);

working in the shell at pmysql (not mysql?) it tells me it can't find any databases. $ "no databases!"

-appreciate your help.

[mrskhris]

dummy, but necessary question: did you do mysql_db_select before performing any inserts/selects/etc? The same for command line: you have to select the database with "use db_name" command