LinuxQuestions.org
Review your favorite Linux distribution.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 08-02-2005, 07:15 PM   #1
Raggit
Member
 
Registered: Oct 2003
Location: N.C USA
Distribution: Fedora Core 4
Posts: 65

Rep: Reputation: 15
MySQL 4.1 install


Hey everyone, let me give you an overview of what I've been doing to bring you up to speed.
I tried to upgrade MySQL 3.23 to 4.1 and as everyone knows you get dependency problems. So I thought why not just get rid of 3.23 all together and try to install 4.1 fresh. Well this is what I get when i attempt to do as i just explained.....

Code:
rpm -i MySQL-server-4.1.13-0.i386.rpm
warning: MySQL-server-4.1.13-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
        package MySQL-server-4.1.13-0 is already installed
[root@localhost mark]# rpm -q MySQL
package MySQL is not installed
Maybe someone can point me in the propper direction...
Becareful i'm somewhat of a newb here, so don't work me over with lingo....Thanks
 
Old 08-02-2005, 07:39 PM   #2
reddazz
LQ Guru
 
Registered: Nov 2003
Location: N. E. England
Distribution: Fedora, CentOS, Debian
Posts: 16,298

Rep: Reputation: 75
Try,
Code:
$rpm -qa | grep - mysql
 
Old 08-02-2005, 11:01 PM   #3
Raggit
Member
 
Registered: Oct 2003
Location: N.C USA
Distribution: Fedora Core 4
Posts: 65

Original Poster
Rep: Reputation: 15
The following is what ended up with that command....

Code:
 rpm -qa | grep mysql
libdbi-dbd-mysql-0.6.5-9
mysqlclient10-3.23.58-6
 
Old 08-03-2005, 01:40 PM   #4
reddazz
LQ Guru
 
Registered: Nov 2003
Location: N. E. England
Distribution: Fedora, CentOS, Debian
Posts: 16,298

Rep: Reputation: 75
Uninstall those packages, then do
Code:
#rpm --rebuilddb
Once thats done, install your mysql packages. You may also think of upgrading to FC4 if its an option for you because it has newer packages which are still being updated.
 
Old 08-05-2005, 02:00 PM   #5
Raggit
Member
 
Registered: Oct 2003
Location: N.C USA
Distribution: Fedora Core 4
Posts: 65

Original Poster
Rep: Reputation: 15
Ok I've been round and round the mulberry bush with this thing and I keep ending up at the same berry. Can someone please point me in the proper direction....
Thanks

Code:
[root@localhost ~]# cd /home/mark/
[root@localhost mark]# rpm -i MySQL-server-4.1.13-0.i386.rpm
warning: MySQL-server-4.1.13-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
        package MySQL-server-4.1.13-0 is already installed
[root@localhost mark]# rpm -e MySQL-server-4.1.13-0
[root@localhost mark]# rpm -i MySQL-server-4.1.13-0.i386.rpm
warning: MySQL-server-4.1.13-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
chown: `mysql:mysql': invalid user
chown: `mysql': invalid user
050805 14:41:33 [Warning] Asked for 196608 thread stack, but got 126976
050805 14:41:33 [ERROR] Fatal error: Can't change to run as user 'mysql' ;  Please check that the user exists!

050805 14:41:33 [ERROR] Aborting

050805 14:41:33 [Note] /usr/sbin/mysqld: Shutdown complete

Installation of system tables failed!

Examine the logs in /var/lib/mysql for more information.
You can also try to start the mysqld daemon with:
/usr/sbin/mysqld --skip-grant &
You can use the command line tool
/usr/bin/mysql to connect to the mysql
database and look at the grant tables:

shell> /usr/bin/mysql -u root mysql
mysql> show tables

Try 'mysqld --help' if you have problems with paths. Using --log
gives you a log in /var/lib/mysql that may be helpful.

The latest information about MySQL is available on the web at
http://www.mysql.com
Please consult the MySQL manual section: 'Problems running mysql_install_db',
and the manual section that describes problems on your OS.
Another information source is the MySQL email archive.
Please check all of the above before mailing us!
And if you do mail us, you MUST use the /usr/bin/mysqlbug script!
chown: `mysql:mysql': invalid user
Starting MySQL...................................[FAILED]
 
Old 08-05-2005, 07:44 PM   #6
hlyrad
Member
 
Registered: Jul 2005
Location: Ab Ca
Distribution: Redhat EL Sun Mac OSX FC 3.0 & 4.0
Posts: 44

Rep: Reputation: 15
Quote:
Originally posted by Raggit
Code:
chown: `mysql:mysql': invalid user
chown: `mysql': invalid user
050805 14:41:33 [Warning] Asked for 196608 thread stack, but got 126976
050805 14:41:33 [ERROR] Fatal error: Can't change to run as user 'mysql' ;  Please check that the user exists!
Does the user mysql exist?? If not create
Code:
useradd -d /dev/null -s /bin/false mysql
Also there are binary distros available from www.mysql.com that work without rpm.
 
Old 08-23-2005, 03:07 AM   #7
lk95jofr
LQ Newbie
 
Registered: Aug 2005
Location: Barcelona, Spain
Distribution: Fedora 3
Posts: 5

Rep: Reputation: 0
Quote:
Originally posted by Raggit
The following is what ended up with that command....

Code:
 rpm -qa | grep mysql
libdbi-dbd-mysql-0.6.5-9
mysqlclient10-3.23.58-6

FYI
That is because you searched for mysql and NOT MySQL.

rpm -qa | egrep "sql|SQL"

will give you a different result including your installed MySQL server

/Fredrik
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Bugzilla - MySQL - perl - DBD::mysql install problem Runningonair Linux - Software 8 10-12-2007 12:42 AM
mysql error Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. Dannux Linux - Software 3 03-24-2006 08:44 AM
DBD::MySQL + MySQL install problems. Elleroth Linux - Software 4 03-24-2006 06:53 AM
MySQL 4 on Fedora can't install php-mysql kennyg Linux - Software 8 09-21-2004 06:54 PM
MySQL mysql-3.23.56-1.9, rpm install problem jacsmith510 Linux - Newbie 3 09-19-2003 02:02 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 01:06 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration