Re: permissions on mysql db

2007-07-02 Thread Ananda Kumar
Thank u krishna. On 7/3/07, krishna chandra prajapati <[EMAIL PROTECTED]> wrote: Hi, Yes, it is possible. the command i have given in my previous email will make u to connect from mysql database server. The command below will make you to connect from the client computer The command is " grant a

Re: permissions on mysql db

2007-07-02 Thread krishna chandra prajapati
Hi, Yes, it is possible. the command i have given in my previous email will make u to connect from mysql database server. The command below will make you to connect from the client computer The command is " grant all privileges on *.* to 'user1'@'192.169.6.%' identified by password" The command b

Re: permissions on mysql db

2007-07-02 Thread Ananda Kumar
Hi Krishna, If i execute a new grant statement, then the new previlage will over ride the old previlage, if this happens, then i will not be able to connect from other client machines. I want to connect from client also from the local host. Is this possible. regards anandkl On 7/3/07, krishna c

Re: permissions on mysql db

2007-07-02 Thread krishna chandra prajapati
Hi Everybody, The user which has been created with all previleges on all db, will only work from the client machine only. If you want to access from the mysql database server you have to create a user "grant all privileges on *.* to '%'@'localhost' identified by password". I hope this should work

Re: permissions on mysql db

2007-06-28 Thread Ananda Kumar
you mean at os On 6/28/07, Rolando Edwards (DBA) <[EMAIL PROTECTED]> wrote: check your Linux/Unix user privileges *Ananda Kumar <[EMAIL PROTECTED]>* wrote: Hi All, I have created a user and grant all previlages on all db and the user can connect from any machine with in the same doiman. Now,

permissions on mysql db

2007-06-27 Thread Ananda Kumar
Hi All, I have created a user and grant all previlages on all db and the user can connect from any machine with in the same doiman. Now, when i login from a mysql client machine, i am able to see all the databases, but when i login directly from the mysql database server, I am able to see only th