Problems with the Windows version of XAMPP, questions, comments, and anything related.
by JanneMasa » 06. February 2007 20:44
Hi i'd like to ask how i can make new user on mysql and give it to all privileges to specific database. Because if i write
mysql -> CREATE DATABASE test;
mysql -> GRANT ALL PRIVILEGES test.* TO 'test'@'localhost' IDENTIFIED BY 'passwordgoeshere' WITH GRANT OPTION; FLUSH PRIVILEGES
i just get ERROR 1044 <42000>: Access denied for user 'root'@'localhost' to database 'test'
so how i can get all acces to root user or how i can just make new users and give them all privileges.
-
JanneMasa
-
- Posts: 2
- Joined: 06. February 2007 20:34
by cvdbAdmin » 06. February 2007 21:24
You might try doing these things in phpMyAdmin. Sometimes doing it there works better then using the command line. To get there, open a browser and go to
http://localhost/phpmyadmin.
-
cvdbAdmin
-
- Posts: 17
- Joined: 19. January 2007 22:19
by JanneMasa » 06. February 2007 21:37
Problem solved, i downloaded HeidiSQL software and modified root access.
-
JanneMasa
-
- Posts: 2
- Joined: 06. February 2007 20:34
Return to XAMPP for Windows
Who is online
Users browsing this forum: No registered users and 198 guests