mysqld, mysqld-nt, mysqld-debug

2008-10-04 Thread Varuna Seneviratna
Hello Everybody 1 In the reference manual there are three server types how can I start the mysqld server? 2 What is the difference between installing MySQL as a server and a service, Is it only that when installed as a service MySQL server starts when Windows starts and when Windows stops

server mysqld how to start in WindowsXP

2008-10-04 Thread Varuna Seneviratna
Why can't I start mysqld server on WindowsXp, The reference manula for 5.0 says that there are three servber types.But I am able to start only on mysqld, and only mysqld-nt gets installed.Am I doing something wrong? Varuna

Re: What is the user account's password, Why is most of the things in the reference manual does not work as stated?

2008-10-04 Thread Fish Kungfu
Has the user been GRANTed PRIVILEGES yet? Look here for how to do that: http://dev.mysql.com/doc/refman/5.0/en/adding-users.html Cheers...Fish On Sat, Oct 4, 2008 at 12:36 PM, David Giragosian <[EMAIL PROTECTED]>wrote: > On Sat, Oct 4, 2008 at 11:33 AM, Varuna Seneviratna < > [EMAIL PROTECTE

Please the whole message?

2008-10-04 Thread Varuna Seneviratna
I have WindowsXP I stopped the service from the services shortcut in the Administrative tools.then according to to the reference manual to start the server for the first time the command to run is given as C:\>"C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld" --console But it didn't work, the f

Re: What is the user account's password, Why is most of the things in the reference manual does not work as stated?

2008-10-04 Thread David Giragosian
On Sat, Oct 4, 2008 at 11:33 AM, Varuna Seneviratna < [EMAIL PROTECTED]> wrote: > What is the user account's password.I used the command > C:\>mysql -u user -p > Enter password: ** > ERROR 1045 (28000): Access denied for user 'user'@'localhost' (using > password: Y > ES) > How can I find i

What is the user account's password, Why is most of the things in the reference manual does not work as stated?

2008-10-04 Thread Varuna Seneviratna
What is the user account's password.I used the command C:\>mysql -u user -p Enter password: ** ERROR 1045 (28000): Access denied for user 'user'@'localhost' (using password: Y ES) How can I find it? Varuna

RE: How to start mysqld server, What is the difference between a server and a server?

2008-10-04 Thread Martin Gainty
service usually indicates a background service such as Windows Service MySQL implements Windows Service Functionality thru mysqld-nt binary documentation is available at http://dev.mysql.com/doc/refman/5.0/en/multiple-windows-services.html a server is a standalone binary or even possibly a binar

How to start mysqld server, What is the difference between a server and a server?

2008-10-04 Thread Varuna Seneviratna
Hello Every body! I stopped the service from the services shortcut in the Administrative tools.then according to to the reference manual to start the server for the first time the command to run is given as C:\>"C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld" --console But it didn't work, the

Re: mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'ODBC'@'localhost' (using password: YES)'

2008-10-04 Thread Varuna Seneviratna
Hi Ian Thanks! Your advice worked.I have another problem.I stopped the service from the services shortcut in the Administrative tools.then according to to the reference manual to start the server for the first time the command to run is given as C:\>"C:\Program Files\MySQL\MySQL Server 5.0\bin\

Re: mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'ODBC'@'localhost' (using password: YES)'

2008-10-04 Thread Ian Simpson
Hi Varuna, The problem looks like it is with the command you issued. The correct syntax is: mysqladmin -uroot -p shutdown then supply root password. Without giving the -uroot argument, it doesn't know that you are trying to log in as the root user, which is why it is telling you that access is

Re: mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'ODBC'@'localhost' (using password: YES)'

2008-10-04 Thread Andy Shellam
Hi Varuna, I think you're missing the "-u" option (User for login if not current user.) Try: "mysqladmin" -u root -p shutdown (-p without a value indicates to prompt for a password from the terminal.) Andy Varuna Seneviratna wrote: I am using WinXP.I am wanted to shutdown MySQL service from

Re: mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'ODBC'@'localhost' (using password: YES)'

2008-10-04 Thread Pintér Tibor
Varuna Seneviratna írta: I am using WinXP.I am wanted to shutdown MySQL service from the command line and ran the command "mysqladmin" -p root shutdown next the root password was asked for,I entered the correct password, when I entered the password the below displayed error was the result mysqla

mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'ODBC'@'localhost' (using password: YES)'

2008-10-04 Thread Varuna Seneviratna
I am using WinXP.I am wanted to shutdown MySQL service from the command line and ran the command "mysqladmin" -p root shutdown next the root password was asked for,I entered the correct password, when I entered the password the below displayed error was the result mysqladmin: connect to server at