Please reply me
Hai Here is my Query. When the LAN goes down the client mysql process does not give any exception.Instead of that it hangs for Long time in UNIX.But in windows it raise exception immediately.How to configure in Linux or Unix to behave as like in windows. Please reply me .Iam in urgent. With regards Ganesh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
replication of mysql on 2 different OS
hi gurus, iam facing a problem or situation that i have installed mysql 3.23.52 on Windows 2000 server..which will be my master... i want to setup my slave server which will be on RedHat Linux 7.1 with mysql 3.23.49... can anyone help me out on this Thanks in advance Ganesh Rajan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
problem in connecting to DB
hello all,
i would like to put a problem as what iam facing... i created a new database
& new user, but i didn't give the password...
then i logged in to mysql
ie
c:\mysql\bin> mysql
then
mysql> use mysql
then
mysql>update user set password=password('pswd') where user= 'username';
then i got the result as 1row updated.
then i quit from mysql using mysql>\q
now when i want to connect
i.e.
c:\mysql\bin> mysql -u username -ppswd dbname;
iam getting error stating "Error 1405:Access denied for user:
'username@localhost ' (user password :YES)'
IAM WORKING ON COMMANDLINE @ MYSQL SERVER ITSELF
can someone throw light onthis... it will be of grate help
Thanks in advance
Ganesh Rajan
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: problem in connecting to DB
Thanks for the response but as the document states to "RUN mysqladmin
flush-privileges and mysqladmin reload" i tried bothways... but in vain
... i still get the same error message "Error 1045: Access Denied for
user:(username@localhost) (user password :YES)"
Ganesh Rajan
- Original Message -
From: "Diana Soares" <[EMAIL PROTECTED]>
To: "Ganesh Rajan" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, February 18, 2003 8:59 PM
Subject: Re: problem in connecting to DB
> Everytime you use UPDATE, INSERT, DELETE to update user privileges you
> must do a FLUSH PRIVILEGES for changes to take effect.
> Check the manual:
> http://www.mysql.com/doc/en/Privilege_changes.html
>
>
> On Tue, 2003-02-18 at 11:57, Ganesh Rajan wrote:
> > hello all,
> >
> > i would like to put a problem as what iam facing... i created a new
database
> > & new user, but i didn't give the password...
> >
> > then i logged in to mysql
> > ie
> > c:\mysql\bin> mysql
> > then
> > mysql> use mysql
> > then
> > mysql>update user set password=password('pswd') where user= 'username';
> > then i got the result as 1row updated.
> >
> > then i quit from mysql using mysql>\q
> > now when i want to connect
> > i.e.
> > c:\mysql\bin> mysql -u username -ppswd dbname;
> >
> > iam getting error stating "Error 1405:Access denied for user:
> > 'username@localhost ' (user password :YES)'
> >
> > IAM WORKING ON COMMANDLINE @ MYSQL SERVER ITSELF
> >
> > can someone throw light onthis... it will be of grate help
> >
> > Thanks in advance
> > Ganesh Rajan
> >
> >
> > -
> > Before posting, please check:
> >http://www.mysql.com/manual.php (the manual)
> >http://lists.mysql.com/ (the list archive)
> >
> > To request this thread, e-mail <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> >
> --
> Diana Soares
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php (the manual)
>http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: problem in connecting to DB
one more thing i would like to ask u gurus when i have given my host
with an IP address... why is it giving the message " username@localhost "
wherein it should give me as " username@IPaddress "
Thanks
Ganesh Rajan
- Original Message -
From: "Ganesh Rajan" <[EMAIL PROTECTED]>
To: "Diana Soares" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, February 19, 2003 10:26 AM
Subject: Re: problem in connecting to DB
> Thanks for the response but as the document states to "RUN mysqladmin
> flush-privileges and mysqladmin reload" i tried bothways... but in
vain
> ... i still get the same error message "Error 1045: Access Denied for
> user:(username@localhost) (user password :YES)"
>
> Ganesh Rajan
> - Original Message -
> From: "Diana Soares" <[EMAIL PROTECTED]>
> To: "Ganesh Rajan" <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>
> Sent: Tuesday, February 18, 2003 8:59 PM
> Subject: Re: problem in connecting to DB
>
>
> > Everytime you use UPDATE, INSERT, DELETE to update user privileges you
> > must do a FLUSH PRIVILEGES for changes to take effect.
> > Check the manual:
> > http://www.mysql.com/doc/en/Privilege_changes.html
> >
> >
> > On Tue, 2003-02-18 at 11:57, Ganesh Rajan wrote:
> > > hello all,
> > >
> > > i would like to put a problem as what iam facing... i created a new
> database
> > > & new user, but i didn't give the password...
> > >
> > > then i logged in to mysql
> > > ie
> > > c:\mysql\bin> mysql
> > > then
> > > mysql> use mysql
> > > then
> > > mysql>update user set password=password('pswd') where user=
'username';
> > > then i got the result as 1row updated.
> > >
> > > then i quit from mysql using mysql>\q
> > > now when i want to connect
> > > i.e.
> > > c:\mysql\bin> mysql -u username -ppswd dbname;
> > >
> > > iam getting error stating "Error 1405:Access denied for user:
> > > 'username@localhost ' (user password :YES)'
> > >
> > > IAM WORKING ON COMMANDLINE @ MYSQL SERVER ITSELF
> > >
> > > can someone throw light onthis... it will be of grate help
> > >
> > > Thanks in advance
> > > Ganesh Rajan
> > >
> > >
> > > -
> > > Before posting, please check:
> > >http://www.mysql.com/manual.php (the manual)
> > >http://lists.mysql.com/ (the list archive)
> > >
> > > To request this thread, e-mail <[EMAIL PROTECTED]>
> > > To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> > >
> > --
> > Diana Soares
> >
> >
> > -
> > Before posting, please check:
> >http://www.mysql.com/manual.php (the manual)
> >http://lists.mysql.com/ (the list archive)
> >
> > To request this thread, e-mail <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> >
> >
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php (the manual)
>http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Query
Hi, I am developing a Java application which uses MySQL database on Linux platform. Mark Mattews' MySQL driver is being used. I am able to connect to the database from the application if I login as root. But if I login as any user, I get an exception saying that the driver was not found. Being a newbie in Linux, I am not sure if this is a problem with the permission. I tried several different things, but couldn't get it rectified. Any help in this regard will be highly appreciated. Regards, Ganesh Ganesh Krishnan iCOPE Technologies Pvt. Ltd. 111/112, 3rd Cross,1st Main, 7th Block Koramangala, Bangalore - 560 095 Phone : 5716909, 5716939, 5715213 Fax : 5716908 Visit us at www.icope.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Accessing the MySQL on a remote machine!!
Hi, Is it possible for me to access a database on a remote machine by giving the IP address of the remote machine as the host??? If it possible, can I access a database of the root user by giving the password set for the root user??? How do I add a new user to MySQL?? I tried by giving mysqladmin -u my_name -h localhost password my_password I got an Error Message saying "Access Denied for my_name@localhost" Any help will be highly appreciated!! Regards, Ganesh Ganesh Krishnan iCOPE Technologies Pvt. Ltd. 111/112, 3rd Cross,1st Main, 7th Block Koramangala, Bangalore - 560 095 Phone : 5716909, 5716939, 5715213 Fax : 5716908 Visit us at www.icope.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Doubt!!
Hi, I have SuSE 7.0 running on a my machine. When i tried to install MySQL 3.23.32 from SuSE 7.1 CD, my XWindows stopped working. Infact SuSE 7.0 CD comes with MySQL 3.23.10. Could somebody help me out with the problem?? Regards, Ganesh - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Problem in running mysqld
Hi, I have SuSE 7.1 installed on my machine. SuSE 7.1 comes with MySQL 3.23.32. When in try to run mysqld, i am getting the following error: Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!! But i couldn't find any section called "Security" in the manual. I also tried running safe_mysqld. The following is the message it got: Starting deamon with database from /var/lib mysql mysql ended. safe_mysqld atleast creates the mysql.sock socket. The manual says there will be a log created corresponding to the error in /var/log. But i couldn't see any log created. Any help will be highly appreciated. Regards, Ganesh Ganesh Krishnan Software Trainee iCOPE Technologies Pvt. Ltd. (www.icope.com) 111/112, 3rd Cross,1st Main, 7th Block Koramangala Bangalore - 560 095 Phone : 5716909, 5716939, 5715213 Fax : 5716908 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
