Re: R: RE: [cobalt-users] RAQ4 DSN MySql Problems

[Pierre Chopot <pierre@xxxxxxxxxxx>]

Hello List,

Saturday, January 27, 2001, 11:32:05 PM, you wrote:

CUDE> Thank you ALEX for answering,
CUDE> Yes I have done the last CobaltOs Update.
CUDE> How can I set privileges for an user in MySql?
CUDE> Do I need telnet or there is something in the control panel?



CUDE> First posting was:
CUDE> ------------------
>> Hi,
>> I use RAQ4 with ChiliASP and MySql Last updates.
>> I Created a new MySql DSN and used ROOT as login and his password.
>> IS OK, Test OK and DB accessible.
>>
>> If I set another User (for example a virtual site administrator)
>> setting his login and password i get ERROR in test and DB
>> is not accessible by common SQL commads....

How did you proceed to create that new user ?

I am no guru but I know of a few ways for doing that:
1/ mysqlaccess utility
2/ SQL commands like GRANT or REVOKE
3/ through something like phpMyAdmin that you can install (it's a php
script that provides you with a browser/html interface to administrate
you databases)

If you use 1/, you will need to do a "reload" or "flush-privileges"
with mysqladmin because privilege tables are loaded at startup and not
reloaded unless you force it (that way mySQL is faster)
If you use 2/, no need to reload

All this is pretty simple but still dangerous (you could lock you out)
so I would say the best way is to go look www.mysql.com or to buy a
good book like O'Reilly MySQL&mSQL.
Also mysqladmin --help and mysqlaccess --help are listing all the
options for these utilities.
I don't know to much about the relationship between virtual sites and
mySQL or ChiliSoft and mySQL ... I only have a QUbe2 :-(
HTH

>> -- Pasquale Mazzone

-- 
Regards,
 Pierre                          
 pierre@xxxxxxxxxxx