Can't create database 'database'. (errno: 13)' SOLUTION

[zekoslav]

i tryed to search here but didnt find usefull info, so just for the record

if you get this error
Can't create database 'database'. (errno: 13)'
or #1006 - Can't create database (errno: 13)'

happens probably due to Permission denied by MySQL.

less /etc/group
and then less /etc/passwd
finf mysql user and group name, probably both are named mysql

change to mysql dir, probably var/lib/mysql and then type cd .. to go a dir under.

chown -R mysql:mysql ./mysql/

replace mysql:mysql with something different if you group and user privileges are called diferenty

also try chmod 755 on mysql dir

[zabeth]

if you get this error
Can't create database 'database'. (errno: 13)'
or #1006 - Can't create database (errno: 13)'

happens probably due to Permission denied by MySQL.

less /etc/group
and then less /etc/passwd
finf mysql user and group name, probably both are named mysql

change to mysql dir, probably var/lib/mysql and then type cd .. to go a dir under.

chown -R mysql:mysql ./mysql/

Thanks zekoslav, I had this problem and your solution worked.
A little less confusing (I think under meant above) (# is the superuser prompt):

After checking /etc/group and /etc/password as explained above,
change to the directory above the mysql dir, probably var/lib/:
# cd /var/lib

Check the owner and group with
# ls -ld mysql

# chown -R mysql:mysql mysql
-z.