MySQL Help
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Dev Shed ForumsDatabasesMySQL Help

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
  #1  
Old September 27th, 2000, 10:18 PM
gungi gungi is offline
Junior Member
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Sep 2000
Posts: 2 gungi User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Send a message via ICQ to gungi
I'm still fresh with Mysql, pls advise me.
Suppose I have 2 domins in my host such www.aa.com and www.bb.com . And now I've connected them with the same user and password (Admin Password).
But I would like to use the individual password and username for each domain, Because I've afraid of the big mistake. If there is someone know the admin's password, may he will destroy all databases that I have.
Could you let me know how I can create individual username and password for each domain ?

I've tried to find the information in this case but I still failed. Could you explain and give me a bit example?
Thank you very much.

Reply With Quote
  #2  
Old September 28th, 2000, 05:32 AM
Carpe Diem
Guest
Dev Shed Newbie (0 - 499 posts)
 
Posts: n/a  
Time spent in forums:
Reputation Power:
grant all on database.* to user@localhost identified by 'password';

so it would be something like

grant all on aadb.* to aauser@localhost identified by 'aapass';

grant all on bbdb.* to bbuser@localhost identified by 'bbpass';

That should do it

Regards
Darren
http://www.php4hosting.com/ $ http://www.php4hosting.co.uk/ £

Reply With Quote
  #3  
Old September 28th, 2000, 08:12 PM
gungi gungi is offline
Junior Member
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Sep 2000
Posts: 2 gungi User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Send a message via ICQ to gungi
Yeh!! successfully...
Thank you very much for your knidness.

Reply With Quote
Reply

Viewing: Dev Shed ForumsDatabasesMySQL Help > How can I set the individual username, password for each site ?


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 2 hosted by Hostway
Stay green...Green IT