You want to start MySQL with the skip grant tables options, just like in the documentation. But instead of reseting the password, you want to launch the mysql client, which you should be able to do without providing a user name or password since there are no grant tables loaded. Once in mysql, switch to the mysql database and do a select on the user table to see what user name are set. There is a column called "Super_priv", any record with a Y in that column is probably a valid "root" user.
On Sep 17, 2004, at 11:07 AM, Mitch Pirtle wrote:
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]
-- Brent Baisley Systems Architect Landover Associates, Inc. Search & Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
