Allowing Access Over The Internet
I am writing a java program that connects to a database. This is fine when I connect from my local machine but I can't seem to get it done when connecting over the internet.
How do I allow a user to access my database over the internet.
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
Only Allowing Root Access
I want to be able to only allow root access while I dump the databases, thus locking out all non-root users ( even remote logins) then allow all normal users back in after the dump has been done. How would I go about this.
Local Host On Windows Allowing Remote Access
We have MySQL running on a server in the US (we are in NZ) the response times to queries can vary, so i have installed MySQL on my Windows XP PC. i can transfer data across overnight using a scheduled task, this allows me to query yesterdays data much quicker - it is used for trends so up to date in not important - the problem i have is this I want others within the company to be able to connect to my PC to run their own queries against my data. i do not know how to set up the ODBC connections on their PCs to 'talk' to mine. I can set them up to connect to the US with no problem but not to my PC.
Only Allowing One Entry
I am trying to create a simple guetbook. I have it working, but the thing is, it only lets me enter one entry and can't work out why. This is the insert code i have: PHP Code: $insert="Insert into visitordata (name,email, location) values('$name','$email, '$location')"; mysql_query($insert) or die("Could not insert your entry");
Not Allowing To Read Files
I have program with data accessed by MySQL. In my assume, I copy program and its data files to my friends, and they run program with pleased faces. And now, the first friend wants to delete all program related data files and copy program related data files from second friend(or he can also get any program formatted data files) and save them into data folder. My problem: the first friend can run program with only my data files; he can get any data files from anywhere and save them into data folder, but program won't be allowed to read these data. Does everyone have some good ideads?
Allowing Remote Login
I have been using MySQL for awhile, and for the first time someone from outside our portable /16 needs access to some tables. We have given them the server IP address, the dB name, the port 3306, the root username, and the password, but they still can't get access. Of course, no firewalls or other things in the way. Is it true that MySQL defaults to local access only, and to enable remote access you must do something unusual with grants? If so, how would I do this? (warning, we use the win version, but this question is not a windows-only thing so it is topical for this list:-)
Allowing Multiple Hosts...
I am creating a vb.net app that conncects to mysql with the corelabs provider. This app will be deployed on our intranet. My question is this: Do I have to create different user for each host? For example, my ip range is 192.168.1.*. Can I create one user with this host "Range" and allow them to connect. If so, how do I accomplish this.
Security Across The Internet
I am somewhat new to accessing a MySQL database across the internet. I would like to write a thin client that accesses the database on a remote site; however, I must be assured that the queries and - especially - the data returned is secure. IOW, I need to make sure that no prying eyes can spy on the data being returned to the application. What are your thoughts on this?
Internet Phones
I have a question regarding internet phones. Lets say I have a list of a few hundred clients in a mySQL database w/ their phone lists, does anyone know if there is the technology to make telephone calls easier by automatically pulling from this database and making calls? If so, any links?
MySQL Dump Is Not Allowing Application To Run
I am creating a backup once per day automatically. The current size of the file is around 4.1 Gig uncompressed. The command that I use is as follows: mysqldump --opt -q -R -u username-p'passwd' dbname | gzip > /filepath/$(date +%F).sql.gz This takes around 25 - 30 minutes to fully backup the database. The problem that I have seen is that while this backup is occurring I cannot access my JBoss application. Oddly enough, I tried to access the database directly and everything is working fine, but any other remote user cannot access the database. I want to know a couple of things: 1) Is my backup command optimized or is there something else I can add to make it faster. Now I do need to backup the data, table structure, stored procedures, etc. 2) How can I conduct a backup that is more efficient where it does not interfere with the remote users?
Special Characters Allowing Insert
I'm trying to learn SQL and my first attempt is to take all of my flat text files and add them to the database using perl. I wrote a script that will open every file and insert it's contents to the database. So each line is a seperate prepare() execute() call. I get through 4 records then it stops and my error log says 'error around 's'' or something. I look at the s it is talking about and it is the first instance of an apostrophe so I figure that is probably what is causing it. I tried $text =~ s/(['|"])/($1)/g; but that didn't work out well
MSDE And Internet Applications
clarify the position re MSDE and it's use a database for internet applications. Is MSDE 2000 licenced to do this is it not allowed?
Turning Off Allowing Multiple Non-unique Rows
I feel lazy and I am busy so i don't want to fix my perl code to only alllow insertion of unique rows. I know mysql is set to allow multiple rows of the same thing but I would like to turn that feature off. Is that possible?
MySQL Partial Replication Over The Internet
We are looking to migrate from a Microsoft Access database to MySQL for our CRM application. However one of our requirements is the ability to synchronize partial replicas - both from a laptop on a LAN and also from a remote location e.g. a branch over an internet server. Our current solution handles the situation fine but falls down when attempting to do a partial replica synchronisation over an internet server. The application is a CRM system (Customer Relationship Management) with one central server at head office and several subsets of the database sitting on sales reps notebooks. Eg the HO server database contains all the customer data but each sales rep only has their own customers and related data on the laptop. It is critical, that we can give a sales person on his laptop only his section of the customers - not the entire CRM database. The reps would need to synchronise their laptops on the LAN.
Internet Port 3306 Open Safe
I have a server at an ISP - I've got port 3306 open in the firewall so that I can work from remote however its got me thinking if its safe? I know Microsoft got hit with slammer (or whatever) worm on their unpatched machines that were exposed to the outside world, but I'm trying to measure up the risks by having my db server exposed for a few weeks.
Can Access Remotely, Cna't Access Locally (seems Backwards)
I have a database that I am trying to connect to a schema called lportal4_1_2 in mysql 4.1.13a (provided by my hosting company) runnning in fedora. I am trying to get a container to connect to it and was having problems. Since I didn't want to pollute the problem with the container, I wrote a small (hack) program that does the connection. Here is the problem: I can connect from my desktop (winxp) using a Java command line application, Mysql Administrator and mysql query browser and everything works fine. When I run the same Java command line app (using the exact same driver) I get the Access denied for user error that follows: ---- java.sql.SQLException: Access denied for user 'lportal'@'inkbrains.com' (using password: YES) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2975) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:798) at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3700) at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1203)...........................
Can't Access Created DB's Via PHP, Though Can Access Them Via PhpMyAdmin
I can create databases via mysql-shell and edit them. These then do show in phpMyAdmin and are editable. BUT, if I try to access these db's via a normal php-script (i.e. $ergebnis=mysql__list_dbs($server)), it only shows me one database, the test-db. (To show them, I use a for-loop which counts the elements in $ergebnis from 0 to the number smaller than mysql_num_rows($server) and then prints the string.)
Get Access Denied Msg..how Can I "reset" Mysql Access
I downloaded the windows installation last night - mysql-4.0.16-win.zip - unzipped it to c:ms, double clicked on setup.exe and nothing.... nothing happened at all.... Bad download I though, so tried the same thing with the .zip of version 3.25.55 I had - the downlaod that I used once before, before my recent re-format - so I knew that it did work once, but this time, same problem. The setup.exe just doesn't do anything... I really want to learn mySQL, but if I can't even install the thing, it doesn't look good!
Access To Sql With PHP
I want to setup a database using MySQL with PHP. I have taken an Excel workbook with tabs for products including a tab within the workbook of the actual catalogue to facilitate the lookup function. I then created an Access db with linked tables from the workbook. I then converted the Access db to MySQL. I think I would rather do the whole thing in MySQL and PHP, but I am limited in knowledge. I want to replicate the same thing in the Excel workbook in MySQL with PHP. Can I do this? Is there any tutorials or templates I can use to get started? I want to publish it for intranet.
Access From Web
I've installed mySQL through YaST (SuSE 9.0 Pro). I have no problems accessing the mysqld or mysql. Although when I attempt to access it from the web (phpmyadmin), I come up with a "unable to connect /var/lib/mysql/mysql.sock". Well this isn't anything new. By default YaST installs this to /var/lib/mysql/mysql. I've done the needed alterations in my.cnf (that I know of). So I'm stuggling when it comes up yet again through the webserver. If apache 2 points to /var/lib/mysql/mysql.sock by default where can I edit this? Thanks in advance. I'm sure this is something really stupied that I missed.
MS Access
How do I to move data on an external server (over the Internet) in mySql to MS Access on my office computer. I would like to remove the data from the Net and store it on my computer.
TCP/IP Access
I'm looking for information on how to log on and access a databases using TCP/IP. I don't want to use MyODBC or J or .NET or anything else, I don't want to telnet and use a shell... I just want to send stuff over a port and get an answer back. As far as I understand it, I'm going to have to dissect libmysql.c. Ok, but hasn't somebody already done this? And anyway, where the heck is it? None of the archives I can find have any source code in 'em.
Cannot Access DB
I have MySQL 4.3 running on a Red Hat server. The DB files have permissions -rw-rw---- with the Owner and Group mysql. Using mysqladmin, I can access the DB as either root or as the user, "todd". With this script, I get this error: Access denied for user 'todd'@'localhost' to database 'sfyc' I am not sure what to check/change in the user or db tables. Code:
Allow Outside Access
I want to allow outside access on my MySQL Database. Basically, I have an online database and want to connect to it on my computer not on the server. How would I do this?
DB On MS Access
I am trying to learn and utilize MySQL as the storage for my Sports data and I am having some difficulty implementing the database. I have zero formal training in databases and everything I have learned has been from books and trial and error. I "learned" using MS Access. But due to storage limitations, I am attempting to use MySQL due to its high praise. I have two questions: 1- What is the comparable process to the Compact/Repair procedure in MS Access and how do I implement that? I would prefer to do it thru the GUI tools if possible. 2- I have heard of many people using Access as the FE. However, after I have set up the ODBC driver and try to connect to the MySQL DB thru Access, everytime I attempt to establish a connection my instance of MS Access crashes. What am I possibly doing wrong? The funny thing about the connection is that I do not have issues tryign to connect to my DB thru Excel.
Ms Access
The simplest problem in the world and I can't solve it. Could anybody please help me with this simple sql query. All I'm trying to do is insert a record into the db but it isn't having any of it. Here's the query:- insert into OrderDetails (OrderID,ProductID,ProductName,UnitPrice,Quantity,Battery_Quantities,Battery_Type,Colour,Condom_Quantities,Condom_Sorts,Cup_Size,Fetish_Size,Flavour,Material,Option,Pattern,Shoe_Sizes,Size_Ranges,UK_Dress_Size) values (62,2441,'Colt Room Odouriser',4.99,1,'NA','NA','NA','NA','NA','NA','NA','NA','NA','NA','NA','NA','NA','NA') MSAccess at least gave me nice error messages telling me where I'm going wrong. MySql just TELLS you you are wrong and then gloats as it watches you spend three hours rewriting the sql and guessing what the problem could be...
Access
I have access to a mysql database , owned by a customer of mine, for whom i have written a very simple access front end, the database consists of 4 tables. three of these allow me to add / edit/ delete records via odbc from access, the forth will not. The tables and my access tabes seem to all be set up the same way, the only diference i can see is that the problem table does not have a primary key defined. accessdoes not even show an add new record icon.
MS-ACCESS
I am having a database of 75-100 tables in MS-Access and now my boss wants me to migrate it to MySQL. Above this he also wants me to setup a colaboration between Ms-Access and MySQL through which all the changes in MS-Access will be directly made to MySQL and vice versa. Can anyone help me with reading material links, tutorials or any resources available with this?
Convert MS Access To MY SQL???
I need to convert an existing MS Access db to an MySQL database. The MySql is on a server maintained by my ISP. The Access db is on my PC. What would be the best way to do this?
Access Hosts
I'm trying to figure out a way how to automatically create access hosts with a PHP query. I'm not sure if this is possible, and I've never done it...though I only know that I can add access hosts in cPanel. Also...can an access host be a domain name, or does it have to be an IP? It will be appreciated if someone can help me with this. All the best, Contrid EDIT : Basically what I'm trying to do is I'm creating a database which will be hosted on my server, and I want other servers to be able to access this database. I don't want to manually add each IP/domain as an access host, but would rather want it to be automated, since they will be purchasing a subscription to use the service.
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?
Access Denied?
i'm getting an access denied message when i try and insert data in to a new databse ive created. I can connect to the database server fine, and i can select the database unsing that connection without error. However, when i try to add data to a table within the database i get the access denied error. I am using code that i used elsewhere on the same server to connect to a different database so i dont think it is a coding error. I really dont understand what the error could be when my other databases work (phpBB2, and another). EDIT: I have solved this. Im ebarassed by how dumb I was being. I didnt realise that each different database on my host had a distinct username (albeit same password) to access them. Boy is my face red.
Excel To Access, Anyone Has Done It?
Well, I have changed that xls file to csv file. I also got the fgetcsv() function, there are plenty of examples in the php.net page ... It seems that it is possible to make a function that will give us a select statement which if run on the sql, will do the job. Wondering, if anyone has actually done it, I mean, if anyone has actually moved an excel table to mysql. Would you mind to share your code, if any? Or tips or hints,
Query From Access Log
SQL session_id (int) | user (varchar) | login_time (datetime) | logout_time (datetime)1 | JOHN | 2007-03-02 15:32:01 | 2007-03-02 18:01:552 | JOHN | 2007-03-09 11:43:33 | 2007-03-09 21:02:253 | JOHN | 2007-03-15 22:00:05 | 2007-03-16 06:37:214 | MIKE | 2007-04-02 12:32:01 | 2007-03-02 14:01:555 | MIKE | 2007-03-09 10:41:33 | 2007-03-09 20:44:15 For a result I need report of working hours (user is a employee). The first idea was: SQL SELECT `user`, `login_time`, `logout_time`, TIMEDIFF(`logout_time`, `login_time`) FROM `access_log`ORDER BY `user`, `login_time`; But access_log table may contain rows with a same time period (per user). For a example when user enters to the system twice from different PC-s (I can not disallow this), then this query gives double working hours
Need Access To Mysqldump
I running a third party backup plugin on a website. This plugin needs access to the mysqldump. I have FTP access to the public_html folder as well as its parent folder on the webhost. This host does have MySQL, but I can not find the location of the mysqldump. Is it possible that I can take the binaries of mysqldump, put it in some folder on the webhost, and point the plugin to these binaries so that the plugin can use mysqldump?
Access Denied
I installed MySQL-server-4.0.14-0.i386.rpm MySQL-client-4.0.14-0.i386.rpm when I give mysqladmin -u root it is asking for password . The doc says that initially the password is empty and we just need to press enter . I read the mailing list posting but didnt find any clue i didnt set any password . mysql ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO) how do rectify this.
Access Problems
I have a problem with my root user account. Everytime i try to connect to mysql, either via the command line or phpMyAdmin i get the old log-in error for 'root@localhost' (using password:NO)... Is there a way to discover if the password for the root user has been changed? I'm guessing not. If not, how do i go about stopping the service and re-installing it?
Can't Access Table
I ran a php script to delete about 4 million rows from a table with about 10 million rows. Waited for a while (20 minutes?) and it seemed to be stuck so I killed the script. Now I can't access the table (although I can access others in the database). What can I do to unlock or free up the table again? Would restarting mysql do it? Is there a way to do it without restarting mysql? mysql version: 3.23.58
Query From Access Log
I need help with query. I have access log table something like this: session_id (int) | user (varchar) | login_time (datetime) | logout_time (datetime) 1 | JOHN | 2007-03-02 15:32:01 | 2007-03-02 18:01:55 2 | JOHN | 2007-03-09 11:43:33 | 2007-03-09 21:02:25 3 | JOHN | 2007-03-15 22:00:05 | 2007-03-16 06:37:21 4 | MIKE | 2007-04-02 12:32:01 | 2007-03-02 14:01:55 5 | MIKE | 2007-03-09 10:41:33 | 2007-03-09 20:44:15 For a result I need report of working hours (user is a employee). The first idea was: SELECT `user`, `login_time`, `logout_time`, TIMEDIFF(`logout_time`, `login_time`) FROM `access_log` ORDER BY `user`, `login_time`; But access_log table may contain rows with a same time period (per user). For a example when user enters to the system twice from different PC-s (I can not disallow this), then this query gives double working hours :) So I need somehow to take into consideration user time intersection.
MS Access -> MySQL
I am converting some queries from stored procedures in MS Access to MySQL, and have hit my first problem. The Access query references another stored procedure, which is where the problem lies. I have the following table data: (apologies if the columns aren't aligned properly... it looks ok in a fixed-width font) ......
Access Denied
I have read Ref Manual 5.9.2 Adding New User Accounts and 5.8.8 Causes of Access Denied. I am running SUSE 10.1: /usr/sbin/mysqld Ver 5.0.18 for suse-linux on i686 (SUSE MySQL RPM) This works: mysql -u root -ppassword mysql Using user root, from Python I can access sql, add data to tables, etc. but I want to set up other users and access mysql from other than localhost. I tried this (as suggested in 5.9.2): mysql> GRANT ALL PRIVILEGES ON *.* TO 'pwh'@'localhost' -> IDENTIFIED BY 'password' WITH GRANT OPTION; mysql> GRANT ALL PRIVILEGES ON *.* TO 'pwh'@'%' -> IDENTIFIED BY 'password' WITH GRANT OPTION; But this happens: mysql -u pwh -ppassword ERROR 1045 (28000): Access denied for user 'pwh'@'localhost' (using password: YES) Ref man 5.8.8 says if all else fails, reinstall from the source. I started to do that but got stuck. I would rather not if it can be avoided.
Access Denied
When I try to connect to MySQL using a front end such as phpMyAdmin 2.3.3 or SQLyog (http://www.webyog.com/index.html) I get the following error: error MySQL returned: Access denied for user: 'root@localhost' (Using password: NO)
Access Denied - Please Help
I've started an online database school class and I am having a hard time getting past this point. I want to create a database and some tables, but I'm getting an access denied. I've tried some of the password recommendations of this site, but still can't seem to get past this. Can someone help (please expain very clearly, since this is the first time I've any database experience). Thank you. Welcome to the MySQL monitor. Commands end with ; or g. Your MySQL connection id is 1 to server version: 4.1.11 Type 'help;' or 'h' for help. Type 'c' to clear the buffer. mysql> show databases; +----------+ | Database | +----------+ | test | +----------+ 1 row in set (0.02 sec) mysql> USE mysql ERROR 1044 (42000): Access denied for user ''@'%' to database 'mysql' mysql> USE test Database changed mysql> show tables from test; Empty set (0.00 sec) mysql> create database customer_db; ERROR 1044 (42000): Access denied for user ''@'%' to database 'customer_db' mysql> show databases; +----------+ | Database | +----------+ | test | +----------+ 1 row in set (0.00 sec)
MS Access => MySQL
A friend of mine mailed me a access database (.mdb), but I only use Linux (RH 9.0). Is there anyway that I can open the database in mysql?
|
TRACKER
