> Not being a SQL-minded person, can you suggest a SQL statement to run
that
> would give these appropriate privileges to a citrusdb user account?
/sometimes_your_path_to_mysql/mysql -u root -p
SHOW DATABASES;
SELECT user,host FROM mysql.user;
REVOKE ALL PRIVILEGES ON YOUR_TABLE_NAME.* FROM [EMAIL PROTECTED];
SELECT user,host FROM mysql.user;
DELETE FROM mysql.user WHERE Host='localhost' AND User='your_username';
FLUSH PRIVILEGES;
SELECT user,host FROM mysql.user;
DROP DATABASE YOUR_TABLE_NAME;
SHOW DATABASES;
CREATE DATABASE YOUR_TABLE_NAME;
SHOW DATABASES;
GRANT ALL PRIVILEGES ON YOUR_TABLE_NAME.* TO [EMAIL PROTECTED]
IDENTIFIED BY 'your_passsword';
SELECT user,host FROM mysql.user;
more info in:
http://dev.mysql.com/
Chris Hale wrote:
Not being a SQL-minded person, can you suggest a SQL statement to run that
would give these appropriate privileges to a citrusdb user account?
Chris
-----Original Message-----
From: Paul Yasi [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 21, 2006 12:36 PM
To: citrusdb-users@lists.sourceforge.net
Subject: [Citrusdb-users] New username/password?
It should work with any user that has been given access to open and
use the database. You can edit the privileges in the mysql server to
add a new user to open and use the database. In a production
installation it would be best to make a new username/password for
citrus, and if you are going to use the online part, a seperate
username/password for online with select and restricted insert access
to only the customer_history table.
I would have thought that a mysql root user would work too, remember
though that the root password for mysql is not necessarily the same as
the root password for the server itself. Those can be two different
things.
Paul
On 3/21/06, Chris Hale <[EMAIL PROTECTED]> wrote:
Do we need to create a new username/password for the initial installation
on
the db?
I can open the main login screen, but I get an error even when using the
root login:
Access denied for user 'root'@'localhost' (using password: YES)
How do we set up a new user/account in mysql for the citrusdb?
Chris
-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=k&kid0944&bid$1720&dat1642
_______________________________________________
Citrusdb-users mailing list
Citrusdb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/citrusdb-users
--
-----------------------------
Estrategias Electrónicas
José Pablo Orozco Marín
[EMAIL PROTECTED]
Tel. (506) 820 7280
http://www.Open-Antz.com/
San José - Costa Rica
Comunicación y Colaboración
-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
_______________________________________________
Citrusdb-users mailing list
Citrusdb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/citrusdb-users
