Help answer threads with 0 replies.
Go Back > Forums > Linux Forums > Linux - Newbie
User Name
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!


  Search this Thread
Old 05-03-2011, 04:56 AM   #1
LQ Newbie
Registered: Mar 2011
Posts: 19

Rep: Reputation: 0
Smile Steps to install MYSQL as non-root user

Hi all,

I like to share you all how to install mysql binary installation as non-root user.

Step:1 Download mysql binary package from mysql website.

Step:2 change the ownership for folder mysql $ chown mysql:mysql /usr/local/mysql ( only this step should be done by root user)

Step:3 $ move the downloaded tar file to /usr/local/mysql and tar -zxvf <filename>.tar.gz

Step:4 $scripts/mysql_install_db --user=mysql ( mysql database got installed)

Step:5 Starting mysql services: $ ./bin/support-files/mysql.server start

Step:6 Login to mysql database $./bin/mysql -u root -p

Step:7 To stop services $ ./bin/support-files/mysql.server stop

You can try and provide feedback.we are ready to help you

Old 05-03-2011, 05:09 AM   #2
Senior Member
Registered: Jun 2008
Location: Eelam
Distribution: Redhat, Solaris, Suse
Posts: 1,274

Rep: Reputation: 148Reputation: 148
This is the way I follow, Installation not so difficult because there should be README or Installation file in most of the source packages..
shell> groupadd mysql
shell> useradd -g mysql mysql
shell> gunzip < mysql-VERSION.tar.gz | tar -xvf -
shell> cd mysql-VERSION
shell> ./configure --prefix=/usr/local/mysql
shell> make
shell> make install
shell> cp support-files/my-medium.cnf /etc/my.cnf
shell> cd /usr/local/mysql
shell> bin/mysql_install_db --user=mysql
shell> chown -R root .
shell> chown -R mysql var
shell> chgrp -R mysql .
shell> bin/mysqld_safe --user=mysql &



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
Steps to install Mysql 5.1 on RHEL 4 vamsi_k Linux - Newbie 1 08-24-2008 02:55 AM
MySQL Root User problems nitro_punk85 Linux - Server 2 10-17-2007 08:52 PM
Duplicate root user in MySQL buddhahat Linux - Newbie 4 08-29-2004 10:34 PM
Starting mysql daemon as user rather than root arubin Slackware 8 05-10-2004 04:03 PM
Connect to mysql as non root(linux) user dublinclontarf Slackware 1 02-09-2004 04:19 AM > Forums > Linux Forums > Linux - Newbie

All times are GMT -5. The time now is 04:59 AM.

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