art15 Posted September 5, 2008 Share Posted September 5, 2008 Hi, If I have a website for example www.abc.com and it has its own database and tables. I have another website www.xyz.com. if I want to access the tables from abc.com on xyz.com. How do I do this? Thanks Quote Link to comment Share on other sites More sharing options...
cooldude832 Posted September 5, 2008 Share Posted September 5, 2008 database are stored on a server just like files (in fact they are files but have more to them) Depending on your hosting situation you can link to the database on any website simply by connecting to it Some hosting companies like 1&1 prohibit using MySQL DBs outside of your domains hosted on their server but if they are both in the same hosting account you can share that database probably. Quote Link to comment Share on other sites More sharing options...
roopurt18 Posted September 5, 2008 Share Posted September 5, 2008 If you can't connect directly to the database, consider setting up a web service. Quote Link to comment Share on other sites More sharing options...
Zane Posted September 5, 2008 Share Posted September 5, 2008 from abc.com you'll need to run this command on your MySQL service GRANT ALL PRIVILEGES ON *.* TO username@xyz.com IDENTIFIED BY PASSWORD("theActualPassword"); Quote Link to comment Share on other sites More sharing options...
fenway Posted September 5, 2008 Share Posted September 5, 2008 I'm not a big fan of "ALL", but it's fine for testing. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.