Tasos Posted September 8, 2013 Share Posted September 8, 2013 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 Link to comment https://forums.phpfreaks.com/topic/281970-create-database-failed/ Share on other sites More sharing options...
Barand Posted September 8, 2013 Share Posted September 8, 2013 It could be that the user does not have the privileges to create database Try connecting as that user and SHOW GRANTS 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 . 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! Link to comment https://forums.phpfreaks.com/topic/281970-create-database-failed/#findComment-1448937 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.