Error creating the database

[countmeon]

user directadmin creat database

Error creating the database
 
Unable to add user giantxu_111. Access denied for user 'da_admin'@'localhost' to database 'giantxu\_111'

try phpmyadmin creating :

#1044 - Access denied for user 'da_admin'@'localhost' to database 'merryz_tuan'
CREATE USER 'merryz_tuan'@'localhost' IDENTIFIED BY '***';

GRANT USAGE ON * . * TO 'merryz_tuan'@'localhost' IDENTIFIED BY '***' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;

CREATE DATABASE IF NOT EXISTS `merryz_tuan` ;

GRANT ALL PRIVILEGES ON `merryz_tuan` . * TO 'merryz_tuan'@'localhost';

Appear the cause of the problem is updated directadmin and PHP I can with APACHE MYSQL

And mysql 5.0 updated to 5.1 by

Give me your hand, please!

 

[countmeon]

shell create database OK

i create database is ok


mysql -u da_admin -p

passwrod:

mysql show databases;

OK

create database testtest;

OK

 

[zEitEr]

Make sure, that in /usr/local/directadmin/conf/mysql.conf correct password is set.

 

[countmeon]

Make sure, that in /usr/local/directadmin/conf/mysql.conf correct password is set.

mysql.conf set is correct!


Using mysql. Conf inside the password

Can login phpmyadmin and can shells command login mysql

Other trying to create user phpmyadmin with database hint mistakes but have already established data and user can use to create user log in, but did not create the once-hot data name

 

[zEitEr]

OK, if in /usr/local/directadmin/conf/mysql.conf there is a correct and valid password, and you still can not create databases, check mysql and directadmin logs.

If nothing important is there, check with debug mode.

 

[countmeon]

OK, if in /usr/local/directadmin/conf/mysql.conf there is a correct and valid password, and you still can not create databases, check mysql and directadmin logs.

If nothing important is there, check with debug mode.

Thanks for your help


I found the problem, is the da_admin global permission is changed, I use root into resetting the da_admin permissions