Create database failed

[Tasos]

Hello there !

I need some help with database i cant create a new database, i donwloaded the latest version of phpmyadmin, phpmyadmin has already:
information_schema and test in it.
I try to do this:
CREATE DATABASE IF NOT EXISTS `demo` ;
but i get an error: #1044 - Access denied for user ''@'localhost' to database 'demo'

Here below server information

erver: localhost via TCP/IP
Server type: MySQL
Server version: 5.6.12-log - MySQL Community Server (GPL)
Protocol version: 10
User: admin@localhost
Server charset: UTF-8 Unicode (utf8)
Web server
 
Apache/2.4.4 (Win64) PHP/5.4.12
Database client version: libmysql - mysqlnd 5.0.10 - 20111026 - $Id: e707c415db32080b3752b232487a435ee0372157 $
PHP extension: mysqli Documentation
phpMyAdmin
 
Version information: 4.0.4, latest stable version: 4.0.6
Documentation
Wiki
Official Homepage
Contribute
Get support
List of changes

I really dont know hot to solve the problem. Thanks in advance

Edited September 8, 2013 by Tasos

[Barand]

It could be that the user does not have the privileges to create database

 

Try connecting as that user and

SHOW GRANTS

Edited September 8, 2013 by Barand

[Tasos]

Thanks for the reply i solve the problem, the problem is when login with admin ! so i use now root .

[vinny42]

 

so i use now root .

 

You should create a new user that has the correct accessrights. Root should really only be used in an emergency when your regular account doesn't work anymore. Ofcourse, *never* make your application use the MySQL root account!