MySQL can't access root account or reset with mysqladmin
Posted
by
glumptious
on Stack Overflow
See other posts from Stack Overflow
or by glumptious
Published on 2012-11-24T22:47:57Z
Indexed on
2012/11/24
23:03 UTC
Read the original article
Hit count: 357
So if I type mysql -u root
I'm supposedly logged in, however upon trying to create or access a database I get this lovely error: ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'test1'
. I haven't the foggiest idea why after logging in as root it's trying access DB's as ''@'localhost'
and it's driving me a bit crazy right now. Possibly related, when I try to set the root password I get the error mysqladmin: Can't turn off logging; error: 'Access denied; you need (at least one of) the SUPER privilege(s) for this operation'
. I've tried removing mysql-server via running apt-get purge mysql-server
and then reinstalling with no luck. This is running Ubuntu Server 12.10 64-bit and mysql is indeed running.
--Edit--
I wonder if perhaps there is no root user. So I try to start MySQL with --skip-grant-tables
and the create the root user but then I'm given this:
ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement
. Fun fun fun fun fun.
© Stack Overflow or respective owner