List:Internals« Previous MessageNext Message »
From:Karthik Gurukuntala Date:March 24 2010 6:41pm
Subject:Re: MySQL execution
View as plain text  
--- On Wed, 24/3/10, Karthik Gurukuntala <kgurukuntala@stripped> wrote:

> From: Karthik Gurukuntala <kgurukuntala@stripped>
> Subject: Re: MySQL execution
> To: "Sergei Golubchik" <sergii@stripped>
> Cc: internals@stripped
> Date: Wednesday, 24 March, 2010, 6:26 PM
> 
> 
> --- On Tue, 23/3/10, Sergei Golubchik <sergii@stripped>
> wrote:
> 
> > From: Sergei Golubchik <sergii@stripped>
> > Subject: Re: MySQL execution
> > To: "Karthik Gurukuntala" <kgurukuntala@stripped>
> > Cc: internals@stripped
> > Date: Tuesday, 23 March, 2010, 8:48 AM
> > Hi, Karthik!
> > 
> > On Mar 23, Karthik Gurukuntala wrote:
> > > > --- On Mon, 22/3/10, Patrick Galbraith
> <patg@stripped>
> > > > wrote:
> > > > 
> > > > > From: Patrick Galbraith <patg@stripped>
> > > > > Subject: Re: MySQL execution
> > > > > To: "Karthik Gurukuntala" <kgurukuntala@stripped>
> > > > > Cc: internals@stripped
> > > > > Date: Monday, 22 March, 2010, 5:10 PM
> > > > > Karthik Gurukuntala wrote:
> > > > > > how to execute the compiled mysql
> > without make install, always?
> > > > > >
> > > > > Karthik,
> > > > > 
> > > > > You should example MySQL's options for
> > execution "mysqld --help
> > > > > --verbose" and use the proper options
> for
> > your setups.
> > > > > 
> > > > > For a better situation, I would suggest
> that
> > if you are averse to
> > > > > installing MySQL system-wide,to at
> least
> > install MySQL locally
> > > > > using  "./configure
> > --prefix=/home/karthik/mysql_testdir" (chose
> > > > > a name of your liking) and run it from
> > there.
> > > > > 
> > >  Doesnt that require 'make install' at that
> > location
> > >  everytime i re-compile the source with some
> > >  changes?(Actually am debugging the code to
> learn
> > some
> > >  aggregation operations' execution.)
> > 
> > It does. But you can do 'make install' once, then
> delete
> > the installed
> > mysqld and replace it with a symlink to your mysqld
> binary
> > in the source
> > tree. Then you won't need to install anymore,
> recompile and
> > run.
> >  
> > Regards,
> > Sergei
> > 
> 
> Sirs, 
>   I am now installing mysql locally as suggested
> earlier. Then, will do the symlink as mentioned above.
> However, when I try this 
> 
> # bin/mysql_install_db --user=mysql
> 
> ...this error is got.(First few lines...)
> 
> Installing MySQL system tables...
> ERROR: 1  Can't create/write to file
> '/home/albert/install/mysql/var/mysql/db.MYI' (Errcode: 13)
> 100324 23:46:05 [ERROR] Aborting
> 
> 100324 23:46:05 [Note]
> /home/albert/install/mysql/libexec/mysqld: Shutdown
> complete
> 
> 
> Installation of system tables failed!  Examine the
> logs in
> /home/albert/install/mysql/var for more information.
> 
> ...
> And there are no log files as told in the error message.
> 
> What's wrong am I doing here?
> I follow the steps under '2.10.1 Source Installation
> Overview' in the INSTALL-SOURCE file that is in the source
> root folder.
> 
> 
> 
> Regards,
> -Karthik


Well, out of curiosity i tried without the --user option: 

# bin/mysql_install_db

And it succeeds.

However, when i start the daemon mysqld either from 
/home/albert/install/mysql/libexec/
or from
/home/albert/workdir/sql/

it says :

# ./mysqld

100325  0:02:49 [ERROR] Fatal error: Please read "Security" section of the manual to find
out how to run mysqld as root!

100325  0:02:49 [ERROR] Aborting

100325  0:02:49 [Note] ./mysqld: Shutdown complete


So, 
1) Why didnt the mysql_install_db take the --user option?
2) Why the root is not allowed to start the mysqld? How can I make root start it?
3) Even when i try 'mysqld_safe &' inside install/mysql/bin it says :

# mysqld_safe &
[1] 19287
[root@localhost bin]# 100325 00:07:52 mysqld_safe Logging to
'/var/lib/mysql/localhost.localdomain.err'.
100325 00:07:52 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
100325 00:07:52 mysqld_safe mysqld from pid file /var/lib/mysql/localhost.localdomain.pid
ended

and when i press Enter,
[1]+  Done                    mysqld_safe
[root@localhost bin]# 

I used to start mysql this way,starting the mysqld_safe, earlier when i used to install
that in /user/local/mysql. Why am i not able to do that now?

Regards,
-Karthik


      Your Mail works best with the New Yahoo Optimized IE8. Get it NOW!
http://downloads.yahoo.com/in/internetexplorer/

Thread
MySQL executionKarthik Gurukuntala22 Mar
  • Re: MySQL executionPatrick Galbraith22 Mar
  • Re: MySQL executionTimour Katchaounov23 Mar
Re: MySQL executionKarthik Gurukuntala23 Mar
  • Re: MySQL executionSergei Golubchik23 Mar
    • Re: MySQL executionKarthik Gurukuntala23 Mar
      • Re: MySQL executionKarthik Gurukuntala23 Mar
        • Re: MySQL executionTimour Katchaounov23 Mar
      • Re: MySQL executionSergei Golubchik23 Mar
    • Re: MySQL executionKarthik Gurukuntala24 Mar
  • Re: MySQL executionPhilip Stoev23 Mar
  • Re: MySQL executionPatrick Galbraith24 Mar
  • Re: MySQL executionMichael Widenius26 Mar
Re: MySQL executionKarthik Gurukuntala24 Mar