canot create mysql DBs

blueice

Verified User
Joined
Jan 18, 2004
Messages
191
Hi,
i have a freebsd 4.9 box.
If a user try to create database receive this error:
Unable to add user dworld_asas. Table 'user' is read only

I think it is permision problem (maybe need chown) but what files needed to check?
Thanks
Christos
 

DirectAdmin Support

Administrator
Staff member
Joined
Feb 27, 2003
Messages
9,005
Hello,

It's possible that the da_admin user doesn't have the required privileges to write to the mysql.user table. Check /home/mysql/* and make sure it's all owned by mysql:mysql, but the issue might be a permission issue inside the database table itself.

If you don't have anything in the database yet, I would recommend you just reinstall mysql using our script:

cd /usr/local/directadmin/scripts
./mysql.sh rootpass da_admin adminpass

and chose "yes" ('y') when it asks to delete the directory.

John
 
Top