MySQL give me the following error:Do you already have another mysqld server running on port: 3306 ?

[peri]

Hi,
I installed MysqL 4.1.22 on windows vista. When  I try to run any command in Mysql/MySQL server 4.1/bin path it gives me the following error :

C:\Program Files\MySQL\MySQL Server 4.1\bin>mysqld-max-nt --standalone
Can't start server: Bind on TCP/IP port: Invalid argument
071207 22:50:57 [ERROR] Do you already have another mysqld server running on port: 3306 ?
071207 22:50:57 [ERROR] Aborting

071207 22:50:57 [Note] mysqld-max-nt: Shutdown complete

Also when I try to run mysqladmin shutdown command it gives me the following error

C:\Program Files\MySQL\MySQL Server 4.1\bin>mysqladmin shutdown
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'ODBC'@'localhost' (using password: NO)'

I cannot run any command on mysql. Can anyone help me on this issue?
How can I solve this problem
Thank you
Perihan

[Ananda Kumar]

try this command to shutdown mysql


mysqladmin --host=abc --password shutdown


On 12/9/07, peri <ersoyperihan@...> wrote:

>
>
> Hi,
> I installed MysqL 4.1.22 on windows vista. When  I try to run any command
> in
> Mysql/MySQL server 4.1/bin path it gives me the following error :
>
> C:\Program Files\MySQL\MySQL Server 4.1\bin>mysqld-max-nt --standalone
> Can't start server: Bind on TCP/IP port: Invalid argument
> 071207 22:50:57 [ERROR] Do you already have another mysqld server running
> on
> port: 3306 ?
> 071207 22:50:57 [ERROR] Aborting
>
> 071207 22:50:57 [Note] mysqld-max-nt: Shutdown complete
>
> Also when I try to run mysqladmin shutdown command it gives me the
> following
> error
>
> C:\Program Files\MySQL\MySQL Server 4.1\bin>mysqladmin shutdown
> mysqladmin: connect to server at 'localhost' failed
> error: 'Access denied for user 'ODBC'@'localhost' (using password: NO)'
>
> I cannot run any command on mysql. Can anyone help me on this issue?
> How can I solve this problem
> Thank you
> Perihan
>
>
> --
> View this message in context:
> http://www.nabble.com/MySQL-give-me-the-following-error%3ADo-you-already-have-another-mysqld-server-running-on-port%3A-3306---tp14236918p14236918.html
> Sent from the MySQL - General mailing list archive at Nabble.com.
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=anandkl@...
>
>

[peri]

Hi
Running of mysql actually isn't exact problem.
When I try to run mysql command, it gave me ERROR 1045 (28000): Access denied for user 'ODXX@'localhost' (using password NO (or YES)) and i cannot run mysql command.

I did the following operation and mysql worked on vista.

I stoped mysql                       net stop mysql
i opened m.ini file and added    skip-grant-tables
and started mysql                   net start mysql
then mysql worked

If you faced the problem of ERROR 1045 (28000): Access denied for user 'ODXX@'localhost' (using password NO (or YES))  you can try it,
That is my solution
Perihan

Ananda Kumar wrote:

try this command to shutdown mysql


mysqladmin --host=abc --password shutdown


On 12/9/07, peri <[e-mail]> wrote:
>
>
> Hi,
> I installed MysqL 4.1.22 on windows vista. When  I try to run any command
> in
> Mysql/MySQL server 4.1/bin path it gives me the following error :
>
> C:\Program Files\MySQL\MySQL Server 4.1\bin>mysqld-max-nt --standalone
> Can't start server: Bind on TCP/IP port: Invalid argument
> 071207 22:50:57 [ERROR] Do you already have another mysqld server running
> on
> port: 3306 ?
> 071207 22:50:57 [ERROR] Aborting
>
> 071207 22:50:57 [Note] mysqld-max-nt: Shutdown complete
>
> Also when I try to run mysqladmin shutdown command it gives me the
> following
> error
>
> C:\Program Files\MySQL\MySQL Server 4.1\bin>mysqladmin shutdown
> mysqladmin: connect to server at 'localhost' failed
> error: 'Access denied for user 'ODBC'@'localhost' (using password: NO)'
>
> I cannot run any command on mysql. Can anyone help me on this issue?
> How can I solve this problem
> Thank you
> Perihan
>
>
> --
> View this message in context:
> http://www.nabble.com/MySQL-give-me-the-following-error%3ADo-you-already-have-another-mysqld-server-running-on-port%3A-3306---tp14236918p14236918.html
> Sent from the MySQL - General mailing list archive at Nabble.com.
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=[e-mail]
>
>