Page 1 of 1

MySQL database administrator

Posted: Mon Feb 23, 2009 2:44 pm
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

Re: MySQL database administrator

Posted: Mon Feb 23, 2009 2:53 pm
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.

Re: MySQL database administrator

Posted: Mon Feb 23, 2009 6:01 pm
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.

Re: MySQL database administrator

Posted: Mon Feb 23, 2009 8:08 pm
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.

Re: MySQL database administrator

Posted: Mon Feb 23, 2009 8:12 pm
by Eran
How about navicat?

Re: MySQL database administrator

Posted: Mon Feb 23, 2009 8:18 pm
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