Temporary Table Problem - Help

2003-08-14 Thread Miretsky, Anya
Hi, I'm running mysql version 4.0.13 and trying to create a temporary table from a php script. For some reason, even though I have the permission set up correctly, I can't seem to create a temporary table from the script. The permission say that create_tmp_table_priv=Y for the user in my connectio

Root user Access denied - Please Help

2002-05-22 Thread Miretsky, Anya
I tried to create a password for the root user in a new installation of MySQL by typing % mysql -u root mysql Then typing and update statement like > Update user set password = "somepassword" where user="root"; After doing this I typed because I could still get into mysql without a password % my

Root user Access denied - Please Help!

2002-05-22 Thread Miretsky, Anya
I tried to create a password for the root user in a new installation of MySQL by typing % mysql -u root mysql Then typing and update statement like > Update user set password = "somepassword" where user="root"; After doing this I typed because I could still get into mysql without a password % my

Help Restoring a MySQLdumped database...????

2002-02-25 Thread Miretsky, Anya
How do I restore a Mysqldump of a database? I've found documentation on how to backup a db and have done but I can't figure out how to create a new db from my dump file? Please help. thanks Anya Miretsky Computer Technology Dept. Brooklyn Botanic Garden 1000 Washington Avenue Brooklyn, NY 11225

Left Join problem - Please Help

2002-02-15 Thread Miretsky, Anya
Whenever I try to issue a query which has a left join for two tables and a where clause for a column in the second table that is a varchar the query runs indefinitely. If I change the where clause to search on a numeric type column the query runs and returns expected values. Does anyone know what