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
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
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
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
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,
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