MySQL problem with create database

Y

yavorr

New member
Joined
Feb 20, 2008
Messages
3
Hello

when i create the database on panel DA i have :

"
Error creating the database

Details:

Unable to read : Filename is null


An error occurred querying the users table SELECT command denied to user ''@'localhost' for table 'user'
That user already Exists
"

I don't know whats goin' on, someone can help me?
I try reinstall MySQL, and it still doesn't work

When I add new user on DA, I still can't create new database MySQL. I try create different accound on PhpMyAdmin (the same name and password like logon into DA, and other password and login etc) Nothing doesn't work! I don't know what i've done with it. A Guy, who install DA on my server .. hmm he's doin' something wrong or incorrect install MySQL, I guess..
Ok.. someone help me with this? I really need t creating user and databases on DA, not PhpMyAdmin...cause DA sets right rights to the database and blabla... (:

Please help :)
[email protected]


ps. sorry, i don't speak english very well..:)

Thanks Guys!!

yavorr
 
Hello,

I went over the code, and the only place that could happen is in the reading of the /usr/local/directadmin/conf/mysql.conf file.

Check to see if it exists.
It should also be set to diradmin:diradmin, eg:
Code: 
chown -R diradmin:diradmin /usr/local/directadmin/conf
Also check your /usr/local/directadmin/conf/directadmin.conf. Make sure you have:
Code: 
mysqlconf=/usr/local/directadmin/conf/mysql.conf
then restart DA.
John
 
It doesn't work :(

it's should be the same ? :
"
chown -R diradmin:diradmin /usr/local/directadmin/conf
"

or for other user? example :
chown -R root:password /usr/local/directadmin/conf
?

Thank's for help :)

btw.
maybe you can logon into my server and look for this stuff? ofcourse if is not problem :)


Greetings
Andrew
 
the conf directory should be diradmin:diradmin and not root.... especially not set to group as a root password... which wouldn't work anyway.

Does the mysql.conf exist?

Did you check the directadmin.conf?

Type:
Code: 
/usr/local/directadmin/directadmin c | grep mysqlconf
John
 
yes, i have this file :

user=da_admin
passwd=xxx

and the directadmin.conf has line : mysqlconf=/usr/local/directadmin/conf/mysql.conf

...
but... i try to reinstall MySQL , also I remove all files of MySQL and try run script mysql.sh, but show me this :

host:/usr/local/directadmin/scripts# ./mysql.sh
Usage: ./mysql.sh mysqlrootpass da_dbuser da_pass
*** do not use spaces in your passwords ***


And now, i don't know what i've done :(

I have no idea for how it's work ;/
i'm desperate! i google over 24h and still nothing, nobody fix this problem, or nobody have this problem. Any manual on this topic doesn't work, or doesn't exist.

Pleeeeaaseeeeee heeeeelpp, I try new install of MySQL server, but it seems it doesnt installed. I Have Debian 4.0.

Maybe exist some scripts to install this automaticaly ? I buy DA on some firm, but they say me : kiss my black ass, support doesn't exist.... wrrrr


Best Wishes
Tired... Andrew
 
You must log in or register to reply here.
Back
Top