On Saturday 07 September 2002 12:54 pm, Ronald Wiplinger wrote:
If I set the database user as "root" with no password (=== it is an off line testing machine !!!) the program works perfect. If I set the user and password via phpMyAdmin it fails. I have only entry in database mysql / table user an entry for this database. Even I grant all rights, it will not help. Access denied. In phpMyAdmin I type in:
Field Type Function Value Host char(60) % User char(16) username Passwd char(16) PASSWORD `users password` in single quote marks
It is likely that any error message you are getting from the db is not making it through phpMyAdmin, as Keith noted. (Incidentally, you could look at MyCC, on the mySQL site, as a GUI interface - although it's beta, it seems reasonably stable.) Are you sure that you have the relevant user set up in the mysql table, with the correct password, and the correct access rights? One thing that has to be watched out for is that mySQL will actually have two users - user@localhost and user@hostname - and you may be connecting as the wrong one. To get round this, use -hhostname as part of the connection string, or (better) set the password on the two users to be the same thing, using something like: update user set password=password("yourpass") where user ="youruser"; HTH Kevin