Hello, First sorry for my bad english 
I just install directadmin with custombuild 1.1 default options (OS: freeBSD 7.2-32bit)
Install Successful, When I login to directadmin and Create new Database.
"Your database has been setup." But when I install wordpress I get this error.
Can’t select database
We were able to connect to the database server (which means your username and password is okay) but not able to select the test3_w3 database.
* Are you sure it exists?
* Does the user test3_w3 have permission to use the test3_w3 database?
* On some systems the name of your database is prefixed with your username, so it would be like username_test3_w3. Could that be the problem?
--------------------------------------
# ps ax | grep mysql
46006 p0 I 0:00.03 /bin/sh /usr/local/mysql/bin/mysqld_safe --user=mysql --datadir=/usr/local/mysql/data --pid-file
46052 p0 S 0:01.46 /usr/local/mysql-5.0.89-freebsd7.2-i386/bin/mysqld --basedir=/usr/local/mysql-5.0.89-freebsd7.2-
53433 p0 D+ 0:00.00 grep mysql
# /usr/local/etc/rc.d/mysqld status
mysqld (pid 46052 ) is running...
Still error when I reinstall mysql
# cd /usr/local/directadmin/custombuild
./build mysql d
# /usr/local/mysql/data/server.hostname.com.err
100121 14:34:27 [Warning] Aborted connection 811 to db: 'unconnected' user: 'username' host: 'localhost' (init_connect command failed)
100121 14:34:27 [Warning] Unknown character set: 'urf8'
I know the cause of my problem, misspelling in my.cnf "urf8" change to "utf8"
I just install directadmin with custombuild 1.1 default options (OS: freeBSD 7.2-32bit)
Install Successful, When I login to directadmin and Create new Database.
"Your database has been setup." But when I install wordpress I get this error.
Can’t select database
We were able to connect to the database server (which means your username and password is okay) but not able to select the test3_w3 database.
* Are you sure it exists?
* Does the user test3_w3 have permission to use the test3_w3 database?
* On some systems the name of your database is prefixed with your username, so it would be like username_test3_w3. Could that be the problem?
--------------------------------------
# ps ax | grep mysql
46006 p0 I 0:00.03 /bin/sh /usr/local/mysql/bin/mysqld_safe --user=mysql --datadir=/usr/local/mysql/data --pid-file
46052 p0 S 0:01.46 /usr/local/mysql-5.0.89-freebsd7.2-i386/bin/mysqld --basedir=/usr/local/mysql-5.0.89-freebsd7.2-
53433 p0 D+ 0:00.00 grep mysql
# /usr/local/etc/rc.d/mysqld status
mysqld (pid 46052 ) is running...
Still error when I reinstall mysql
# cd /usr/local/directadmin/custombuild
./build mysql d
# /usr/local/mysql/data/server.hostname.com.err
100121 14:34:27 [Warning] Aborted connection 811 to db: 'unconnected' user: 'username' host: 'localhost' (init_connect command failed)
100121 14:34:27 [Warning] Unknown character set: 'urf8'
I know the cause of my problem, misspelling in my.cnf "urf8" change to "utf8"
Last edited: