Created new database but manged to lose original master admin id root.
Using phpMyAdmin cannot see databases. The directories holding the data still exist in /var/lib/mysql/datbase names.
How can I re attach these data files so the datbases can be managed?
The part of script that I think caused the problem is:
REPLACE INTO user (host, user, password)
-- IMPORTANT: Change this password.
REPLACE INTO db (host, db, user, select_priv, insert_priv, update_priv,
delete_priv, create_priv, drop_priv, index_priv)
'Y', 'Y', 'Y', 'Y',
'Y', 'Y', 'Y'