Tasos Posted September 8, 2013 Share Posted September 8, 2013 (edited) 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 Quote Link to comment https://forums.phpfreaks.com/topic/281970-create-database-failed/ Share on other sites More sharing options...
Solution Barand Posted September 8, 2013 Solution Share Posted September 8, 2013 (edited) 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 Quote Link to comment https://forums.phpfreaks.com/topic/281970-create-database-failed/#findComment-1448667 Share on other sites More sharing options...
Tasos Posted September 10, 2013 Author Share Posted September 10, 2013 Thanks for the reply i solve the problem, the problem is when login with admin ! so i use now root . Quote Link to comment https://forums.phpfreaks.com/topic/281970-create-database-failed/#findComment-1448926 Share on other sites More sharing options...
vinny42 Posted September 10, 2013 Share Posted September 10, 2013 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! Quote Link to comment https://forums.phpfreaks.com/topic/281970-create-database-failed/#findComment-1448937 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.