Creating new mysql db

software development

#1

Is there a delay in creating a new hostname/db? I’ve created a couple databases (and associated hostnames), along with a user for each one, and I cannot access the database either via control panel (I get page not found) or via shell access:

(shell error)
[slash]$ mysql -h life -u anderg -p life
Enter password:
ERROR 2005: Unknown MySQL Server Host ‘life’ (2)

(from Web panel)
MySQL Hostname life.gabeanderson.com

Thanks,
Gabe


#2

gabeanderson.com isn’t in the machine’s search path, so you need to use:
-h life.gabeanderson.com
That said, there is a delay in setting this up, and doesn’t look like our primary nameserver knows about that hostname yet.

jazz% dig @ns.newdream.net life.gabeanderson.com

; <<>> DiG 9.3.0s20020703 <<>> @ns.newdream.net life.gabeanderson.com
;; global options: printcmd
;; Got answer:
;; ->>HEADER<<- opcode: QUERY, status: NXDOMAIN, id: 54412
;; flags: qr aa rd ra; QUERY: 1, ANSWER: 0, AUTHORITY: 1, ADDITIONAL: 0

;; QUESTION SECTION:
;life.gabeanderson.com. IN A

;; AUTHORITY SECTION:
gabeanderson.com. 300 IN SOA ns.newdream.net. hostmaster.dreamhost.com. 2002072900 10800 1800 1814400 300

;; Query time: 337 msec
;; SERVER: 66.33.206.6#53(ns.newdream.net)
;; WHEN: Thu Aug 1 14:29:36 2002
;; MSG SIZE rcvd: 111