Can´t create databases trough phpMyadmin

[Mitnick]

One quick question. I can´t create databases trough phpMyadmin there i get "No Privileges". it seems that DirectAdmin is blocking users to create databases trough phpmyadmin.

However, i have an automatic script that needs to create databases and therefore i need to create an MySQL account with CREATE DATABASE,permissions.

How can i do so?

 

[smtalk]

There are no permissions for new users to create databases. In this way you should use da_admin account (very insecure solution) or create a new MySQL user. How-to: http://dev.mysql.com/doc/refman/5.0/en/adding-users.html

 

[Mitnick]

This is for a server i own, and ofcourse i have the DA admin account. With that account i can´t create new databases trough phpmyadmin.

 

[Mitnick]

I can´t seem to get this to work. I get the following error when i try to change the privileges on the user trough SSH.

First i created a user in directadmin with my admin account named "admin_admin" with a password of "password"

mysql> GRANT ALL PRIVILEGES ON *.* TO 'admin_admin'@'localhost' IDENTIFIED BY 'password' WITH GRANT OPTION;
ERROR 1045 (28000): Access denied for user 'admin'@'localhost' (using password: YES)

Can anyone help me?....

Thank you in advance.

 

[smtalk]

Firstly, you should login as da_admin

# mysql -uda_admin -p`grep "^passwd=" /usr/local/directadmin/conf/mysql.conf | cut -d= -f2`