How to replace a installed mysql version?

2004-04-13 Thread Walter Andreas
Hi there, I am a bit confused. It is not clear to me that the version I am currently running is the one I compiled last. How can I check the date of compiling? In order to get more performance I did try to install mysql 4.0.18 with different configure commands, now I am not sure if the make

Installed MySQL but can't connect

2004-03-24 Thread Kevin Carpenter
I've installed MySQL and started the server with: mysqld_safe I've confirmed the server is running with: ps -ef | grep mysql and mysqladmin status —-- I'm trying to connect using: shell mysql -u root -p It says 'command not found' - I find the mysql command location

Re: Installed MySQL but can't connect

2004-03-24 Thread Paul DuBois
At 13:24 -0500 3/24/04, Kevin Carpenter wrote: I've installed MySQL and started the server with: mysqld_safe I've confirmed the server is running with: ps -ef | grep mysql and mysqladmin status --- I'm trying to connect using: shell mysql -u root -p It says 'command not found

Can't Start Deamon - Installed MySQL 4.0.15 using YaST (SuSE 9.0 Pro)

2004-03-23 Thread Kevin Carpenter
Ye That Know, Short: Does YaST really install MySQL 'all-the-way', or do I now need to run 'make' and/or 'make install', or other similar commands? Long: Previously last week I had installed MySQL using rpm as detailed in a SAMS book http://tinyurl.com/2pq27 It installed fine and worked ok

Re: Can't Start Deamon - Installed MySQL 4.0.15 using YaST ( SuSE 9.0 Pro)

2004-03-23 Thread Kevin Carpenter
James, I try to start it at the command line using - mysql, mysqld, mysqld_safe - I've tried it as root and non-root. Yes, I get errors - they were listed in my origional post - I don't have then handy now. - I tired mysqld_safe, as you suggested, it bombed but the good thing

Re: Can't Start Deamon - Installed MySQL 4.0.15 using YaST ( SuSE 9.0 Pro)

2004-03-23 Thread Victoria Reznichenko
Kevin Carpenter [EMAIL PROTECTED] wrote: I try to start it at the command line using - mysql, mysqld, mysqld_safe - = I've tried it as root and non-root. Yes, I get errors - they were listed in my origional post - I don't have = then handy now. - I tired mysqld_safe,

RE: Can't Start Deamon - Installed MySQL 4.0.15 using YaST ( SuSE 9.0 Pro)

2004-03-23 Thread Odom, Duwayne
You need to install the default databases. -Original Message- From: Kevin Carpenter [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 23, 2004 11:32 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: Can't Start Deamon - Installed MySQL 4.0.15 using YaST ( SuSE 9.0 Pro) James, I

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

installed mysql

2002-11-12 Thread Bhavul Chauhan
*This message was transferred with a trial version of CommuniGate(tm) Pro* I have recently loaded mysql on macosx 10.2 It has loaded it in the directroy /library/mysql presently I have my user prompt on the terminal screen. I know that I need the sql prompt in order to be able to issue sql

when I installed mysql 3.23.43

2002-08-17 Thread Dave Reinhardt
when I installed mysql 3.23.43 it instructed me to be sure to add a password with the following results- : seaport2:/# /usr/mysql/bin/mysqladmin -u root -p password 'new-password' Enter password: /usr/mysql/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user

Re: *****SPAM***** when I installed mysql 3.23.43

2002-08-17 Thread David Lloyd
Dave [ mysql query] when I installed mysql 3.23.43 it instructed me to be sure to add a password with the following results- : seaport2:/# /usr/mysql/bin/mysqladmin -u root -p password 'new-password' Enter password: /usr/mysql/bin/mysqladmin: connect to server at 'localhost' failed

Pre-installed MySQL from Redhat 7.0

2001-01-12 Thread Marc Kidwell Pestana
Fellow travelers, I'm a MySQL debutant. I have no experience with it (other than not being able to get it to work on my Dell PowerEdge 1400 server running RedHat Linux 7.0). Is the RedHat Linux 7.0 distribution of MySQL a satisfactory or difficult one to use. Is it a good idea to buy a