Remote Connection Permissions
I have mysql4 installed in RHEL4. I need to enable remote connection in this db so that application server can get connected to db server.
For this, only creating user as
grant all on db.* to remote@remoteipaddress identified by pwd;
is this enough?
or shud i do any other step.
View Complete Forum Thread with Replies
Related Forum Messages:
Remote SQL Connection
I am trying to access my database on the server with a MYSQL front-end client on my computer (not the server). I have the correct username, password and database name. I tried every possible hostname, even its ip addy, but each time, I am rejected by the server, which says something like - access denied. I can access the database in my php code with 'localhost', but that's of course because the code is actually running on the server. Is there anything I have to specify on the MYSQL server in order to gain access to it remotely?
View Replies !
Remote DB Connection
I am trying to install SAM Broadcaster and it requires tables to be installed on a mysql database remotely. I am not able to connect to the database for some reason and I am wondering if this is maybe because the MySQL server I am trying to connect to has remote connection protection on (if there is such a thing). Is there a way of determining this and is there also a way if this exists to allow remote connections to add tables to a mysql database?
View Replies !
Remote Connection Error
I have been using a database on localhost for a while succesfuly. I am now, however going to be using this same database remotely. Whenever I attempt to connect to the database remotley I am given the error message: Warning: mysql_connect(): Can't connect to MySQL server on 'my ip' (10060) in C:OpenSAApache2htdocsindex.php on line 9 I have removed the bind-address line from the my.ini file in C:Windows as I read in a previous post you should do, and restarted mysql, but the error still remains. Does anyone know what i'm doing wrong?
View Replies !
Remote Connection Via Internet
Alrite i've really briefly used mySQL with java but only with a local database. I need help on how to create remote connections via the internet to mySQL. Basically i've been trying to test out connecting via the internet from my home machine where mySQL is installed, i've tried this through windows command line and doing: mysql -h myip -u myuser -p also tried with --port=3306 but it doesn't work. Does the fact that i'm behind a router and have a different local ip matter? Or does the fact that i'm doing this from the machine that holds the mySQL database but i'm using the internet IP address to make it go through the internet. I've already opened up the port in my routers firewall. I wanted to create a java application that can access a mySQL database over the internet so I thought i'd try out remote connections on windows command line first. I'm very new to mySQL so any help in the right direction and/or what i'm doing wrong with some explanation will help me give a better understanding.
View Replies !
Remote Root Connection
I am new here and I have a problem with configuring mysql. How can I set up mysql to allow remote root connections from a specific IP range?? Is this possible at all?
View Replies !
Remote Connection Through Php Script
I have a mysql server running at the office on <officeip>:3306 I have a site hosted by a provider at domain.it I have granted privileges for existing user office as office@domain.it and office@domainip I wrote a php script using the parameters: $host='<officeip>' $user=office $pass='<thepass>' $db='<mydb>' to connect to the office db from the website. I get a 'Lost connection' error (no query to execute just connecting so no time-out problem) What do you believe is wrong with it?
View Replies !
Establishing A Remote Connection
I'm trying to enable remote connections to my mysql database. I'm getting a java.sql.SQLException: Unable to connect to any hosts due to exception: java.net.ConnectException: Connection refused error when I try establish a jdbc connection. I'm supplying the correct user/pass information. A quick google tells me that I need to enable connections from places other than localhost. okay, so I do a: mysql> GRANT ALL PRIVILEGES ON *.* to raghav@'%' identified by 'blah'; As can be seen from the table below, i've tried doing it for anonymous accounts as well, when all of this didn't work. I've flushed privileges, and restarted the mysql server. no luck. Code:
View Replies !
Remote Connection To Sql Server
I've set the remote website, dotbooks.org (207.44.234.74) as an "Access Host" in cPanel. I'm trying to connect to wiishare.org (70.86.206.218) The connection string I'm trying is: <?php $user = "username"; $password = "password"; $database = "database"; $link = mysql_connect("70.86.206.218", $user, $password); mysql_select_db($database, $link); echo mysql_errno($link) . ": " . mysql_error($link). " "; ?> The string works with localhost, but not like this. It just times out Warning: mysql_connect() [function.mysql-connect]: Lost connection to MySQL server during query in connect.php on line 7 Any suggestions?
View Replies !
Remote Connection Navicat
I m trying to connect remotely to mysql on my domain. Navicat works after opening mysql port:3306 on my firewall setting but Mysql query browser gives me the error below. I need to use query browser because navicat is commercial and i only have a trial release. So query browser needs to work for me. Any suggestions on how to sort this out?
View Replies !
Lost Remote Connection
I had a remote connection to my mysql databases working fine for ages, but today I heard it stopped working. I can't understand what is wrong - I thought we tested it after I changed the username & password for the db & all was well. I changed everything back to the default (original) connection info & still no joy. Even a short test script with the original master pw / username doesn't work. This is the error message I get from the test script: Warning: mysql_connect() [function.mysql-connect]: Can't connect to MySQL server on 'xxxxxxxxx.com' (4) in /home/xxxxxxxxxxx/conntest.php on line 2 Could not connect: Can't connect to MySQL server on 'xxxxxxxxxx.com' (4) I am on a shared server & therefore restarting the server isn't an option. Does adding a new user to the db screw up an existing remote connection? How would I fix it? I tried adding the port number to the hostname but that didn't work either.
View Replies !
Remote MySQL Connection Fails
I have two XP computers, with the same version of MySQL on each. I have the same database structure and data on each. Each computer has the same user name, and each MySQL database has the same user names. Locally on each, I can connect and work with the data. I can ping each computer from the other computer. My problem is that when I try to connect from one computer to the other I get the following error: Host 'XXX.XXX.XX.XX' is not allowed to connect to this MySQL server. This happens on both computers. I can not find the reason for the error.
View Replies !
Remote Connection Truncates Username
I'm having a problem connecting to mysql on a remote host because it truncates my user name (dbm.stetsonband.org): ERROR 1045 (00000): Access denied for user: 'dbm.stetsonband.@d199-126-224-237.abhsia.telus.net' (Using password: YES) Is there something I need to set in my mysql prefs somewhere?
View Replies !
Error 2003 On Remote Connection
I have a WinXP Home Edition where I have installed MySQL 4.x I can use MySQL Administrator on my server, but when I try to connect to my server by entering my WAN-IP, I get the error: "Could not connect to the specified instance. MySQL Error Number 2003 Can't connect to MySQL server on xx.xx.xx.xx (10061)".
View Replies !
Remote Server Connection Error
When I try to connect to my server remotely via mySQL Administrator, I receive the above error message # 2003 (Could not connect to the specified instance) However, the connection to my MySQL server works fine, once I have established a VPN connection to the school's network. Is there any way to establish the connection to my MySQL server without having to use the VPN?I run MySQL 4.1.9-nt on windows 2000.
View Replies !
Where Are Remote Connection Errors Logged?
The server machine accepts most connections, but wont accept connections from a version of mysql on another machine that was hand compiled to work w/in SGE. Instead it reports the following error: ERROR 2003 (HY000): Can't connect to MySQL server on 'billy.bio.nyu.edu' (111) However, when using a package-install mysql client on that same client machine, we can connect w/o issue.
View Replies !
Remote MySQL Connection Slow
I have a website on a dedicated server that was running really slow, so I got another, much faster server and transferred the MySQL database to this server. However, now when I connect to the faster server's database using the slower server's PHP web pages, the overall page loads much slower than when the database was on the slower server. Any ideas why this would be? Right now the host name is just an IP address. Does it need an actual resolved hostname to be fast? MySQL on the faster server is supposedly tweaked for fast service (my-huge.cnf).
View Replies !
Local Application Connection To Remote MySQL
I have managed to set it up on a remote server, I would like to know what' the best way to write an application, pref. in C++, that can connect to the remote DB over the internet. Basically, I hope to have a program running on a local computer collecting information and dumping it into an online MySQL database.
View Replies !
Remote Connection To Mysql Database Using JDBC?
I am trying to set up OpenOffice Base to connect to a remote os x server with mysql on it. It has the default mySQL JDBC driver class set to com.mysql.jdbc.Driver It also asks for server URL, should this be the ip address? Port number? Default is set to 3306. When I set the class it says that the JDBC driver could not be loaded.
View Replies !
Localhost Mysql Connection Pointing To Remote Server!
This one is beyond bizarre. For a few days I've been having trouble working on my site on my local machine. Everything was dog slow, and the information I was seeing coming out of the database was oddly out of date, even though I had synced to my live server several times. I finally discovered that the records I was seeing were consistent with the tables I have up on my Media mysqlle host, which I've been working on switching over to, but is not live yet. So to put it more clearly, when I'm running my local version of my site on my local version of Apache (on my Windows Vista laptop): 1. The php files being interpreted are indeed the ones on my local machine. 2. Any MySQL queries somehow reach up to Media mysqlle, and query THAT database (even though it has different login credentials). I'm using the following lines to create the MySQL connection: $sqlHandle = mysql_connect('localhost', '<myusername>', '<mypassword>'); mysql_select_db('<mydatabasename>', $sqlHandle) or die(mysql_error()); Is this weird, or what? Any idea what's going on?
View Replies !
Remote Connection To MySQL DB Server From Client With No MySQL DB
I have MySQL server running on a Solaris machine. I have a Perl tool that is run on multiple operating systems (Linux, Solaris, MKS on windows, CYGWIN on windows). I would like to post to the MySQL database on the Solaris machine from this script when it is run on the different local clients. All these clients share a single network share (available via Samba on windows). Is there a Perl module that I can install in the network share that I can use to connect remotely to the server DB?
View Replies !
MySQL Remote Backups - No Access To FTP Or Remote Command Line
I have a mySQL database located on a remote host's server. I would like to schedule a task on my local Windows computer to retrieve a backup/dump of this remote database. I have contacted my host, and they indicated that the server is only open to the Internet via mySQL. Therefore, even if I did have access to that server's command line (which I don't) to create dumps via mysqldump, I would not be able to retrieve via FTP. Does anybody have any ideas as to how I can generate backup files from my local computer through a local command-line interface? I have done it through a GUI (DBTools), but I would like to have it done via DOS batch, so that I can schedule it. Does anyone know of any mysql backup GUIs with command line switches? Or can somebody recommend an alternate means of getting a local backup?
View Replies !
ODBC Connection :: Unable To Create DSN Connection
This is my first task with MySQL. We have a site with php as front end MySql as back end. The remote database is on Linux. Now my task is to update some data to MySql database (on the web server) from VB. My operating system id Windows. I installed the MySQL ODBC 3.51 driver on my system. Now when i'm trying to create a DSN with the above driver, I'm getting an error ' Lost connection to MySQL server during query'. What could be the reason...the same error is coming when tried to create a ADO connection from VB.. and the same error when tried to create a service from MySQL front end.
View Replies !
Permissions On Mac
I used MAMP to set up MySQL and Apache on my Mac and installed Drupal. Everything was working fine but I thought that I had forgotten to change the password for the 'root' user in mysql. So,with MAMP when you go to "localhost:8888 it gives you a start page where you can access mysqladmin and others. I used mysqladmin to change the root user properties but now when I try to launch the start page I get "could not connect with mysql server" Any idea how I can get to MySQL another way and fix it without having to reinstall? My Drupal installation still works so I know MySQL is working but I can't get to the admin/start page anymore. Also, I'm a complete newb at this stuff.. I know I can go to a terminal session on my Mac to access mysql directly but I don't know enough about it to do anything.
View Replies !
Default Permissions
This is a fairly simple question but I'm new to mySQL. To log on to mySQL I need to type at the prompt: mysql --user='username' --password='password' as opposed to just typing mysql and being recognized without having to type identification. Anyone know how I can change this?
View Replies !
Database Permissions
I've got databases on one box i have to transfer to another box, both are running Linux one a Centos4 machine, the other rh9 i think. I could tar up the /var/lib/mysql directory, but i was lead to believe that was a bad idea. I don't know the permissions of the user's and i don't want to give out global permissions. What i was wondering is there a way i can do a mysqldump on the databases on machine1, which will drop everything needed to recreate them in to a .sql file, transfer that to machine2 and then use mysqladmin to load it and have all the settings back in business? I believe they're both mysql4 installs, though machine1 might be mysql3.23, not sure.
View Replies !
MySQL Have No Permissions
I have installed mysql (under SuSE 8.1) and everything seems to work fine when I am logged in as root. However, with my normal user profile I can get a mysql> prompt but have no permissions to carry out any database operations. I would really like to work with my normal profile and am hoping that it is merely a question of setting permissions correctly. Can anyone tell me which files and paths I should check (and change)? Ideally, I would like mysql to create and manage the database files in my normal /home directory (rather than in the mysql directories). Is this possible? Is this desirable? Which settings would I need to change to allow this? Or should I just let mysql create the databases in it's default directory and set the permissions there?
View Replies !
MySQL Permissions
I would like mysql to create and manage the database files in my normal /home directory (rather than in the mysql directories). Is this possible? Is this desirable? Which settings would I need to change to allow this? Or should I just let mysql create the databases in it's default directory and set the permissions there?
View Replies !
Permissions Change
Running MySQL 4.0.18 (upgraded from MySQL 3.x), I can set the host for a user to "%", and can connect from localhost just fine, as well as remote locations.On another server running 4.0.21 (clean install), if I set the host to "%", I cannot connect from localhost unless I also set a "localhost" entry as well for that user.
View Replies !
Permissions With New Db's
I've got php script that created a database, then the tables in the database. The user in which the script is run, doesn't have the permissions to create a 'new' db. Moreover, mysql says that because the user is trying to create a new db, and there isn't a row specifying that the use has permission, doesn't allow the user to create the db. My solution is that I can create a row in the mysql.db table that will allow for the user to have proper permissions. My problem is that once I insert that row, it takes another post to the page for the permission to actually take hold. Is there a way to have the permissions take hold sooner? Some of the things I have tried would be toRedirect the page to (with a php header call) to re-load the pageClose the mysql connection so that a new one would have to be opened
View Replies !
Resolving Permissions
I have mySQL Administrator (and subsequently mySQL) installed on my iBook. I want to connect to mySQL on my Red Had Linux 9 test server with the mySQL Administrator, but I get the following error message: Code: Could not connect to mySQL instance at [SERVER IP ADDRESS] Error: Host '[IBOOK IP ADDRESS]' is not allowed to connect to this mySQL server (code 1130) I'm sure there's an easy fix for this, but since I'm a bit new at this, I'm not sure where to look.
View Replies !
User Permissions
Is there a special permission required for a user to be able to run a "select ... into dumpfile" statement? I'm getting a 1045 error when attempting this on my server. I've already verified that file permissions are not an issue.
View Replies !
Custom Permissions
I need to assign different 3 different types of users, each with his own permissions and am unsure how to proceed. One of these users will require remote access to all records. I have mySQL 5 and mySQLadmin tool. Both are installed on WinXP and mySQL will be accessed through PHP's connection functions. Can someone show me an example of setting a user with specific table and row privileges for security purposes? ie: a a user can't modify adata in x table, only read. Another user can write in rows w and x of table y only and can read all of y table but not table z.
View Replies !
Trust Permissions
I am trying to configure a mySQL server on XP machine, and wish to allow ASP.NET application access the database from a remote machine. 1. How do I set Trust permissions to a catalog? 2. How do I allow remote connections?
View Replies !
Add Host To Permissions
Typically, one does something like "grant x,y,z on db.* to user1@localhost identified by 'password'". Is there a good way to clone the permissions for "user1@trusted-host1" et al? Particularly sometime later when one doesn't remember exactly what "x", "y" and "z" were exactly? I can look at the bazillion settings already there, but it's rather a pain to count exactly how many '"",''s and '"y",''s have to be where in the insert and what I really want is to just clone the entry, changing one field...
View Replies !
Outfile Permissions
I tried to write a query out to a file, but I got this message: ERROR 1 (HY000): Can't create/write to file '/home/jason/test.csv' (Errcode: 13) How can I set mysql to allow those permissions to write anywhere I want? When I don't specify the directory, the command works,
View Replies !
Root Permissions
root permissions are messed up, i'm unable to create new databases with root account and i cant change permissions for the root account while logged in as root mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'; ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
View Replies !
Permissions Problem
I can query my MySQL database with any SELECT, UPDATE, DELETE, etc. queries, and it works perfectly, but when I try to do a LOAD DATA INFILE query, I get a permissions problem. Any ideas why this might be?
View Replies !
User Doesn't Have Permissions?
I install a mysql backup utility to backup my database if things go wrong. I went to test it to make sure it would work as it emails me the sql file, I deleted my database (using phpmyadmin) and tried to import the sql file which shoots me an error giving me an error that I didn't have permission to create a database. How do I give myself permission to create a database?
View Replies !
Resetting Permissions On Windows
If I am using Win98 SE (yes yes, I agree...), will underneath still work: http://www.mysql.com/doc/en/Resetting_permissions.html ? I have tryed to follow above and similar advices, but haven't had a lot of luck. I will try again soon, but I was wondering wether there was an easier way (e.g. if there was a "reset" command I could run that also works on Win98). Code:
View Replies !
View User Permissions
Is there a way to query MySQL to find out what the permissions of the user currently connected For Example: Database: customer_contacts User : cust1 Table: Archives User Permissions: Read Only(SELECT). Is there a way to ask MySQL what User cust1 can do?
View Replies !
Database Creation Permissions
I have setup different MySQL users. I have removed all permissions for the users, and granted them full permission to their default databases I created for the. My question is, how can I grant the users permission to create databases. I want them to have full control to create databases, and delete any that they create. Is this possible, or do I need to create and remove databases for them as requested? I'm running mysql 3.2.5 on Redhat 9. I am not using any host permissions, table, or row permissions on the databases.
View Replies !
Cannot Revoke Databases Permissions
I have Mysql 4.1.12 running on FreeBSD 4.9 in that i have 4 databases, mysql, test, new, and xyz I have one user abc, if i login through abc user i can see three databases new, test and xyz i want to remove access to xyz for user abc tried all command to remove access but didnt help and tried phpmyadmin also it seems when ever i create new abc user deleteing old it takes the old privileges of its own and again it shows access to 3 databases i just want access to test, new for user abc.
View Replies !
How To Check Permissions On Tables
I'm developing in Groupware (a php / template-based tool for making office-like applications). It creates mysql tables as it goes. I am not seeing those tables being created, and I'd like to determine if it's a permissions problem. I'm in a shell on a Linux system, but I'm very unfamiliar with Linux command line. So far, I can logon as root, use database, show tables; (this is how I know my tables aren't there.) So, what can I do to ensure that my permissions are set up correctly? When I was setting permissions in the Linux directories, I used 'chown'.
View Replies !
|
TRACKER
