RE: [cobalt-users] Re: MySql

[David Etheridge <DavidE@xxxxxxxxxxxx>]

For localhost to work you MUST be accessing the database from the telnet
console of your server. Adding the domain allows for remote administration
using MySQL front end tools etc.

you don't need the single quotes no.

Dave

-----Original Message-----
From: Craig Napier [mailto:craignapier@xxxxxxxxxxx]
Sent: 05 January 2001 11:34
To: cobalt-users@xxxxxxxxxxxxxxx
Subject: [cobalt-users] Re: MySql


>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

_______________________________________________
cobalt-users mailing list
cobalt-users@xxxxxxxxxxxxxxx
To Subscribe or Unsubscribe, please go to:
http://list.cobalt.com/mailman/listinfo/cobalt-users