MySql installation in Linux

Posted on 2005-04-14
Last Modified: 2013-12-06
Any advice on how to install a MySQL Server 4.1.11 rpm package in my Fedora core2 Linux box.

I tried the manual help and got this error:


[root@localhost/localdomain root]# rpm -i MySQL-server-4.1.11-0.i386.rpm
050414 23:05:33 [Warning] Asked for 196608 thread stack, but got 126976
050414 23:05:33 [Warning] Asked for 196608 thread stack, but got 126976
To do so, start the server, then issue the following commands:
/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h localhost/localdomain password 'new-password'
See the manual for more instructions.
NOTE:  If you are upgrading from a MySQL <= 3.22.10 you should run
the /usr/bin/mysql_fix_privilege_tables. Otherwise you will not be
able to use the new GRANT command!
Please report any problems with the /usr/bin/mysqlbug script!
The latest information about MySQL is available on the web at
Support MySQL by buying support/licenses at
Starting MySQL................................... ERROR!


Is there any "detail" error log stored somewhere?
Question by:sangeetha
    LVL 8

    Expert Comment

    Look /var/log/messages, /var/log/mysql.log
    LVL 19

    Expert Comment

    It seems like you already have previous version of mysql which is started.
    First shutdown already running mysql server.
    LVL 2

    Assisted Solution

    add -vv like this will do the trick.

    rpm -i -vv MySQL-server-4.1.11-0.i386.rpm

    if you are trying to upgrade mysql to a new version.
    rpm -U -vv MySQL-server-4.1.11-0.i386.rpm
    LVL 2

    Author Comment

    >> It seems like you already have previous version of mysql which is started.

    Can you say me how!
    LVL 2

    Author Comment


    Thanks but it results in the same problem. :(
    LVL 2

    Expert Comment

    if you have mysql runing run this

    /etc/rc.d/init.d/mysql stop
    LVL 19

    Accepted Solution

    first check if it is running by executing command:
    #ps -ef | grep mysql  | grep -v grep

    then if it is appear as line. For example:
    root     10503     1  0 08:55 pts/0    00:00:00 /bin/sh /usr/bin/safe_mysqld --user=mysql --pid-file=/var/lib/mysql/ --socket=/var/lib/mysql/mysql.sock --datadir=/var/lib/mysql

    then you can stop it using:
    #/etc/init.d/mysql stop
    LVL 7

    Assisted Solution

    rpm -qa | grep -i mysql

    For any matches, do "rpm -e package-name", including the one you just installed.  You may need to specify multiple packages at once if you get dependency errors, e.g. "rpm -e mysql-server mysql-client mysql-shared"

    WARNING: This may result in the removal of any existing databases.  If you have existing data, do NOT do this, any of this.

    Make sure you rm -rf /var/lib/mysql (will permanently delete any previously created databases, including MySQL's base database)

    When installing, always first check that there isn't a prior version (MySQL releases their packages as MySQL-version, whereas distro vendors usually name them mysql-version, in the lower-case form).  Also, always use rpm -U rather than -i, so that you don't end up with duplicate versions by mistake.

    If you remove all packages and still get the error on installation, there is other problems, and this could be the result of user limits, SELinux mode, etc.  Start with "ulimit -a" command to check if any limits are listed (should say "unlimited" a lot, except for core file size, which is unimportant for this).

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    If you have a server on collocation with the super-fast CPU, that doesn't mean that you get it running at full power. Here is a preamble. When doing inventory of Linux servers, that I'm administering, I've found that some of them are running on l…
    SSH (Secure Shell) - Tips and Tricks As you all know SSH(Secure Shell) is a network protocol, which we use to access/transfer files securely between two networked devices. SSH was actually designed as a replacement for insecure protocols that sen…
    Learn several ways to interact with files and get file information from the bash shell. ls lists the contents of a directory: Using the -a flag displays hidden files: Using the -l flag formats the output in a long list: The file command gives us mor…
    Learn how to navigate the file tree with the shell. Use pwd to print the current working directory: Use ls to list a directory's contents: Use cd to change to a new directory: Use wildcards instead of typing out long directory names: Use ../ to move…

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now