1
General Board / Re: MySQL - problems
« on: December 09, 2002, 03:09:42 pm »
Hi Dave,
With my MySQL installation (4.0.4 on SuSE 8.0) I too found that I couldn't create a new DB from the EA end. This may be because the ODBC connection is to a specific database at the server end. If there's not one there then what do you connect to to create a new one??
One neat solution is to use Webmin to administer your server (if you don't have it then download from www.webmin.com) You can then log on to the server from your Windows PC with the appropriate user id and create a new DB and run the scripts to create the tables. Then copy your .EAP projects into it.
This way also has the advantage that the MySQL user id you let the EA users have need not have all the full table create/drop permissions - you can reserve that to another MySQL user which you use for administration of the database.
Good luck
James
With my MySQL installation (4.0.4 on SuSE 8.0) I too found that I couldn't create a new DB from the EA end. This may be because the ODBC connection is to a specific database at the server end. If there's not one there then what do you connect to to create a new one??
One neat solution is to use Webmin to administer your server (if you don't have it then download from www.webmin.com) You can then log on to the server from your Windows PC with the appropriate user id and create a new DB and run the scripts to create the tables. Then copy your .EAP projects into it.
This way also has the advantage that the MySQL user id you let the EA users have need not have all the full table create/drop permissions - you can reserve that to another MySQL user which you use for administration of the database.
Good luck
James