Solved

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

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

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

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

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…
Linux users are sometimes dumbfounded by the severe lack of documentation on a topic. Sometimes, the documentation is copious, but other times, you end up with some obscure "it varies depending on your distribution" over and over when searching for …
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…
Connecting to an Amazon Linux EC2 Instance from Windows Using PuTTY.

839 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