pseudorandom
New member
- Joined
- May 13, 2008
- Messages
- 1
Hello,
I recently had DA support perform an installation for us on our brand new FreeBSD server but have been encountering some problems. After DA reported that the installation had been completed we went through our reseller interface, created a new account and proceeded to instantiate a new database. We received a DA generated error saying:
Error creating the database
Details
Unable to create database <my user>_test. Can't create database '<my user>_test' (errno: 2)
From the shell, I checked if mysql was running which it was (judging the mysqld process). I then retrieved the root password and attempted to login as root/admin of the mysql instance. See my shell log below:
server2# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 18833 to server version: 5.0.22
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> create database dummydata;
ERROR 1006 (HY000): Can't create database 'dummydata' (errno: 2)
mysql> use mysql;
ERROR 1049 (42000): Unknown database 'mysql'
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
+--------------------+
1 row in set (0.00 sec)
mysql> quit
Bye
Two things jumped out to me:
If anyone can possibly shed some light on the above problem would really appreciate it. Am eager to get my DA instance deployed but these snags are slowing things down for me in a sad way
Thanks !
I recently had DA support perform an installation for us on our brand new FreeBSD server but have been encountering some problems. After DA reported that the installation had been completed we went through our reseller interface, created a new account and proceeded to instantiate a new database. We received a DA generated error saying:
Error creating the database
Details
Unable to create database <my user>_test. Can't create database '<my user>_test' (errno: 2)
From the shell, I checked if mysql was running which it was (judging the mysqld process). I then retrieved the root password and attempted to login as root/admin of the mysql instance. See my shell log below:
server2# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 18833 to server version: 5.0.22
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> create database dummydata;
ERROR 1006 (HY000): Can't create database 'dummydata' (errno: 2)
mysql> use mysql;
ERROR 1049 (42000): Unknown database 'mysql'
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
+--------------------+
1 row in set (0.00 sec)
mysql> quit
Bye
Two things jumped out to me:
- I have no idea where the mysql table is
- I wasn't able to add a new database even from the mysql shell which I think might be connected with the fact that the web UI wasn't able to add either.
If anyone can possibly shed some light on the above problem would really appreciate it. Am eager to get my DA instance deployed but these snags are slowing things down for me in a sad way
Thanks !