OK, here's the setup:
Using the binary package in mysql-3.23.47-sun-solaris2.8-sparc.tar.gz all unpacked, untarred (with gtar, yes), etc. I follow all the instructions in the INSTALL-BINARY file, with this one change: I intend for the user to be mysql_st, not mysql. But according to note #4 in the INSTALL-BINARY file this should be okay, although it does not say whether this necessitates any changes elsewhere in the installation. Oh, and also the data directory in /usr/local/mysql is softlinked to another drive with much more space. Permissions on that directory are set to the mysql_at user with the rest set to root, as described in the INSTALL-BINARY file. And yes, I ran the scripts/mysql_install_db script. OK, so here is what I have now: I can connect to mysql as mysql -u root and no password is needed. So according to page 414 of the MySQL book I need to run mysqladmin -u root password to fix this. BUT!! Everytime I try to do this, whether as myself, as the mysql_st user, or even as root, I get this: [4:17pm] cindy@steph> /usr/local/mysql/bin/mysqladmin -u root password "kool" /usr/local/mysql/bin/mysqladmin: unable to change password; error: 'You must have privileges to update tables in the mysql database to be able to change passwords for others' At the same time: [4:17pm] cindy@steph> mysql -u root Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 15 to server version: 3.23.44 Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> works fine (again, no matter "who" I am) Eh? Now, what I'm guessing is that I should be using GRANTS to set this up, as outlined in the online manual in section 4.3.6 (Setting up Passwords). But before I muck around much more, I'd like some assurance that I'm on the right track, or whether I've flubbed something else that should be taken care of instead. Particularly because according to this section, doing the insert into the user table should be exactly equivalent to the mysqladmin command that fails above. I also wonder if maybe the INSTALL-BINARY file should include a brief note on setting up a root password, even if just a pointer or whatever. Thanks, --Cindy -- [EMAIL PROTECTED] --------------------------------------------------------------------- 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
