develooper Front page | perl.macosx | Postings from March 2005

Re: problem with installing DBD::mysql

Thread Previous | Thread Next
From:
Sherm Pendley
Date:
March 16, 2005 07:45
Subject:
Re: problem with installing DBD::mysql
Message ID:
c87adb4eba32d9a7a83ffcb2b5046cf7@dot-app.org
On Mar 16, 2005, at 12:56 AM, Ted Zeng wrote:

> I set the username to root. That should be enough, I assume.

There's no need to guess, or to make assumptions - The tests, if they 
fail to log in, will explicitly say so, and display the username and 
host that they tried, and whether or not a password was used.

> I didn't do the grant stuff.

It's been ages since I started with a brand-new clean MySQL install, 
and I can't recall what the default permissions are for the root user. 
If I remember right, only "root@localhost" is allowed to log in without 
a password. When MySQL fetches the host name of your Mac, it gets the 
Rendezvous name instead of 'localhost' - something like 
"computer-name.local.".

So, you do need to do the "grant stuff". It's a good idea to learn at 
least the basics of MySQL access authorization anyway. It's not just 
for security - you'll also want to create users to use when running 
your scripts. That will limit the damage a script in development can 
do; you don't want a buggy script going medieval on the system tables.

sherm--

Cocoa programming in Perl: http://camelbones.sourceforge.net
Hire me! My resume: http://www.dot-app.org


Thread Previous | Thread Next


nntp.perl.org: Perl Programming lists via nntp and http.
Comments to Ask Bjørn Hansen at ask@perl.org | Group listing | About