Access A Database From Different Websites
Is it possible to access a MySQL database from a domain other than the domain that the database is phtsically on, and if so, how?
For example, if my database is located on www.site1.com, and I want to access it from a script on www.site2.com, how do I do it? For arguments sake, assume both websites are physically located on the same server, and they share an IP address of 123.123.123.001.
View Complete Forum Thread with Replies
Related Forum Messages:
Using One Database By Two Websites
I am with 1and1 and am trying to put together three small websites. Obe for my local church, mine, and a friends. At present I have access to two databases but I would like to share one as the cost is prohibitive to add another database. Is there a way in [for example] .htaccess or by putting in a "directory" that could sort this out.
View Replies !
2 Websites Using 1 Database
i have two logins systems(for 2 websites) and i use the same mysql database. still now when the users login at the first site and link to the other,they have to login again to access it.how can i manage this so when someone login at the 1/2 sites,they apear online at the other without needing to login again? note that: *i use the same database for these two sites *i use one url and users switch between these two sites using internal button link. *both sites r in the same server.
View Replies !
1 Database For 2 Websites?
While I have been doing simple HTML and CSS websites for some time I just recently started out with PHP and MySQL. The question I have is I have an existing website which runs off a MySQL database and am in the process of creating a second site which is the EXACT same type of website (myspace resouce) and will be using the exact same scripts on both sites so rather than having to create a second database and updating two seperates sites all the time if I can run them both off the same database so that by updating one database both sites will update with the new content. Also the only things that are run off of the database is non search engine friendly content such as myspace layouts, graphics, and other types of images but the pages text content for each site is unique.
View Replies !
Two Different Websites Connected To One Database But Only One Works...
I have been recently having problems transferring my website from one domain name to another. The first domain name was used whilst at uni, but the second is my own perosnal website. One the original website, the MySQL database allows the user to login and register new users without any problems. However, the second website does not allow me to do this. I would consider myself a newbie when its comes to MySQL so I was wondering if the community could help me out on this one. Both websites are hosted by the same company, and both websites use the same database but my limited knowledge cannot solve this problem. Are there certain permissions I need to set or something? Can anyone help me out on this one?
View Replies !
Some Advice For A Newbie On Big Scale Websites Like Ebay, Facebook, Youtube
I am literally newbie in database design. Just finished kevin yank's build your own database driven website using php and mysql. The book helped me to understand the imporatance of deisgn in a database driven site but I still finding it difficult to figure out the large scale websites like ebay, facebook or youtube. Does anyone know how the database might be designed for these sites. Facebook and youtube are tagbased sites where everything is connected by tags. but how are these tags organized in tables?
View Replies !
Converting Ms Access Database To Mysql 5 Database
I've imported a ms access database into a table in a mysql database. The access database contains a field that holds date/time values in 'general date' format. These all show up at 01/01/1970 in the mysql database. I believe the field in mysql is wanting UTC and shows numbers when looked at from the sql command line (i.e. March 13, 2006, 5:31 pm is shown as 1142289086). How do I get the access data into that format so it will import properly?
View Replies !
Access Database On Web
I have a database on a webserver and now would like to write a small windows application to access this database, read and write to it. As I understand it correctly, I have to code in the username and password of the database. So, the question is, if I deploy this little application to other users, can they not get hold of my username/password by just decompiling the application? Is this not a big security risk? Or are there other ways to read and write to the database without me coding in my password?
View Replies !
Access Database
I am having trouble getting started. I have an Access database with multiple tables in it, and I want to post it on a website so that people can search it and edit it. I dont konw really where to begin. I have a domain with MySQL capabilities, but I really dont know what to do next. I would really love some hand holding, and it wouldnt take that much time to teach me how to do it. IM me at RND328 if you are willing or just respond to this post.
View Replies !
Cannot Access Database
I have set up a database ('war_graves_uk') under a user name, and have set up the password etc. Going into the "privileges" tab I have set things so that I am told that I have been granted all privileges to access the above database. And yet, although in my PHP file I can connect to MySQL I cannot access the required database.
View Replies !
Can't Access Database
I have just installed MySQL version 5.0.18 on a VMWare session running Suse 10. I was able to start the server, create a database, and create a user with permissions to said database. I am able to connect to the database and run queries on it remotely from the host OS (keeping in mind that the database is on a virtual machine, so this is technically remote access). However, if I run the admin.php file for PHPNuke or the vb_test.php file from vBulletin, I'm unable to access the database. Do these forums not support the newer versions of MySQL?
View Replies !
How To Allow Access Just To One Database?
I have several database setups on my hosting account using Cpanel. I want to allow an individual access to just one of these databases using phpmyadmin. However whenever I try to go to the direct link to the open database in phpmyadmin it asks me for a username and password and just won't accept the dbusername and dbpassword. It wants the hosting package uname and password! Thus when you log in like that you can access all the databases under phpmyadmin. Am i missing something really simple here?
View Replies !
Link Access Database
I am trying to link my Access Database to MySQL online. Everytime I use a converter I ge the error "Unknown MySQL Server Host" - I am pretty sure that I am typing in the wrong Host name. But I have no idea what the host name is suppose to be.
View Replies !
Microsoft Access Database
i need some advice as I'm sure there will be a way to do this i just don't know it. I have an access database that i use, however i need to share this with my work college who is in another location. So i was wondering if there is some way i can make all the data online so it runs from something like an MySql database and we just use the software to execute it all.
View Replies !
Can We Prioritize Database Access?
Can we prioritize access to the MySQL database for adding records over query requests? i.e. I have two queries ( insert and select). Can I prioritize "INSERT" query over "SELECT" query? Is there any such mechanism in MySQL?
View Replies !
Restrict Database Access
I have a complete application developed using MySQL as the data server and Microsoft Visual Fox as the GUI. My users all have privileges dependent upon their job functions BUT I can not find a way that I can stop other applications from accessing and changing the data as long as they do so with a valid userid and password. The reason this is a BIG problem is many of the 'rules' governing table updates are part of the application and NOT part of the database. I can not use the IP validation as it is quite possible the unwanted access and changes could come from the same IP that a valid change would come from. This seems like it should be so easy to solve but I have spent many hours in the documentation with no results.
View Replies !
Database Access From Different Locations
My database is housed in a directory say "CHAMPION".Now, i copied this directory contents to a different location say "FORMULA1". The formula1 directory does'nt have the database. Is it possible to display the contents of this database from the formula1 directory???? (All the directories are in the server). Or in other words, please clarify the following if I does'nt make any sense above. In my server, there are 3 directories: "CHAMPION", "FORMULA1", "DRIVERS". The above 3 directories are for three different webpages.I want to share one database to all these three.Where should i place my database???Right now, my database is placed in the "CHAMPION" directory and the champions webpage is working fine.I want "FORMULA1" and "DRIVERS" webpages also to access the same database.
View Replies !
Using MS Access To Get Data In / Out Of A MySQL Database
I have no experience using MS Access to interface with MySQL. I have a tiny MySQL database that might need to have Access connect with it over the internet and grab data/update etc. Is this practical and what does it take to do it? My project is not time sensitive but I'd like to see what methods I can use to do remote queries with my database running on a *nix/Linux server.
View Replies !
How To Make Database Access Fast
In my linux server (LOCAL), *accessing data through the PHP scripts from MySQL (3.23.41)tables, it is taking more time. * Earlier it was very fast. * Now a days some reports it is taking more than five minuits. Earlier it use to come with in a minuit. *What may the problem and what I have to do spead up the process.
View Replies !
Phpmyadmin :: Import Access Database
i have a access database that wich i want to convert to mysql. first, using Access i export it to .txt after that i try to import it using phpmyadmin and it keeps saying "file could not be read" i did the same with an excel file converting it first to CSV (comma separeted value) and then when importing it to phpmyadmin i get the same error.
View Replies !
Doctors To Access/manipulate A Database
in something like a page to access/manipulate the content of the database? user friendly wherby users is not required to know sql statement to insert in data? like we wouldn't expect a doctor to know the sql statement to input data inside the database.
View Replies !
Deny Root Access To Database
I am building a application that I am trying to keep control over a database so users can not see the information stored in it. My desktop application creates a database, user and sets the permissions correct but the root still has access to the database. Can you block root from having access to just a certain database? For 99.9% of the users that will use the application, I can have the application change the root password as this will be the only thing mysql will be used for. For that .1% of the user base, they will want to use a existing mysql database where I will not be able to change the username. Any ideas on how to do this?
View Replies !
Connecting To Database :: Access Denied
I just downloaded mysql 4.1. When I open my sql from programs it asks for password (root pass) and then I created new database(abc) and created table(bcd). Now I am trying to connect to database and select from the table, I keep getting. "Access denied for user ''@'localhost' (using password: NO) ".After I installed mysql, I logged in using root, and password I created new user called "test" and granted permission on abc. Thats the user I am using to connect to"abc".
View Replies !
Converting Access Database To Mysql
Have for some years developed applications in Microsoft Access. One of my clients now require the database to be usable nationwide. Cannot use replication as data changes must be immediately accessible to all users. I gather, to use Access on the net is either difficult or expensive (using Terminal Server, which is I understand one way of doing it, requires the purchase of multiple user licences and also needs a professional engineer to set it up, etc). Have no experience of mySQL. How difficult is it to create/convert the sort of forms one uses in Access to mySQL? Can one convert the data tables easily to mySQL? How about queries, reports, etc?
View Replies !
Database Access Race Condition
I am working on a website with two applications on the server - both accessing the MySql database. PHP applications are reading and writing to the database and a Java servlet (running under Tomcat) is also accessing the database. Currently the software in both applications is under development so there is very little in the way of actual database accesses, however, someone has suggested that we will have problems in the operational system because both Java and PHP applications will be attempting to access the same database.
View Replies !
Access Link To Mysql Database
I have set up two links in access to two different mysql databases. One allows me to add records and make changes. The other says that I cannot update the file and won't let me make changes of any kind. I have no idea what is different, or what I did different in setting these links up. Anyone know how I can make the database editable?
View Replies !
Access Mysql Database From Php Codes
I am using Apache2, Php 4.4.2, and mysql server 4.1 and have configured httpd.conf for apache and php.ini file for php. Now I am writing a small program to access my database on mysql server as follow: <?php $connection = mysql_connect ('localhost' , 'root' , 'aungmyinchin') or die (mysql_error()); echo "$connection"; mysql_select_db("dms",$connection); $query="SELECT * FROM FEATURE"; $result = mysql_query($query,$connection); echo $result; ?> But when I ran on browser (through an html link), I have the following error message as: Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in C:Program FilesApache GroupApache2htdocsSku-Feature.php on line 3 Client does not support authentication protocol requested by server; consider upgrading MySQL client.
View Replies !
Client To Access An SQL Database By Visual C++
I have several problems. I am trying to communicate with a sql database(local) by Visual C++ 6.0 (MFC based aplication). Well i think i am able now to connect to the local sql-server, but i cannot send commands to the sql-server, as create table... or things like that. I searched the Internet but only found source code for C. Well, but i need some for C++ .
View Replies !
Another Program To Access MySQL Database
I have a list of 8 rows by 11 columns that I exported from Excel into MySQL to populate my Database and that all made it through. I am now trying to create a label with a label making program that will connect to a database. I have installed the ODBC 3.51 driver and tested the link and it finds the file. When I try to open the database file from the label making program it says "Error Reading Record Fields", I click on details and it says "ODBC driver does not support dynasets." I have no idea what a dynaset is or why it is an error??? Is there a way around this? I can save the excel file as a DBaseIII .dbf file and it works but I wanted to be able to use a database for better tracking of information.
View Replies !
Error 1044 Access Denied To Database
I am currently working through a book on Dreamweaver and using PHP. I am having a little trouble with setting up the database though. I have php 4.2.3 and MySQL 4.0.20a. I am running locally with Apache 1.3.27 on Windows XP Pro. I seem to have finally got MySQL running after a lot of difficulty. In the book it says to type source C:mysql ewland_tours.sql at the mysql> prompt, to generate the newland_tours database in my copy of MySQL. When I do this however it gives me an error message saying: Error 1044 Access denied for user: '@localhost' to database 'newland_tours' and numerous other ones saying: Error 1046 No Database Selected If you can help me I'd be very grateful. I think that something must be wrong or amiss with the settings or the paths to the files in my.ini file? Or perhaps it is just a bug with php or MySql?
View Replies !
Access Denied For User ''@'localhost' To Database
Yesterday I got a new server with MySQL 5.0.22. Today I spent 10 hours trying to set up a database using webmin. Actually, it's not a problem to create a database, but the problem is that I can not connect. I tried different settings, no luck: Access denied for user ''@'localhost' to database 'mydatabase' I can connect from command line: [root@server8]# mysql -u myusername -p Enter password: *** Welcome to the MySQL monitor. Commands end with ; or g. ....... As you see I can connect. My settings from webmin: Code:
View Replies !
PhpMyAdmin Unable To Access New Database After Creation
I am a bit confused about something in phpMyAdmin. By default, there are two databases: test & mysql. I am able to access these via a php script w/o any problems. However, when I create a new database I am unable to connect to it and more disturbing is the fact that the newly created dB does not appear in the drop-down menu (LH side) along with the two default databases. I know the new db exists because if I try to create a new db with the same name, it says it already exists. Any idea what is going on here?
View Replies !
Access Denied Error :: Create A New Database
I am trying to create a new database. At the moment I am using the database test. When I installed mysql I did enter a user name and password. This is the error message that i get: mysql> create database rbs; ERROR 1044: Access denied for user: '@127.0.0.1' to database 'rbs' I am able to connect to the database without using a username and password. So something with my access must be wrong. But i dont know what it is...
View Replies !
Access Denied For Root - New Database Setup
I have started the 'Build Your Own Database Driven Website Using PHP and MySql I have installed PHP and MySql' book, and i have a problem: I have put in the comand prompt mysql -u root mysql This gives me an error 1045 access denied for user root @ localhost ....
View Replies !
How To Backup Database Data Without Direct Server Access
I need to backup a MySQL database (MySQL 4.0). But it is on a shared-hosting web server and so I don't have direct server access. I also have no phpMyAdmin installed. How can I backup the database? I think it is possible with PHP (version 5.0.2 is installed on the web server) to create a file with SQL commands which restore the data, but what is the easiest way to do it?
View Replies !
|
TRACKER
