There is a program called mysqlaccess that allows you to try access privleges for other users/tables. I would look at the data in the mysql.yser table and delete the extraneous bits (e.g., other than localhost/root) and rebuild them.
There have also been some problems with getting the right hostname for the machines. This showed up for me using DHCP and DNS. At 6:01 PM +0800 11/22/01, Luie delos Santos wrote: >Hello Brian, > >>>>LdS> in other words I can only connect to mysql database if i use >>>>*root* in the .php file. >>>> >>>>Did you add the user to MySQL's user table, granting the proper >>>>access rights, >> >>LdS> *This I've already done* >>LdS> grant all >>LdS> on * >>LdS> to user1 identified by 'password1' >> >>>>then 'flush-privileges' or 'reload' using mysqladmin? >> >>LdS> how do I do this? >> >># mysqladmin -u root -p flush-privileges > >I tried using both reload and flush-privileges, unfortunately the >problem still persists. >do you have any other suggestions? > >thanks again... > -- -- Glenn Henshaw | Ottawa, Canada Play: [EMAIL PROTECTED] | Work: [EMAIL PROTECTED] _______________________________________________ Seawolf-list mailing list [EMAIL PROTECTED] https://listman.redhat.com/mailman/listinfo/seawolf-list
