How to configure mysql server?

[Lai Zit Seng]

Timothy Murphy wrote:
> I'd like to run mysqld on my desktop "alfred"
> and run a mysql client on my laptop "elizabeth".
> 
> It seems I need to grant permission on alfred
> for tim at elizabeth to access the server,
> but I have not found how to do this.
> 
> I'm running mysqld version 5.0.22 under Fedora-5.
> 
> When I try to set the password for user "root" on my desktop
> I get the error:
> ------------------------------------------
> [root at alfred tim]# mysqladmin -u root password whatever
> mysqladmin: connect to server at 'localhost' failed
> error: 'Access denied for user 'root'@'localhost' (using password: NO)'
> ------------------------------------------
> Another attempt fails:
> ------------------------------------------
> [root at alfred tim]#  mysql -h localhost -u root -p
> Enter password:
> ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
> password: YES)
> ------------------------------------------
> 
> Does this mean that "root" already has a password, which I do not know?

Yes it does sound like root already has a password.

You can try reinitializing the mysql tables by running:

/usr/bin/mysql_install_db

Regards,

.lzs
http://thinkingfarm.com/~lzs/