Reputation: 81
I am facing this error every time I create a database in CLI interface of mysql:
I am using Xampp
Upvotes: 0
Views: 2527
Reputation: 1117
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.
Upvotes: 1
Reputation: 151
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
Upvotes: 1