newbie config help needed
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=arch...@jab.org
Re: newbie config help needed
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 g...@uniserve.com 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=ba...@xaprb.com -- Baron Schwartz, Director of Consulting, Percona Inc. Our Blog: http://www.mysqlperformanceblog.com/ Our Services: http://www.percona.com/services.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: newbie config help needed
Hi Dave, that's easy. Either install http://www.phpmyadmin.net/home_page/index.php on the server, the best tool to manage a mysql server. Or use XAMPP, a complete package from http://www.apachefriends.org/en/index.html Guenther Dave Stevens 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. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org