Solved

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

Posted on 2004-09-01
5
279 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
  • 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

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

Daily system administration tasks often require administrators to connect remote systems. But allowing these remote systems to accept passwords makes these systems vulnerable to the risk of brute-force password guessing attacks. Furthermore there ar…
This is the error message I got (CODE) Error caused by incompatible libmp3lame 3.98-2 with ffmpeg I've googled this error message and found out sometimes it attaches this note "can be treated with downgrade libmp3lame to version 3.97 or 3.98" …
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…
Connecting to an Amazon Linux EC2 Instance from Windows Using PuTTY.

757 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

17 Experts available now in Live!

Get 1:1 Help Now