<[EMAIL PROTECTED]> writes:
[...] > Did you add the correct system root password to your > /etc/mysql/my.cnf file? > > After I do that I can run mysql with no -p parameter > at all. I don't find that to be true here. I still need the -p flag. I added roots pswd in there (/etc/mysql/my.cnf) and restarted mysql then attempted: # mysql ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) Even using -p fails if I give roots password (same as what is in my.cnf) mysql -p Enter password: ROOTPW <ENTER> ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) The only pw mysql listens too is that initial one used on install. I'm not sure how the password entry in my.cnf is supposed to affect things. It appears to have no effect here. Mysql wants that initial pwd regardless # mysql -p Enter password: INITIALpw_NOTROOTpw <ENTER> Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 4 to server version: 5.0.16-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. This is with roots actual pw in my.cnf, and following a restart of mysql. But this is not really a problem now with a working passwd, and ability to now get going. I'll eventually understand how the cnf file is involved maybe. ------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
