Hi list, First question - I have a machine that was being managed by Plesk, and an update to mod_python left Plesk in a nonrunning state (actually causes apache to segfault). So I am attempting to manually manage MySQL (the way it should be done!) - but there is apparently no root user in MySQL's tables! I assume this is a Plesk thing, but have no patience for it.
So I'm doing the tried-and-true method listed here: http://dev.mysql.com/doc/mysql/en/Resetting_permissions.html And it fails. There is no root user... So how can I get MySQL back under my control? Second question - the database is 4.0.20 (RPM provided by MySQL). When I run: mysqldump --opt -h localhost -u mylogin -p mydb > database.sql I get an export file, and when I try to execute that SQL on another 3.23.58 machine, I get SQL syntax errors. This database is not using any 4.x stuff, it is just standard MyISAM tables. Is there a trick to getting exports from a 4.x database to work on 3.23.x systems? -- Mitch -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
