Page 1 of 1

add MySQL user without a user

Posted: Mon Oct 21, 2002 10:59 pm
by wildcard
Ok, i got PHP, Apache, and MySQL to work, and I was playing with PHPMyAdmin, when i accidently deleted the only user in the MySQL database, how do i create a new user?

Posted: Tue Oct 22, 2002 1:22 am
by volka
!untested!
in your mysql-data-directory there is a subdir mysql that holds the table information
  • columns_priv
  • db
  • func
  • host
  • tables_priv
  • user
(each as .frm, .MYD and .MYI).

maybe you can find a clean installation from where you can copy these files to your system.
Should be a similar mysql version and a backup of your mysql-dir is mandatory ;)