So its better to start with a mySQl database and connect to that database then using the mysql lite database. What I like is out of the box web2py has a user login now is it possible to export that login structure to a mysql database and what file would i have to change in web2py so it will always connect to that mysql database when somebody visits my site.
On Feb 17, 11:26 am, villas <villa...@gmail.com> wrote: > Well I try to only use DB admin tools to examine the data and > occasionally edit it and perhaps create and optimise indexes etc, > usually once my app is stable. > > Bear in mind that anything you do in a DB admin tool will make it more > difficult to migrate your app to another database, so try to > accomplish everything possible via web2py. > > The one I use and recommend for Firebird is IbExpert. I have used > various ones for MySql but do not have a strong recommendation. There > are lots of tools for Sqlite. Just google for suitable tools for the > DB of your choice. > > On Feb 17, 2:56 pm, stargate <kyoukh...@gmail.com> wrote: > > > So saying that how do I add a username and password to the database > > and give the user permissions to insert delete view records. I also > > what to be able to connect to the database using a db tool to examine > > and administrate my db. Which one would you recommend. > > > On Feb 17, 7:15 am, villas <villa...@gmail.com> wrote: > > > > You can use ANY suitable tool to examine/administrate your DB > > > independently of web2py. > > > > On Feb 17, 4:04 am, stargate <kyoukh...@gmail.com> wrote: > > > > > It's just a database admin tool for mysql. I just want to be able to > > > > access the mysql lite database that comes with web2py using mysqlfront > > > > > On Feb 16, 10:22 pm, Richard Vézina <ml.richard.vez...@gmail.com> > > > > wrote: > > > > > > I think you should provide information about mysqlfront and how you > > > > > think it > > > > > could work with Web2py. > > > > > > Personnaly I am not aware of anything about mysqlfront... > > > > > > Richard > > > > > > On Wed, Feb 16, 2011 at 9:40 PM, stargate <kyoukh...@gmail.com> wrote: > > > > > > Is it possible to do this > > > > > > > On Feb 16, 9:51 am, stargate <kyoukh...@gmail.com> wrote: > > > > > > > When running web2py how do i access the mysql database using a > > > > > > > applicaiton like > > > > > > > >http://www.mysqlfront.de/wp/download/ > > > > > > > > Also when creating a new application using the application wizard > > > > > > > it > > > > > > > has no indication to specify a user login for the database. > > > > > > > Where can > > > > > > > i change this. > >
