Well, I finally got that portion working. After I putzed around for awhile, I said to myself - Self, With all this putzing, I probably need to restart the mysqld server. So I tried that from linuxconf and for some reason it just didn't want to restart! So, I went and did a /etc/rc5.d/S85mysqld stop and then a /etc/rc5.d/S85mysqld start. Low and behold, I could now change the password from a blank to meg123. So now my next question is how do I add users? Do I do that from the mysql database?? Tx for your help "mysql-return-64843-gaal=ct.marconimed.com"@lists.mysql.com on 02/10/2001 01:06:43 PM To: "Aaron Sinclair" <[EMAIL PROTECTED]> cc: [EMAIL PROTECTED] (bcc: Lad Gaal/MarconiMedical) Subject: Re: Newbie Questions You're correct in that /var/lib/mysql/mysql/* was not owned by mysql. I did a chown mysql.mysql and then did a chmod 775 on the directory. So I still get basically the same thing. I enter: mysqladmin -u root -p password meg123 Enter password: (I leave it blank and CR) mysqladmin: unable to change password; error: 'Table 'user' is read only' But if I enter: mysqladmin -u root -p password meg123 (cr) Enter password: meg123 (CR) mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: YES)' I'm open for suggestions.... TX "Aaron Sinclair" <[EMAIL PROTECTED]> on 02/09/2001 08:20:16 PM To: Lad Gaal/MarconiMedical@Marconi cc: Subject: Re: Newbie Questions check that /var/lib/mysql/mysql/* are owned by mysql and have read write premissions. I am hanging out at www.mercylink.com/chat/chat.php chat server for a while if you want to talk about it. Aaron Sinclair ----- Original Message ----- From: <[EMAIL PROTECTED]> To: "Aaron Sinclair" <[EMAIL PROTECTED]> Sent: Saturday, February 10, 2001 2:05 PM Subject: Re: Newbie Questions > > > I just tried mysqladmin -u root password meg123 > the return was: mysqladmin: unable to change password; error: 'Table 'user' is > read only' > > I then tried running the mysql_install_db again and then typed > mysqladmin -u root -p password meg123 > the response was t enter the password which I left blank and hit return > and got: mysqladmin: unable to change password; error: 'Table 'user' is read > only' > > I installed MYSQL during the redhat 7 install. Do I need a .cnf file someplace > like in /etc. I think I saw a mf.cnf file that I need to copy from > /usr/share/mysql/my-medium.cnf. I feel like it's something simple, but I just > can't grasp it. Things were so much easier with postgresql. > This is what I get for trying to advance!!! > Tx... > > > > > "Aaron Sinclair" <[EMAIL PROTECTED]> on 02/09/2001 06:22:26 PM > > To: Lad Gaal/MarconiMedical@Marconi > cc: > > Subject: Re: Newbie Questions > > > > after running the mysql_install scripts.. > > mysqladmin -uroot password password > > mysql requires you to specify what user you are ie > mysql -u<username> -p<this prompts for a password> > > ----- Original Message ----- > From: <[EMAIL PROTECTED]> > Newsgroups: mailing.database.mysql > Sent: Saturday, February 10, 2001 11:22 AM > Subject: Newbie Questions > > > > > > > > Just got mysql running (Ithink) on Redhat Linux 7. The version is > > mysqladmin Ver 8.8 Distrib 3.23.22-beta, for redhat-linux-gnu on i386 > > TCX Datakonsult AB, by Monty > > > > Server version 3.23.22-beta-log > > Protocol version 10 > > Connection Localhost via UNIX socket > > UNIX socket /var/lib/mysql/mysql.sock > > > > So how do I change/add passwords for the users and how do I add users? > > I tried 'mysqladmin password newpassword' (where newpassword is my > password) > > The response I get is: 'mysqladmin: unable to change password; error: 'You > are > > using MySQL as an anonym' ' > > So then I switch to superuser and try again. > > The response I get is: 'mysqladmin: unable to change password; error: > 'Table > > 'user' is read only' ' > > I try : 'mysqladmin -password newpassword' > > The response is: 'mysqladmin: connect to server at 'localhost' failed > > error: 'Access denied for user: 'root@localhost' (Using password: YES)' > > > > So how the heck do I do this?? > > > > Thanks > > > > ____________________ > > Lad. Gaal > > > > > > > > > > > > --------------------------------------------------------------------- > > 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 > > > > > > > --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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
