mySQL question . . .

[historicslunk]

I want to link an access db to my client list in sugar - for producing invoices.

I am running the latest rPath linux version with no patches or upgrades except . . . . .

I have just installed phpMyAdmin - literally seconds ago.

I have tried this so far
I have downloaded the ODBC Driver and installed it,

But when I attempt to connect using "root" and "MYPASSWORD" I get

[MySQL][ODBC 3.51 Driver]Host '200.200.200.222' is not allowed to connect to this MySQL server

Sugar works brilliantly, albeit a bit/very slow (old hardware)

Sharif

[ruchida]

You need to add another host to root user like "root@200.200.200.222".

[historicslunk]

You need to add another host to root user like "root@200.200.200.222".

Sorry to show my ignorance, but "how"

I have tried
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'
-> IDENTIFIED BY 'some_pass' WITH GRANT OPTION;

but . . . . .
Sharif

[nathanbthomas]

This this:


grant all on sugarcrm.* to 'root'@'YOURIPADDRESS' identified by 'YOURPASSWORD' with grant option;