[cobalt-users] Re: MySql

["Craig Napier" <craignapier@xxxxxxxxxxx>]

> Can anyone assist? Is this the correct way to allow my clients to create 
> and admin their own database? Thanks you for your help in advance.
|>> log into telanet run mysql -u root -p
|>>
|>> the run
|>> GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,REFERENCES,DROP,INDEX,ALTER
|>>
|>> ON userdatabase.* TO 'username'@'domain.com' IDENTIFIED BY 'password

I'm trying to setup mySQL with phpMyAdmin as well <first db>.. When you 
create the database with the above statement, do you include the single 
quotes around the 'username'@'domain.com' and 'password', or do you drop 
them?

Also, what's the difference between using the actual domain name vs. using 
"localhost" if the domain is on the same machine?

Thanks!
Craig Napier

_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com