Re: Connecting to mysql as root

[B. van Ouwerkerk]

  For connecting I have given the user as root and no password in the PERL 
 scipt.

You NEED to provide the password otherwise you can't get any data out of 
the database.. If you didn't entered a password for the mysql root user you 
need to do it ASAP..

Is there any way to connect to the database in the normal way, I 
 mean from the shell ?

mysql -u root -p
then you're asked to enter your password
use name_of_database

Bye,


B.


-
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

Connecting to mysql as root

[Rajeev Ramanujan]

Hi,
I have got a problem while connecting to MySQL. While I am trying to connect 
to mysql it shows an error 'Acces denied for user [EMAIL PROTECTED] (USING PASSWORD : 
NO),  but mysql server is still running. I have written a CGI program using PERL to 
connect to the mysql database. Using this program I am able to connect to the database 
and get the results. For connecting I have given the user as root and no password in 
the PERL scipt.

Is there any way to connect to the database in the normal way, I mean from the 
shell ?


Thank You
Rajeev Ramanujan