List:General Discussion« Previous MessageNext Message »
From:Baron Schwartz Date:February 1 2009 12:42am
Subject:Re: newbie config help needed
View as plain text  
Dave,

Log in as the user you intend to set up for them.  Issue the following:

show grants;
select @@sql_mode;

If you aren't sure how to interpret the information I will direct you
to the manual: http://dev.mysql.com/doc/refman/5.0/en/

Side note: I would upgrade.  5.0.45 has some pretty serious bugs.  I'd
upgrade to the latest 5.0 release.

Baron

On Sat, Jan 31, 2009 at 4:13 PM, Dave Stevens <geek@stripped> wrote:
> Hello all,
>
> I have set up a little server and am pitching to an organization to host their
> upcoming new site. The box is Centos 5.2 up to date and mysql  5.0.45. The
> requirements below must be met but I don't know how to verify their status.
> Can someone point me in the right direction. Will read directions if
> necessary....
>
> Dave
>
>
>
>   * Your server must have the following MySQL grant privileges (for
> tables): SELECT, INSERT, UPDATE, DELETE, DROP, ALTER, CREATE
>    * Your MySQL server must not be running in Strict mode.
>
>
> --
> Canada must refuse to be entangled in any more wars fought to make the world
> safe for capitalism.
>
> -- The Regina Manifesto, 1933
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>
>



-- 
Baron Schwartz, Director of Consulting, Percona Inc.
Our Blog: http://www.mysqlperformanceblog.com/
Our Services: http://www.percona.com/services.html
Thread
newbie config help neededDave Stevens31 Jan
  • Re: newbie config help neededBaron Schwartz1 Feb
  • Re: newbie config help neededGuenther Boelter1 Feb