Hello Glenn,
> 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. > I was able to look at the data in mysql.user, but I don't which parts to remove. There were some words scattered all over with a series of ^B^B^B and +-+-+-. Forgive my ignorance in this, would you please tell what these are and what do I need to delete? Using "select * from mysql.user;" would show the contents but will not be able to edit it, how do i edit it? > There have also been some problems with getting the right hostname >for the machines. This showed up for me using DHCP and DNS. > Correct me if I'm wrong, but since I can access the database as *root* it means that there is no problem with the hostname. Am I right? >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 > > __________________________________ www.edsamail.com _______________________________________________ Seawolf-list mailing list [EMAIL PROTECTED] https://listman.redhat.com/mailman/listinfo/seawolf-list
