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

Posted on 2004-09-01
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
Question by:micro_learner
  • 3
  • 2
LVL 19

Expert Comment

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


Author Comment

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

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/ 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
LVL 19

Expert Comment

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.

Author Comment

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/': 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

LVL 19

Accepted Solution

ramazanyich earned 500 total points
ID: 11957655
use following option for mysqld --basedir=/home/myName/mysql/var

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

Network Interface Card (NIC) bonding, also known as link aggregation, NIC teaming and trunking, is an important concept to understand and implement in any environment where high availability is of concern. Using this feature, a server administrator …
Setting up Secure Ubuntu server on VMware 1.      Insert the Ubuntu Server distribution CD or attach the ISO of the CD which is in the “Datastore”. Note that it is important to install the x64 edition on servers, not the X86 editions. 2.      Power on th…
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…
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.

864 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

18 Experts available now in Live!

Get 1:1 Help Now