mysql user problem

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

mysql user problem

Postby 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

Postby 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

Postby 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 56 guests