What's the default user/pass

[Coderifous]

I'm new to MySQL and databases in general. I'm developing an website using MySQL, and the Perl/DBI. The Perl/DBI is no problem... the MySQL is tripping me up. A few quick questions would help me out:

I can "connect" to a database without a name and password. How do I make it so the MySQL requires that those for queries. Is it using an anonymous "user" by defualt? How do I get rid of the anonymous user if this is the case?

In my "user" table in the MySQL db, there is an entry that has no info at all, no "user" no "password", and all the privs are set to "N", so that's not a problem... right?

However, the "root" user has no password set, and has all privs, is this the default user?

A little help would go a long way for me... thanks in advance.

-Jim

 

[nogs]

Coderifous
Yes root is the defalt with no password.
In the informative manual at

http://www.mysql.com

see;
4.3.5 Adding new users
The manual will help you with all your Mysql admin needs.

Nogs