MySQL user creation

[Linus]

Hi:

How can I create mysql users in AppLogic 1.x, none of the linux commands are working in the shell.

Thanks,

Linus

[PeterNic]

Linus,

Where are you entering the commands?

If your MySQL appliance is myapp:main.dbase, then try "ssh myapp:main.dbase" to login to the appliance shell, or "ssh myapp:main.dbase <command>" to execute a single command on the appliance. Make sure the appliance is running.

Also, please keep in mind that if you access the MySQL appliance from other appliances (e.g., access MYSQL from WEB), you will need to add permissions for remote access to new users you create (e.g., linus@%). See the MYSQL appliance data sheet at http://doc.3tera.net/AppLogic1/CatMiscMySQL.html

Finally, if you don't need multiple users, consider not creating separate users -- since the only access to the MYSQL appliance is through its input, only appliances that are connected to it can access it. If you don't need a multiuser environment, you can keep the app simpler.

Does any of the above help?

Regards,
-- Peter