This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
- Revenera Community
- :
- InstallShield
- :
- InstallShield Forum
- :
- Re: Add SQL User
Subscribe
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Sep 01, 2009
05:15 PM
Add SQL User
I need my installer to execute one SQL script on one database, then add a user to the mysql database on the same server. Currently, I have it set up with two separate connections to handle the different databases. Under one connection, I have the main script, and under the other connection, I have the following script to add the user:
use mysql;
grant all on testdatabase.* to Test@'%' identified by 'tester';
flush privileges;
However, no matter how many ways I try to change things around, Installshield doesn't seem to want to add the user. I have the batch separator variable set to semicolon (;).
Does anyone have any thoughts on how to resolve this?
Your help is greatly appreciated!
use mysql;
grant all on testdatabase.* to Test@'%' identified by 'tester';
flush privileges;
However, no matter how many ways I try to change things around, Installshield doesn't seem to want to add the user. I have the batch separator variable set to semicolon (;).
Does anyone have any thoughts on how to resolve this?
Your help is greatly appreciated!
(2) Replies
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Sep 02, 2009
03:13 PM
Do you receive any errors from your InstallShield setup? Also, are you able to run the SQL script successfully from the MySQL Command Line Client tool?
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Sep 07, 2009
04:28 AM
mmmh, why don't you use an additional SQL Script?