Re: Security overrides in mysql.cnf
At 2:51 PM -0500 3/19/08, Brown, Charles wrote: I inherited a mysql server database. Stuff are not documented. My question is: Are there any security work-arounds in mysql. I have access to the cnf file. I need to get in and dump the database. I was told that the cnf file allows security over rides. Please help If you were told that, perhaps you could ask the person(s) who told you that what they meant and how to do it. :-) Information in other followups about --skip-grant-tables is useful, too. You can start the server that way, connect as root w/no password, issue a FLUSH PRIVILEGES statement to re-enable the grant tables (so that you can use CREATE USER, GRANT, etc.), and then set up the accounts the way you want (new root password and so forth). -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Security overrides in mysql.cnf
Hi, On 3/19/08 3:51 PM, Brown, Charles [EMAIL PROTECTED] wrote: I inherited a mysql server database. Stuff are not documented. My question is: Are there any security work-arounds in mysql. I have access to the cnf file. I need to get in and dump the database. I was told that the cnf file allows security over rides. Please help I have tried mysql -uroot. It didn't work You can start the server so that you skip loading the grant tables. That should let you get in and change the root password. Then you should have access to do what you need to. Instructions are here: http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html#resetting- permissions-unix -Dan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Security overrides in mysql.cnf
On Wed, Mar 19, 2008 at 3:51 PM, Brown, Charles [EMAIL PROTECTED] wrote: I inherited a mysql server database. Stuff are not documented. My question is: Are there any security work-arounds in mysql. I have access to the cnf file. I need to get in and dump the database. I was told that the cnf file allows security over rides. Please help I have tried mysql -uroot. It didn't work Did you use the -p flag and supply the root password? You'll need to be root to dump all of the databases. If it's on a cPanel/WHM server, you can use WHM to reset the MySQL root password if you don't know what it is. -- /Daniel P. Brown Forensic Services, Senior Unix Engineer 1+ (570-) 362-0283 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
