::DENIED!

Problems with the Windows version of XAMPP, questions, comments, and anything related.

::DENIED!

Postby galloway » 15. January 2017 22:42

installed Xampp, run MySQL and nothing else, using the Shell(terminal)... my CMD prompt entry:

MariaDB [(none)] CREATE DATABASE bookoo;
ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'bookoo'
MariaDB [(none)]>

Why?

I added a db before with GRANT ALL ON(to myself) and now instead of being able to SHOW or DESCRIBE I am getting the above error codes...Even when I try:
c:\xampp\mysql\bin\mysql -u -p
Enter password: *********
ERROR 1045 (28000): Access denied for user @'localhost' (using password: YES)

Why? Would be because of how I created my user and localhost wrong? Used 'joe'@'HELLO' ... without the 'localhost'. Did this mess up access to the software? Your help would me much appreciated.
galloway
 
Posts: 1
Joined: 15. January 2017 22:12
XAMPP version: 3.2.2
Operating System: windows 10

Re: ::DENIED!

Postby Altrea » 16. January 2017 02:04

Use a valid username in your mysql login command. In your case you are logged in as anonymous user.
The user needs to have CREATE permissions for this database.
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11926
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64


Return to XAMPP for Windows

Who is online

Users browsing this forum: Nobbie and 135 guests