Mandi! jmd
In chel di` si favelave...
> If it works with the root user , i think you have a problem of user
> privillege for glpict.
Ok, could be, but:
1) at least i can connect to the database with the glpi user, and
select some data.
2) normally i do:
grant all on glpict.* to 'glpi@localhost' identified by 'password';
and until now, have worked...
Anyway:
root@marvin:~# mysql -h localhost -u glpi -p glpict
Enter password:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3036
Server version: 5.1.63-0+squeeze1 (Debian)
Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> update glpi_users set email='[email protected]' where name='glpi';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql> CREATE TABLE t1 (
-> year_col INT,
-> some_data INT
-> );
Query OK, 0 rows affected (0.04 sec)
mysql> drop table t1;
Query OK, 0 rows affected (0.01 sec)
mysql>
So seems that grant works... boh... some more hint?
--
dott. Marco Gaiarin GNUPG Key ID: 240A3D66
Associazione ``La Nostra Famiglia'' http://www.sv.lnf.it/
Polo FVG - Via della Bontà , 7 - 33078 - San Vito al Tagliamento (PN)
marco.gaiarin(at)sv.lnf.it tel +39-0434-842711 fax +39-0434-842797
Dona il 5 PER MILLE a LA NOSTRA FAMIGLIA!
http://www.lanostrafamiglia.it/chi_siamo/5xmille.php
(cf 00307430132, categoria ONLUS oppure RICERCA SANITARIA)
_______________________________________________
Glpi-user mailing list
[email protected]
https://mail.gna.org/listinfo/glpi-user
