Temporary Table Problem - Help

[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 connection code below. I have no problem creating the temp table with
the same sql syntax directly in the mysql command interface and no
problem creating a regular table using php?

The sql I'm trying to execute is in the following code

$dblink= mysql_connect('localhost','pi', 'plant') or die (PProblem
with My SQL connection./P\n) ;
mysql_select_db('plant_inventory') or die (PProblem with connection
to the database: plant_inventory./P\n);

$sql = CREATE  temporary TABLE tmpInventory ;
$sql .=  SELECT * FROM inventory WHERE 1=0;;
$create_tmp = mysql_query($sql) or $err=(temp table not created);


Any ideas why this might be happening?



Anya Miretsky
Computer Technology Dept.
Brooklyn Botanic Garden
1000 Washington Avenue
Brooklyn, NY  11225

(718)623-7265
[EMAIL PROTECTED] 

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Root user Access denied - Please Help!

[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
% mysqladmin -u root status
% mysqladmin -u root reload

I think what I should have done is typed - update user SET password =
PASSWORD(somepassword) where user =root.

Now I can't get into mysql at all as root, with the password I set.

I get the error message Access denied for user 'root@localhost' (using
password =YES)

I have tried to restart mysql with the --skip-grant-tables option but I
still can't get in as root?

How do I fix this? Can anyone help? 


Anya Miretsky
Computer Technology Dept.
Brooklyn Botanic Garden
1000 Washington Avenue
Brooklyn, NY  11225

(718)623-7265
[EMAIL PROTECTED] 

-
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

Root user Access denied - Please Help

[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 % mysqladmin -u root status % mysqladmin -u root reload

I think what I should have done is typed - update user SET password =
PASSWORD(somepassword) where user =root.

Now I can't get into mysql at all as root, with the password I set.

I get the error message Access denied for user 'root@localhost' (using
password =YES)

I have tried to restart mysql with the --skip-grant-tables option but I
still can't get in as root?

How do I fix this? Can anyone help? 

Anya Miretsky
Computer Technology Dept.
Brooklyn Botanic Garden
1000 Washington Avenue
Brooklyn, NY  11225

(718)623-7265
[EMAIL PROTECTED] 

-
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

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

[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

(718)623-7265
[EMAIL PROTECTED] 

-
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

Left Join problem - Please Help

[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 I am doing wrong? This is my first time using Mysql,
so if this isn't the right list to post on, please tell me where I can post
beginner mysql questions.

Thanks for your help in advance.

Anya Miretsky
Computer Technology Dept.
Brooklyn Botanic Garden
1000 Washington Avenue
Brooklyn, NY  11225

(718)623-7265
[EMAIL PROTECTED] 

-
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