Newly installed mysql 4.0

2004-03-17 Thread ryan
(newbie warning) Hi, I just removed 3.23 and installed 4 (the first time I have done an installation.) as per the docs I then tried to make a password for root and ran this from SSH root: # /usr/bin/mysqladmin -u root password 'jman77' but got this a reply: /usr/bin/mysqladmin: connect to

Re: Newly installed mysql 4.0

2004-03-17 Thread Paul DuBois
At 10:04 -0800 3/17/04, [EMAIL PROTECTED] wrote: (newbie warning) Hi, I just removed 3.23 and installed 4 (the first time I have done an installation.) as per the docs I then tried to make a password for root and ran this from SSH root: # /usr/bin/mysqladmin -u root password 'jman77' but got

Re: Newly installed mysql 4.0

2004-03-17 Thread Victor Medina
Your mysql server is not running my friend! =) Try /etc/init.d/mysqld start -- this should be able to turn it on! You can not change the passwords with the server off Best Regards On Wed, 2004-03-17 at 14:04, [EMAIL PROTECTED] wrote: (newbie warning) Hi, I just removed 3.23 and installed 4

Re: Newly installed mysql 4.0

2004-03-17 Thread ryan
Hey, thanks for replying. Your mysql server is not running my friend! =) Try /etc/init.d/mysqld start -- this should be able to turn it on! You can not change the passwords with the server off I finally found the correct place to start and did this: /usr/sbin/mysqld start but got back

Re: Newly installed mysql 4.0

2004-03-17 Thread Paul DuBois
At 11:32 -0800 3/17/04, [EMAIL PROTECTED] wrote: Hey, thanks for replying. Your mysql server is not running my friend! =) Try /etc/init.d/mysqld start -- this should be able to turn it on! You can not change the passwords with the server off I finally found the correct place to start and

Re: Newly installed mysql 4.0.

2004-03-17 Thread ryan
Hey, Thanks for replying. I see that my mysql server IS running... Do you have a /var/lib/mysql/mysql.sock file? How about /tmp/mysql.sock? **That didnt work. **And neither did this: [EMAIL PROTECTED] root]# mysqladmin -u root -h 127.0.0.1 variables mysqladmin: connect to server at

Re: Newly installed mysql 4.0.

2004-03-17 Thread Paul DuBois
At 12:24 -0800 3/17/04, [EMAIL PROTECTED] wrote: Hey, Thanks for replying. I see that my mysql server IS running... Do you have a /var/lib/mysql/mysql.sock file? How about /tmp/mysql.sock? **That didnt work. Didn't work? I didn't ask you do try anything, I just asked if either of those files

Re: Newly installed mysql 4.0.

2004-03-17 Thread Paul DuBois
At 21:54 +0100 3/17/04, Ryan A wrote: Hey Paul, error: 'Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)' That's a good sign, actually. Finally a good sign. I means that mysqladmin was able to find the server and attempt to connect to it. That's good. The server rejected