[Techtalk] Difficulties creating a MySQL database

[Sheila Fenelon]

Brianna Laugher wrote:
> Thanks for your help, Sheila.
> 
> I complained again to my webhost and I don't know what they did, but
> now phpMyAdmin will accept 'create view' statements.
> 

That's nice, a host that listens.

> Anyway. charging on to the next problem. :)
> 
> The last statement on the install notes was to do this:
> 
> mysql> GRANT ALL ON memberdb.* TO 'memberdb'@'localhost' IDENTIFIED BY 'pants';
> 

In this example, "pants" is the password for user "memberdb", And yes
you've already done this step via phpMyAdmin or cpanel.

> In the config file there is also this line:
> $config['db'] = "mysql://memberdb:pants@unix()/memberdb";
> 

This is the DSN string. Have a look at
http://pear.php.net/package/DB/docs/1.7.14RC1/DB/DB.html#methodconnect

The first "memberdb" is the username and the second one is the database.
I've never seen unix() used like this. Normally it's "localhost", and
some other identifier for a remote MySQL server.

HTH,
Sheila
--
http://www.shefen.com/