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@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@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@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/
