Re: Problem with GRANT ... 'user'@'%'

Hi, Miguel Cardenas wrote: Hello list I have a problem adding a user with host '%' ... *** If I add a user with host '%' when trying to connect get this error: ERROR 1045 (28000): Access denied for user 'myuser'@'localhost' (using password: YES) *** If I add the same user with localhost it

Problem with GRANT ... 'user'@'%'

Hello list I have a problem adding a user with host '%' ... *** If I add a user with host '%' when trying to connect get this error: ERROR 1045 (28000): Access denied for user 'myuser'@'localhost' (using password: YES) *** If I add the same user with localhost it connects and works fine... My

Re: InnoDB Disabled?

Found the problem. After searching for a while, I found where someone deleted the ib_logfile*.* in the data directory. I did that, and that cleaned it up. Jesse - Original Message - From: "Jesse" <[EMAIL PROTECTED]> To: "MySQL List" Sent: Saturday, May 19, 2007 4:22 PM Subject: In

InnoDB Disabled?

I'm running version 5.0.22-community-nt of MySQL. For some reason, InnoDB is disabled. I have it installed on my XP Pro machine, and it's working fine, and one on a Windows 2003 server, which is working fine, and another on a Windows 2003 server, which is the one with a problem. At one point

Re: Create Foreign Key Issue

Check the output of SHOW INNODB STATUS. You should see a more helpful error message there. This shows the following information: LATEST FOREIGN KEY ERROR 070519 15:15:28 Error in foreign key constraint of table woodturners/#sql-2dc_1e: FOREIGN

Re: need help...LOAD DATA INFILE

Also friends, When i see this data in the vi editor it looks like this " Other Home DÃ(c)cor " Just wanted to give information. Please help me. regards anandkl On 5/19/07, Ananda Kumar <[EMAIL PROTECTED]> wrote: Hi All, I am loading data into mysql database using LOAD DATA INFILE. After the l

need help...LOAD DATA INFILE

Hi All, I am loading data into mysql database using LOAD DATA INFILE. After the load i am getting this error. Warning | 1366 | Incorrect string value: '\xE9cor' for column 'CATEGORY_NAME' at row 2137 . My database character set is as below character_set_database | utf8 character_set_client

Mysql and Textarea

Can someone show me the mysql query statement to update the Text Area (the Text Area is populated with information from mysql) basically I want to allow the user to change or add information to the original data. scroll down to read the code. The text area I need to update is red font. ht