Maybe I am stating the obvious but instead of typing mysql -username root -p
try : mysql -u root -p HTH Rory McKinley Nebula Solutions +27 82 857 2391 [EMAIL PROTECTED] "There are 10 kinds of people in this world, those who understand binary and those who don't" (Unknown) ----- Original Message ----- From: "Kelley Lingerfelt" <[EMAIL PROTECTED]> To: "Scott Purcell" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, October 22, 2003 6:52 PM Subject: Re: command line operation problems > 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] > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
