| View previous topic :: View next topic |
| Author |
Message |
justincataldo
Guru
Joined: 15 Jun 2005
Posts: 376
Location: Australia
|
 Posted: Thu Feb 02, 2006 2:59 am Post subject: MySQL permissions deleted... [SOLVED] |
 |
|
I had just got mysql installed and it was running. Using webmin I deleted the mysql table which contains the user permissions and passwords. Since then I can't do anything!
I've tried unmerging and remerging mysql, and I've tried running commands such as mysqladmin flush-privileges, mysqladmin flush-logs, and even /usr/bin/mysqladmin -u root -h localhost password 'new-password'; but it won't let me change anything because I don't have permission to connect to the database.
I keep getting the following error:
| Code: | mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'
|
How can I restore the privileges or delete everything and start again?
_________________
Core i7 2.67GHz with 12GB DDR3 RAM.
Last edited by justincataldo on Sun Mar 05, 2006 4:15 am; edited 1 time in total |
|
| Back to top |
|
 |
JeliJami
Veteran
Joined: 17 Jan 2006
Posts: 1086
Location: Belgium
|
| Posted: Thu Feb 02, 2006 7:16 am Post subject: Re: MySQL permissions deleted... |
|
|
| justincataldo wrote: | | How can I restore the privileges or delete everything and start again? |
to delete everything: unmerge mysql and remove /var/lib/mysql
_________________
Unanswered Post Initiative | Search | FAQ
Former username: davjel |
|
| Back to top |
|
|
justincataldo
Guru
Joined: 15 Jun 2005
Posts: 376
Location: Australia
|
| Posted: Fri Feb 03, 2006 12:57 am Post subject: |
|
|
That's it! Thanks! 
_________________
Core i7 2.67GHz with 12GB DDR3 RAM. |
|
| Back to top |
|
|
|
Unsupported Software
