Member Avatar for Buppy

Hi,

i have a fresh MySQL install, however, i cannon log in with root. All i get ir access denied for root@localhost. However, i can login without any username and password, but it does not have any useful privilegies. How can i get the root account working?

Thanks

  • 2 Contributors
  • 1 Reply
  • 120 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by b1izzard
Member Avatar for b1izzard

>>ERROR 1044 (42000): Access denied for user ''@'localhost' to database
I had encountered similar error try

mysql> select current_user();
	+----------------+
	| current_user() |
	+----------------+
	| @localhost     |
	+----------------+
	1 row in set (0.00 sec)
  
  cmd>mysql --user=root -p
  Enter New Password: (empty)
    mysql> select current_user();
	+----------------+
	| current_user() |
	+----------------+
	| root@localhost |
	+----------------+
	1 row in set (0.00 sec)
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.