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


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)]>


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.
Posts: 1
Joined: 15. January 2017 22:12
XAMPP version: 3.2.2
Operating System: windows 10


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
AF Moderator
Posts: 10265
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 88 guests