MySQL database administrator

Ye' old general discussion board. Basically, for everything that isn't covered elsewhere. Come here to shoot the breeze, shoot your mouth off, or whatever suits your fancy.
This forum is not for asking programming related questions.

Moderator: General Moderators

Post Reply
alex.barylski
DevNet Evangelist
Posts: 6267
Joined: Tue Dec 21, 2004 5:00 pm
Location: Winnipeg

MySQL database administrator

Post by alex.barylski »

Is there anything like access for MySQL?

I need something that will allow users to manage DB content for a web site and ideally it would have the ability to support FORM done in something like VBScript? To make the management of tables easier.

Cheers,
Alex
alex.barylski
DevNet Evangelist
Posts: 6267
Joined: Tue Dec 21, 2004 5:00 pm
Location: Winnipeg

Re: MySQL database administrator

Post by alex.barylski »

Just dawned on me, there is probably a mysql connection driver which you can use from access to manage a MySQL database from Access, that would be the cats meow.

If you have ever interfaced the two and know of any interesting problems, solutions, articles, resources, please let me know.
User avatar
jayshields
DevNet Resident
Posts: 1912
Joined: Mon Aug 22, 2005 12:11 pm
Location: Leeds/Manchester, England

Re: MySQL database administrator

Post by jayshields »

phpMyAdmin will probably fit your needs. In regards to a form (I guess you mean like in Access) then there are probably generic solutions for that already somewhere I guess.
alex.barylski
DevNet Evangelist
Posts: 6267
Joined: Tue Dec 21, 2004 5:00 pm
Location: Winnipeg

Re: MySQL database administrator

Post by alex.barylski »

PMA won't work...the users needs something they are more familiar with unfortunately, especially a Windows like application. Access can apparently connect to MySQL via an ODBC driver, but the last time I tried with OpenOffice, installing the JDBC was such a pain I eventually gave up. Although I did manage to get a MySQL admin tool working, thus the reason I thought I would ask about a MySQL admin tool, maybe something like access.
User avatar
Eran
DevNet Master
Posts: 3549
Joined: Fri Jan 18, 2008 12:36 am
Location: Israel, ME

Re: MySQL database administrator

Post by Eran »

How about navicat?
josh
DevNet Master
Posts: 4872
Joined: Wed Feb 11, 2004 3:23 pm
Location: Palm beach, Florida

Re: MySQL database administrator

Post by josh »

PCSpectra wrote:Access can apparently connect to MySQL via an ODBC driver, but the last time I tried with OpenOffice, installing the JDBC was such a pain I eventually gave up. Although I did manage to get a MySQL admin tool working, thus the reason I thought I would ask about a MySQL admin tool, maybe something like access.
I'd go with ODBC if you can, that's what it was designed for. If you can get the normal version of access or some other client that installs properly
Post Reply