LinuxQuestions.org
Review your favorite Linux distribution.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Distributions > Slackware
User Name
Password
Slackware This Forum is for the discussion of Slackware Linux.

Notices

Reply
 
Search this Thread
Old 06-06-2004, 11:52 PM   #1
absolute0net
Member
 
Registered: Jun 2003
Distribution: Slackware 12.2, CentOS
Posts: 42

Rep: Reputation: 15
MySQL 4.0.15 giving me fits with recent 9.1 slack upgrade


Computer: Dell Inspiron 8600
Processor: P4 w/ Centrino Chip
OS: Slack 9.1

Started with slack 9.0 - everything worked fine but the nic card...fine, so I upgraded to Slack 9.1. everything works fine but mysql!!

during my initial install I did the following:

shell> su mysql
shell> mysql_install_db

Now, when I do the [mysql_install_db] --- this is what I get

*************************************************************
mysql@localhost:/var/lib$ mysql_install_db
Preparing db table
Preparing host table
Preparing user table
Preparing func table
Preparing tables_priv table
Preparing columns_priv table
Installing all prepared tables
ERROR: 1062 Duplicate entry 'localhost-root' for key 1
ERROR: 1062 Duplicate entry 'localhost-root' for key 1
040607 0:38:02 /usr/libexec/mysqld: Shutdown Complete

**********************************************************

and from there, it will not allow me to access mysql..

any ideas?? My head hurts!
 
Old 06-07-2004, 12:34 AM   #2
wrochal
LQ Newbie
 
Registered: Apr 2002
Location: Brazil
Distribution: All
Posts: 4

Rep: Reputation: 0
Lightbulb owner on Mysql

Hi,

Use this comand:

# chown mysql.mysql /var/lib/mysql

the start mysql.

 
Old 06-07-2004, 06:09 AM   #3
absolute0net
Member
 
Registered: Jun 2003
Distribution: Slackware 12.2, CentOS
Posts: 42

Original Poster
Rep: Reputation: 15
root@localhost:/var/lib# chown mysql.mysql /var/lib/mysql
root@localhost:/var/lib# mysql
ERROR 2002: Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (2)
 
Old 06-07-2004, 06:36 AM   #4
Azmeen
Senior Member
 
Registered: May 2003
Location: Malaysia
Distribution: Slackware, LFS, CentOS
Posts: 1,307

Rep: Reputation: 46
wrochal's post is slightly wrong. You should use chown -R mysql:mysql /var/lib/mysql instead.
 
Old 06-07-2004, 06:50 AM   #5
absolute0net
Member
 
Registered: Jun 2003
Distribution: Slackware 12.2, CentOS
Posts: 42

Original Poster
Rep: Reputation: 15
Thanks for your replies -- I've tried it both ways with no success. Still getting errors.

I even rm -rf /var/lib/mysql, removepkg mysql, swaret --installed mysql (again), su to mysql and tried mysql_install_db.....and got the same exact error as described above.
 
Old 06-07-2004, 09:37 AM   #6
Azmeen
Senior Member
 
Registered: May 2003
Location: Malaysia
Distribution: Slackware, LFS, CentOS
Posts: 1,307

Rep: Reputation: 46
OK, step by step...

For now, I'll assume you have mysql installed.

1) su as root.
2) rm -rf /var/lib/mysql
3) cd /var/lib
4) mkdir mysql
5) chown -R mysql:mysql /var/lib/mysql
6) su mysql
7) mysql_install_db

All done
 
  


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
Upgrade from FC 1 to more recent version M$Convert Fedora - Installation 5 06-23-2005 11:57 AM
VSFTP is giving me fits! Swatson Linux - Newbie 2 07-04-2004 09:32 AM
Why is MySQL 4.0.15a giving me fits in Slack 9.1? absolute0net Linux - Newbie 0 06-06-2004 11:47 PM
Recent Slack Convert B. Alec Slackware 10 02-12-2004 10:22 PM
Audio Card ES1879 Giving me Fits ToodC Linux - Software 1 01-06-2001 01:00 PM


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

Main Menu
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
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration