Solved

Setting up Mysql db Server on my home directory without root previlages

Posted on 2004-09-01
5
287 Views
Last Modified: 2013-12-15
hello Evreyone ...I know this is probably not the right forumn ...but I am taking a chance

I am trying to set up a mysql db server  on my local machine...(in my home directory)I do not have the root passowrd.Please direct me on how I should I get started.Should I use a Binary version or the source distribution.In either case how should I get started .i would appreciate your help .

Thanks for u'r time
 
0
Comment
Question by:micro_learner
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 19

Expert Comment

by:ramazanyich
ID: 11956586
You should use source and add parameter during calling configure script:
mysql-src>./condifure --prefix=/home/user/mysql

then during make install mysql will be installed into /home/user/mysql

0
 

Author Comment

by:micro_learner
ID: 11957017
I tried ..but I seem to get an error i donno where and what ...I appreciate your time and effort

I downloaded the source from http://dev.mysql.com/downloads/mysql/4.0.html#Source

and I ran the confogure command  pointing to a location on local machine
************************************************************
user@server$./configure prefix=/home/myName/mysql

user@server$ make    
// This seemed to work fine

user@server$make test
//I got the following message and error

nstalling Test Databases
Removing Stale Files
Installing Master Databases
running  ../sql/mysqld --no-defaults --bootstrap --skip-grant-tables     --basedir=. --datadir=./var/master-data --skip-innodb --skip-bdb --skip-warnings --language=../sql/share/english/
040901 18:22:52  ../sql/mysqld: Shutdown Complete

Installing Slave Databases
running  ../sql/mysqld --no-defaults --bootstrap --skip-grant-tables     --basedir=. --datadir=./var/slave-data --skip-innodb --skip-bdb --skip-warnings --language=../sql/share/english/
040901 18:22:53  ../sql/mysqld: Shutdown Complete

Manager disabled, skipping manager start.
Loading Standard Test Databases
Starting Tests

 TEST                           RESULT
------------------------------------------
alias                          [ pass ]
alter_table                    [ pass ]
analyse                        [ pass ]
ansi                           [ pass ]
auto_increment                 [ pass ]
backup                         [ pass ]
bdb-alter-table-1              [ skipped ]
bdb-alter-table-2              [ skipped ]
bdb-crash                      [ skipped ]
bdb-deadlock                   [ skipped ]
bdb                            [ skipped ]
bdb_cache                      [ skipped ]
bench_count_distinct           [ pass ]
bigint                         [ pass ]
binary                         [ pass ]
bool                           [ pass ]
bulk_replace                   [ pass ]
case                           [ pass ]
cast                           [ pass ]
check                          [ pass ]
comments                       [ pass ]
compare                        [ pass ]
constraints                    [ pass ]
convert                        [ pass ]
count_distinct                 [ pass ]
count_distinct2                [ pass ]
create                         [ pass ]
ctype_cp1251                   [ pass ]
ERROR: /home/myName/downloads/mysql-4.0.20/mysql-test/var/run/master.pid was not created in 30 seconds;  Aborting
make: *** [test] Error 1

*********************
Inspite of the error I installed

$user@server$ make install
// This seesed to wok fine
***************************

But following the instructions online I tried to create a "groupadd" command that didi not work..and said that the command was not found.

Am I missing something please help me on this
0
 
LVL 19

Expert Comment

by:ramazanyich
ID: 11957177
you don't have to do groupadd because it should be used if you install mysql as root and you want to start it as non-root user (mysql in tutorial).
In your case just start mysql server and access it using mysql command.
0
 

Author Comment

by:micro_learner
ID: 11957524
Thanks for the patience ...

When I look up the directory structure obtained after compiling I do not see the same strcuture that is supposed to be (from the tutorial)

It misses the dir "scripts" which  is used to prepare mysql for operation

from the tutorial
******************************************************
9. Run the initialization script, mysql_install_db, which ships with the program, to prepare MySQL for operation:

[root@host]# /usr/local/mysql/scripts/mysql_install_db
******************************************************

Also when I try to run the mysqld deamon
I get the following error
*******************************************************
ommidi@myName:~/mysql/bin$ mysqld_safe
Starting mysqld daemon with databases from /var/lib/mysql
/usr/bin/mysqld_safe: line 308: /var/lib/mysql/myName.err: Permission denied
rm: cannot remove `/var/lib/mysql/myName.pid': Permission denied
/usr/bin/mysqld_safe: line 314: /var/lib/mysql/myName.err: Permission denied
tee: /var/lib/mysql/myName.err: Permission denied
040901 16:14:52  mysqld ended
tee: /var/lib/mysql/myName.err: Permission denied

**************************************************
It seems to be looking at the default places and not the home ..

Aprreciate your patience

0
 
LVL 19

Accepted Solution

by:
ramazanyich earned 500 total points
ID: 11957655
use following option for mysqld --basedir=/home/myName/mysql/var
check http://dev.mysql.com/doc/mysql/en/Starting_server.html
0

Featured Post

[Webinar] How Hackers Steal Your Credentials

Do You Know How Hackers Steal Your Credentials? Join us and Skyport Systems to learn how hackers steal your credentials and why Active Directory must be secure to stop them. Thursday, July 13, 2017 10:00 A.M. PDT

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Over the last ten+ years I have seen Linux configuration tools come and go. In the early days there was the tried-and-true, all-powerful linuxconf that many thought would remain the one and only Linux configuration tool until the end of times. Well,…
Using 'screen' for session sharing, The Simple Edition Step 1: user starts session with command: screen Step 2: other user (logged in with same user account) connects with command: screen -x Done. Both users are connected to the same CLI sessio…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

688 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