<sm****@acm.org > wrote in message
news:11******** **************@ f14g2000cwb.goo glegroups.com.. .
I can log in locally when I am on the same box as root and other users.
But not from a remote box. I am running Query Browser which asks for
the host/user and password. The error message is
MySQL Error Number 1045
Access denied for user 'root'@'<hostna me>.localdomain ' (using
password:YES).
Are you using the same password that you use when you connect on the local
machine?
Also try this test on the Linux machine:
mysql -h <hostname> -u root -p <databasename >
Enter the actual hostname of the Linux server, not 'localhost'. This should
connect via a network connection, overriding the local-access method that
uses IPC. It'll ask for a password (due to the -p option). Enter the same
password you used in Query Browser.
The test is important because you could have different passwords for one
MySQL account, in this instance root. You can even have different passwords
per remote host. MySQL will use the entry where the host most
"specifical ly" matches the remote hostname. So an entry for
'root'@'hostnam e' will match before 'root'@'%'. Each entry can have
distinct passwords (or no passwords).
You could also have distinct privileges and passwords per database. MySQL's
privilege system is very flexible -- perhaps too flexible!
Another user (m6s) suggests using FLUSH PRIVILEGES when you change
privileges in the mysql system database. You don't need to do this if you
use GRANT & REVOKE statements; you need to do this only if you execute
INSERT/UPDATE/DELETE statements directly against the mysql system tables.
Regards,
Bill K.