Well, according to your message, you might want to make sure you are typing mysql and not mysqld(which is the server daemon)
According to the docs when I go to the cmd window, I should type in mysql -username xxxx and then get prompted for a password. But I get this: look at what you typed, you typed in mysqld not mysql C:\mysql\bin>mysqld -username root Kelley Scott Purcell wrote: > Hello, > I am new to mysql and have a couple of questions that I can't seem to get through at > this time. > > I have installed the product on my win2000 box. I followed the docs for PC, and > removed the generic user in the users table. > > Here is my question: > According to the docs when I go to the cmd window, I should type in mysql -username > xxxx and then get prompted for a password. > But I get this: > C:\mysql\bin>mysqld -username root > Can't start server: Bind on TCP/IP port: No error > 031022 10:46:57 Do you already have another mysqld server running on port: 3306 > ? > 031022 10:46:57 Aborting > > 031022 10:46:57 mysqld: Shutdown Complete > > But if I type just mysql > C:\mysql\bin>mysql > Welcome to the MySQL monitor. Commands end with ; or \g. > Your MySQL connection id is 8 to server version: 4.0.15-max-debug > > Type 'help;' or '\h' for help. Type '\c' to clear the buffer. > > mysql> > > I also tried this, and this is how I need to connect with JDBC > C:\mysql\bin>mysql -username root -p > Enter password: ****** > ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) > > But it fails. I know I have a root user with a valid password? > > Where am I going wrong? > > I did create the 'menagerie' database, and can't get back to it. > > Thanks, > Scott > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
