[PHP-DB] mysql to access

2004-12-17 Thread Perry, Matthew (Fire Marshal's Office)
Does anyone know of a FREE program that exports MySQL to access? The trial versions of the ones I have downloaded do not export all the records of the database. - Matthew

RE: [PHP-DB] mysql to access

2004-12-17 Thread Norland, Martin
-Original Message- From: Perry, Matthew (Fire Marshal's Office) [mailto:[EMAIL PROTECTED] Does anyone know of a FREE program that exports MySQL to access? The trial versions of the ones I have downloaded do not export all the records of the database. If you can get a .csv export

RE: [PHP-DB] mysql to access

2004-12-17 Thread Bastien Koert
why not just link the mysql to access? bastien From: Perry, Matthew (Fire Marshal's Office) [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: [PHP-DB] mysql to access Date: Fri, 17 Dec 2004 09:33:39 -0600 Does anyone know of a FREE program that exports MySQL to access? The trial versions

RE: [PHP-DB] mysql to access

2004-12-17 Thread Perry, Matthew (Fire Marshal's Office)
PROTECTED] Sent: Friday, December 17, 2004 10:01 AM To: [EMAIL PROTECTED] Subject: RE: [PHP-DB] mysql to access it would depend on what you need the app to do...if you are looking to use access to do reporting and/ or act as a front end, then it may be feasible... more details, if you care to share

RE: [PHP-DB] mysql to access

2004-12-17 Thread Miles Thompson
) instead of MySQL? Thank you all for your time and patience. - Matthew -Original Message- From: Bastien Koert [mailto:[EMAIL PROTECTED] Sent: Friday, December 17, 2004 10:01 AM To: [EMAIL PROTECTED] Subject: RE: [PHP-DB] mysql to access it would depend on what you need the app to do...if you

RE: [PHP-DB] mysql to access

2004-12-17 Thread Bastien Koert
see embedded comments bastien From: Perry, Matthew (Fire Marshal's Office) [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: RE: [PHP-DB] mysql to access Date: Fri, 17 Dec 2004 10:25:09 -0600 Here is the problem: I am currently using MySQL and PHP for this application but have realized recently

[PHP-DB] MySQL denying access to...everything

2004-08-18 Thread AceZero2790
I finally got my PHP5 installation to support MySQL and now this. When I try to edit anything on mysqlgui.exe, it just gives me this error: error in database function: access denied for user @localhost... I don't know if this has to do with my php installation or what. If not, flame me for all

Re: [PHP-DB] MySQL denying access to...everything

2004-08-18 Thread Peter Ellis
This is a MySQL error on the server side - you need to make sure that whatever user you're signing into MySQL with has access to modify the database/table you're using. I believe the GRANT keyword in MySQL is what you need -- look at the MySQL reference manual: http://dev.mysql.com/doc/ Good

Re: [PHP-DB] MySQL denying access to...everything

2004-08-18 Thread Paul
Also, take care with the new password hashing: http://dev.mysql.com/doc/mysql/en/Password_hashing.html Paul On Wed, 18 Aug 2004 00:56:08 -0700, Peter Ellis [EMAIL PROTECTED] wrote: This is a MySQL error on the server side - you need to make sure that whatever user you're signing into MySQL

Re: [PHP-DB] MySQL denying access to...everything

2004-08-18 Thread Doug Thompson
[EMAIL PROTECTED] wrote: I finally got my PHP5 installation to support MySQL and now this. When I try to edit anything on mysqlgui.exe, it just gives me this error: error in database function: access denied for user @localhost... I don't know if this has to do with my php installation or what.

[PHP-DB] MySQL denying access to everything...Part 2

2004-08-18 Thread AceZero2790
Ok, thanks to many people's help, I have managed to install MySQL right and login as root with no password. However, MySQL will not allow to log in to my databases as root. Is this normal, because when I try it brings back the old access denies: [EMAIL PROTECTED] thing. So I thought maybe I

Re: [PHP-DB] MySQL denying access to everything...Part 2

2004-08-18 Thread Peter Ellis
This isn't the appropriate list to direct this question to. I suggest one of the MySQL help lists or a careful reading of the documentation, which tells you exactly what you need to know. -- Peter Ellis - [EMAIL PROTECTED] Web Design and Development Consultant naturalaxis |

RE: [PHP-DB] MySQL denying access to everything...Part 2

2004-08-18 Thread balwantsingh
mysql grant all privileges on *.* to [EMAIL PROTECTED] identified by 'password' with grant option; try this out balwant -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, August 19, 2004 12:13 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] MySQL denying