Apache Friends Support Forum

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.

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.

Problem solved, i downloaded HeidiSQL software and modified root access.