?
Solved

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

Posted on 2004-09-01
5
Medium Priority
?
289 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 2000 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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

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…
In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
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…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.
Suggested Courses
Course of the Month12 days, 19 hours left to enroll

777 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