0

I am facing this error every time I create a database in CLI interface of mysql:

Image of error

I am using Xampp

Halvor Holsten Strand
  • 19,137
  • 16
  • 77
  • 91
MAO
  • 83
  • 9

2 Answers2

1

You may need to set up a root account for your MySQL database:

In the terminal type:

mysqladmin -u root password 'root password goes here'

And then to invoke the MySQL client:

mysql -h localhost -u root -p

more reference Reference

Community
  • 1
  • 1
Chetan Naik
  • 151
  • 13
1

A simple and 100% working solution for this problem is:
Install Xampp outside the C: Folder and it will definitely work for you, without any permission problems ever.
But remember to provide xampp-control.exe administrative privileges always to terminate any port problems.

Kartik Arora
  • 626
  • 8
  • 17