Re: Re: New Setup

2002-04-26 Thread Egor Egorov
Ian, Friday, April 26, 2002, 12:52:29 AM, you wrote: IP> I now have two mysqld processes running on my server (Freebsd / apache), and IP> no mysql (according to a ps command). IP> What is the safe way to kill these two, and restart mysql? If you really want to kill, you may use "kill PID" (but

Re: New Setup

2002-04-25 Thread Gelu
AIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, April 26, 2002 12:52 AM Subject: Re: New Setup > I now have two mysqld processes running on my server (Freebsd / apache), and > no mysql (according to a ps command). > > What is the safe way to kill these two, an

Re: New Setup

2002-04-25 Thread Ian Phillips
Sent: Wednesday, April 24, 2002 8:56 PM Subject: Re: New Setup > Ian, > Wednesday, April 24, 2002, 5:04:15 AM, you wrote: > > IP> Using the commands you have offered... > > Egor>> Your 'root' user doesn't have GRANT privilege ... > Egor>> &g

Re: New Setup

2002-04-24 Thread Alec Grynspan
At 12:04 PM 24/04/2002 +1000, you wrote: >Using the commands you have offered... > >Egor> Your 'root' user doesn't have GRANT privilege ... >Egor> >Egor> You should change Grant_priv to 'Y' >Egor> You can do this using UPDATE statement: >Egor> UPDATE user SET Grant_priv='Y' WHERE user='root'

Re: New Setup

2002-04-24 Thread Egor Egorov
Ian, Wednesday, April 24, 2002, 5:04:15 AM, you wrote: IP> Using the commands you have offered... Egor>> Your 'root' user doesn't have GRANT privilege ... Egor>> Egor>> You should change Grant_priv to 'Y' Egor>> You can do this using UPDATE statement: Egor>> UPDATE user SET Grant_priv='Y' W

Re: New Setup

2002-04-24 Thread Gelu
Hi, After installing mySQL, you ran mysql_install_db.sh script ? Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: I

Re: New Setup

2002-04-23 Thread Egor Egorov
Ian, Tuesday, April 23, 2002, 12:41:40 AM, you wrote: Egor>> By default user 'root' has all privileges... Egor>> Show me the output of following: Egor>> SHOW GRANTS FOR 'root'@'localhost'; IP> mysql> show grants for 'root'@'localhost' IP> -> ; IP> +-

Re: New Setup

2002-04-22 Thread Gelu
MPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Ian Phillips <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, April 22, 2002 3:17 PM Subject: Re: New Setup > Thanks for the idea

Re: New Setup

2002-04-22 Thread 龔惠樑(Borus.Kung)
and allow that user to access the cbaa database. > > Ian > - Original Message - > From: "ÅÇ´f¼Ù (Borus.Kung)" <[EMAIL PROTECTED]> > To: "Ian Phillips" <[EMAIL PROTECTED]> > Sent: Monday, April 22, 2002 10:23 PM > Subject: Re: Ne

Re: New Setup

2002-04-22 Thread Ian Phillips
IL PROTECTED]> To: "Ian Phillips" <[EMAIL PROTECTED]> Sent: Monday, April 22, 2002 10:23 PM Subject: Re: New Setup > I found that you Grant to cbaa user but use root to login > check it > > Borus ;) > > > > > Thanks for the idea -- still stuck though >

Re: New Setup

2002-04-22 Thread Ian Phillips
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, April 22, 2002 9:05 PM Subject: Re: New Setup > Hi, > Only the root with the '%' character on the host field from table mysql.user > have full priveleges.Try to connect with "-h" option and specify

Re: New Setup

2002-04-22 Thread 龔惠樑(Borus.Kung)
I think you have to use the -p option too and type your password because the GRANT statement specified a password mysql -u root -h Your_Server_Name -p Borus > Hi, > Only the root with the '%' character on the host field from table mysql.user > have full priveleges.Try to connect with "-h" opti

Re: New Setup

2002-04-22 Thread Gelu
Hi, Only the root with the '%' character on the host field from table mysql.user have full priveleges.Try to connect with "-h" option and specify the Host_Name of your server.Should be work. Eg: mysql -u root -h Your_Server_Name Regards, Gelu _ G