> Hi, > > I have re-read and think I understand a little better (think being the > correct word) > > I have decided to set the root password - and then add some users. > > first of all I tried > > ./mysqladmin -u root password $thenewpassword > > this gave me > > ./mysqladmin: connect to server at 'localhost' failed > error: 'Access denied for user: 'root@localhost' (Using password: NO)' > I decided to then try
Which shows that the connection is successful (that's good) and that you have already set a root password which you need to specify using "-ppassword" (note the lack of a space between the switch and the password). > ./mysqladmin -u root@jordan password $thenewpassword > > this came up with > > ./mysqladmin: unable to change password; error: 'You are using MySQL as an > anony > mous users and anonymous users are not allowed to change passwords' Because you must do this as root@localhost. To reset the root password, follow this procedure: http://www.bitbybit.dk/mysqlfaq/faq.html#ch7_2_0 And some more insight into the privilege system: http://www.bitbybit.dk/mysqlfaq/faq.html#ch11_0_0 / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
