#1
  1. Full Access
    Devshed Regular (2000 - 2499 posts)

    Join Date
    Jun 2000
    Location
    London, UK
    Posts
    2,019
    Rep Power
    17
    I'm attempting to install MySQL on my Red Hat Linux box (now running KDE). Whilst I had it working before under GNOME, I reformatted because it had ceased to work when I corrected a hostname mistake I had made on install.

    However, it now won't install at all! I am following the "Setting up database driven websites" article from Devshed to try and get it installed. I get as far as the part when you run the /usr/local/mysql/scripts/mysql_install_db script, and when I try and do that, everything goes pear-shaped. I get this:

    [mysql@localhost mysql]$ scripts/mysql_install_db
    Creating db table
    Creating host table
    Creating user table
    Creating func table
    Creating table_priv table
    Creating column_priv table
    ERROR: 1062 Duplicate entry `localhost-root` for key 1
    ERROR: 1062 Duplicate entry `localhost-` for key 1

    To start mysql at boot time ....

    My guess is that when the script tries to create the column_priv table, two entries try and use the same value for a primary key. But what would these be, and how can I remedy the problem???

    --------------------------------------------
    Alex
    (http://www.alex-greg.co.uk)
  2. #2
  3. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2000
    Location
    lexington, ky, USA
    Posts
    5
    Rep Power
    0
    so your having problems installing it? or setting up the databases?

    ------------------
    -Casey
  4. #3
  5. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2000
    Location
    lexington, ky, USA
    Posts
    5
    Rep Power
    0
    if its an install problem, then

    1. login as root, or use "su"
    2. ftp to ftp.mysql.com username=anonymous password=(your email address)
    3. change directory to MySQL-3.22 (note, it is case sensitive)
    4. get MySQL-client-3.22.32-1.rpm (note, it is case sensitive)
    5.exit from ftp with "bye"
    6. go to http://www.mysql.com/documentation/m...tion=Linux-RPM
    7.follow the instructions step by step.
    8. DO NOT RESTART mysqld until you are sure it will restart, this happened to me, and i had to spend quite a while getting it back up.


    ------------------
    -Casey
  6. #4
  7. Full Access
    Devshed Regular (2000 - 2499 posts)

    Join Date
    Jun 2000
    Location
    London, UK
    Posts
    2,019
    Rep Power
    17
    "get MySQL-client-3.22.32-1.rpm"

    Doesn't exist: instead there are:

    MySQL-client-3.22.32-1.alpha.rpm
    MySQL-client-3.22.32-1.i386.rpm
    MySQL-client-3.22.32-1.mips.rpm
    MySQL-client-3.22.32-1.ppc.rpm

    Which one? I'm running Red Hat on an i486

    --------------------------------------------
    Alex
    (http://www.alex-greg.co.uk)
  8. #5
  9. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2000
    Location
    Seattle, WA USA
    Posts
    23
    Rep Power
    0
    You will want to use i386 versions for your Intel 486 chip.

Similar Threads

  1. need help.. linux install sata abit kv7
    By 240ofterrorr in forum Linux Help
    Replies: 2
    Last Post: September 14th, 2004, 04:35 PM
  2. Linux 9.0 Red Hat
    By Christpher7 in forum Linux Help
    Replies: 4
    Last Post: February 2nd, 2004, 03:26 PM
  3. Red Hat Linux v8 Some Questions
    By TheGoldeagle in forum Linux Help
    Replies: 2
    Last Post: January 10th, 2004, 11:49 AM
  4. Strange Linux install
    By anubius in forum Linux Help
    Replies: 6
    Last Post: January 7th, 2004, 02:13 AM
  5. what linux system should i install?
    By dave2k in forum Linux Help
    Replies: 5
    Last Post: January 3rd, 2004, 04:06 PM

IMN logo majestic logo threadwatch logo seochat tools logo