--- 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>
> > 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
> > > > 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
> > your setups.
> > > > >
> > > > > For a better situation, I would suggest
> > if you are averse to
> > > > > installing MySQL system-wide,to at
> > 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
> > some
> > > aggregation operations' execution.)
> > It does. But you can do 'make install' once, then
> > the installed
> > mysqld and replace it with a symlink to your mysqld
> > in the source
> > tree. Then you won't need to install anymore,
> recompile and
> > run.
> > Regards,
> > Sergei
> 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
> 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.
Well, out of curiosity i tried without the --user option:
And it succeeds.
However, when i start the daemon mysqld either from
it says :
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
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 &
[root@localhost bin]# 100325 00:07:52 mysqld_safe Logging to
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
and when i press Enter,
+ Done mysqld_safe
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?
Your Mail works best with the New Yahoo Optimized IE8. Get it NOW!