[PHP-DB] Re: MySQL 4.x: Access denied for users when password is set...

2003-12-24 Thread Daniel Crespo
I think you have to modify the config.ini.php that comes with phpmyadmin. I've got the same situation than you. Try that. I hope this helps you. "-{ Rene Brehmer }-" <[EMAIL PROTECTED]> escribió en el mensaje news:[EMAIL PROTECTED] > Hi gang > > as subject says ... I've got a pretty weird situatio

[PHP-DB] file upload into mySQL

2003-12-24 Thread Hiro
hi! Sorry I send many times of my question. because I changed email address! Please see the question below; I am uploading file into mySQL database from web site. But it is unable to upload it into database. If you know how to upload the file from web site into mySQL, could you please teach me

[PHP-DB] MySQL 4.x: Access denied for users when password is set...

2003-12-24 Thread -{ Rene Brehmer }-
Hi gang as subject says ... I've got a pretty weird situation. For all users I create in the 'user' table in 'mysql' DB, if I set a password, that user becomes unable to access any DBs ... it doesn't matter if I set the pw as ASCII or password, still won't allow access... I've tried making new

[PHP-DB] file upload into mySQL

2003-12-24 Thread Hiro
hi! (B (B (BI am uploading file into mySQL database from web site. But it is unable to (Bupload it into database. (BIf you know how to upload the file from web site into mySQL, could you (Bplease teach me how! (B (Bthe database information is; (B (Bcreate table objects (B b_col

[PHP-DB] file upload into mySQL

2003-12-24 Thread Hiro
hi! (B (B (BI am uploading file into mySQL database from web site. But it is unable to (Bupload it into database. (BIf you know how to upload the file from web site into mySQL, could you (Bplease teach me how! (B (Bthe database information is; (B (Bcreate table objects (B b_col

[PHP-DB] file upload into mySQL

2003-12-24 Thread Hiro
hi! I am uploading file into mySQL database from web site. But it is unable to upload it into database. If you know how to upload the file from web site into mySQL, could you please teach me how! the database information is; create table objects b_col blob, name varchar(30),

Re: [PHP-DB] Remove all instances of a character....

2003-12-24 Thread CPT John W. Holmes
From: <[EMAIL PROTECTED]> > I have a MySQL database, with around 500 entries in one table... > I've noticed that many entries have an erroneous ';' in the one of the > fields. > > What I need to do, is tell MySQL to go through the ENTIRE table and find > any instances of ' ; ' and them delete

Re: [PHP-DB] Remove all instances of a character....

2003-12-24 Thread Muhammed Mamedov
Try this : mysql_query("DELETE FROM YOURTABLE WHERE YOURCOLUMN_NAME=';'"); Saygilarla, Muhammed Mamedov - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, December 24, 2003 1:12 PM Subject: [PHP-DB] Remove all instances of a character > I have a

[PHP-DB] Remove all instances of a character....

2003-12-24 Thread Tristan . Pretty
I have a MySQL database, with around 500 entries in one table... I've noticed that many entries have an erroneous ';' in the one of the fields. What I need to do, is tell MySQL to go through the ENTIRE table and find any instances of ' ; ' and them delete them... leaving the rest of the data