0

I've done something stupid, and now I have no access to mysql schema, which couses problem with creating other schemas. I'm getting error 1044. I'm using Ubuntu and MySQL 5.7. I've tried to reinstall it - didn't work. Can anyone help?

egzaell
  • 195
  • 3
  • 16
  • Check your MySQL accounts first, then tell us something more. For example which accounts are enabled to access your database. – DamiToma Apr 29 '17 at 11:21
  • none - that's the problem – egzaell Apr 29 '17 at 11:23
  • Well I really suggest you to reinstall all the components you're using, from your Server to MySQL. Otherwise, if you can access the database through phpMyAdmin, create a new account. – DamiToma Apr 29 '17 at 11:27
  • i've used `sudo apt-get remove --purge mysql*` and then i've reinstalled mysql server, but it didn't work – egzaell Apr 29 '17 at 11:43
  • http://stackoverflow.com/questions/1709078/how-can-i-restore-the-mysql-root-user-s-full-privileges – jophab Apr 29 '17 at 13:11

1 Answers1

0

dumb your database with 

mysqldump --routines databasename > outfile.sql

The MySQL database can be recreated with the command

mysqld --initialize
jophab
  • 5,356
  • 14
  • 41
  • 60
Vikram Saini
  • 2,713
  • 1
  • 16
  • 33