Change mySQL Database access

asemerdjian · 2008-05-03 02:51:37

How does one change the mySQL database security so you can connect to the GLPI database?

I currently use the following so I may make ODBC connection:
> sudo su
> kill `cat /var/run/mysqld/mysqld.pid`
> mysqld --skip-grant-tables &

using:
Linux (Ubuntu-Gutsy Server 7.10) Apache2, Mysql-server-5, Php5
GLPI 0.70.2

The rest shouldn't matter, as I know I am able to make a connection provided I grant table access.
Just don't wish to issue it each time.

remi · 2008-05-03 02:54:29

Sorry, i don't understand what is your problem.

GLPI doesn't use ODBC.

++

asemerdjian · 2008-05-03 03:01:00

I use ODBC to connect to the mysql database which hosts GLPI.

Just wondering if anyone knows how to change the security on MySQL so I wouldn't provide the above commands when I make an ODBC connection.

I am using Access/Excel to make presentation reports with your live data, through an ODBC connection to your MySQL Database.

remi · 2008-05-03 03:06:42

I don't understand why you need to use this command.

You must configure ODBC to provide login/password for the DB.

Not a GLPI problem.

++

asemerdjian · 2008-05-03 03:19:35

You are correct it is not a GLPI problem, Ill move my question to a mysql forum. sorry.
Just wondering if anyone else has tried to do the same

We love your product, and its very useful.
thank you...

JMD · 2008-05-03 11:54:12

May the force be with you

asemerdjian · 2008-05-07 18:11:19

figured it out: I used MySQL Administrator connected as root, changed my schema privileges.
thanks...
/a

Forum GLPI-Project