any PHP,Phpmyadmin and mysql experts here? - Page 2

Graham M · 10-02-2009, 22:33

Try taking the username and password out of the quote marks

Kymmy · 10-02-2009, 22:44

Try resetting your mysql root password then try again

http://dev.mysql.com/doc/refman/5.0/...rmissions.html

funkyCable · 10-02-2009, 22:55

Thanks Graham, I removed the username and password. It now comes up with the username and password whcih I put in and it has logged me in.

Thanks for your all help everybody.

ADMIN : Maybe we should have a coding space on the forum?

---------- Post added at 21:55 ---------- Previous post was at 21:49 ----------

Just one last thing can you store pictures in an mysql. I know you can in ORACLE you can store the pictures as BLOBs. I have loads of images on my c: drive I would like to store in mysql DB.
I'm hoping I can get PHP to insert them into a table for me.

**Paul** · 10-02-2009, 22:59

Yes you can.

Perhaps you should read the mysql documentation.

---------- Post added at 21:59 ---------- Previous post was at 21:59 ----------

FYI - vbulletin runs on PHP/MYSQL

Graham M · 10-02-2009, 23:26

For pictures to be stored into a database they generally need to be converted from binary data to some sort of text format, generally they are encoded (like in an email) which tends to increase the size of the file somewhat! You'd be much better leaving the pictures where they are.

**Paul** · 11-02-2009, 00:54

No conversion is needed in mysql, they are stored as binary data in blob fields.