| View previous topic :: View next topic |
| Author |
Message |
Raghu
Joined: 12 Mar 2009
Posts: 29
|
 Posted: Fri Feb 12, 2010 5:51 am Post subject: How to connect remote database from localhost |
 |
|
Hello All
Iam new for rails, i have configure rails application in localhost, i want to use server database in my local application for this how can i connect remote database from my local rails application.
Please help me any one
thanks in advance
Raghu |
|
| Back to top |
|
 |
sharma I
Joined: 13 Jun 2008
Posts: 130
|
| Posted: Fri Feb 12, 2010 6:26 am Post subject: |
|
|
Hai
Raghu
You have to connect remote database by giving some privileges to your IP(system IP address),
By using following command at your server mysql prompt you can easily connect the your server database (remote database)
GRANT ALL PRIVILEGES ON databasename.* TO
user@localhost(your IP) IDENTIFIED BY "password"
EX:- GRANT ALL PRIVILEGES ON mydatabase.* TO user at(@)192.1.2.2(your IP) IDENTIFIED BY "your system password"
thanks |
|
| Back to top |
|
|
|
