[cobalt-users] Re: MySql

[Richard Kurth <rkurth@xxxxxxxxxxxx>]

Hello System,

Thursday, January 04, 2001, 7:55:18 PM, you wrote:

SA> I have installed MySQL on a RAQ4 and have installed PhpMyAdmin in an attempt
SA> to admin the database. I am able to login successfully as the master "root"
SA> user with PhpMyAdmin, however my clients cannot log in using their own
SA> username and password to create and admin their own databases, eventhough
SA> PHP and ASP have been activated in "site settings" in the cobalt web admin
SA> panel.

SA> Can anyone assist? Is this the correct way to allow my clients to create and
SA> admin their own database? Thanks you for your help in advance.

 log into telanet run mysql -u root -p

 the run GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,REFERENCES,DROP,INDEX,ALTER
 ON userdatabase.* TO 'username'@'domain.com' IDENTIFIED BY 'password

   This will grant them all the privileges required to run that one
   database.
   If you want them to be able to add there own databases that starts
   getting a little risky.

   You need to read the mysql manual about user privileges and grant.

-- 
Best regards,
 Richard                            mailto:rkurth@xxxxxxxxxxxx