473,385 Members | 1,829 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

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:-)

Thanks in advance for reading a post like this with such a dumb question!

Mary Grace

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***********...ie.nctu.edu.tw

Jul 19 '05 #1
0 4186

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

9
by: Marina Anufreichik | last post by:
Hi, After deploymnet web application on web server I can access page on local machine and login fine but when I'm trying to access web site from remote machine I can see login page, but when I'm...
1
by: Tom | last post by:
Hi, I built several web applications and all work on local and remote servers. Recently, I built one web application which works on local server. However, the login page can be shown on remote...
8
by: Ray Stevens | last post by:
Because this worker process using the local ASPNET userid, it is unable to access Sql Server databases on a remote server. I believe the solution is to use a domain id and apply it to both... but...
0
by: manas | last post by:
I have two Web applications..... One of the application is local and one application is remote.. How can i authenticate my remote web application from my local web application.. I have a...
0
by: manas | last post by:
I have two Web applications..... One of the application is local and one application is remote.. How can i authenticate my remote web application from my local web application.. I have a...
3
by: fritz-bayer | last post by:
Hi, is it possible to create remote virtual tables in mysql? By that I mean if it is possible to define a table, which actually resides on a remote mysql server, but which can be accessed and...
1
by: james2 | last post by:
I am trying to write a perl script that will do remote machine. I have done user loging using simple command; $telnet->login('test', 'test123'); But now I want to do root login or superuser...
0
by: Gregor Kovač | last post by:
Let's say that we have 2 users on Win XP PRO SP2 and they are both in DB2ADMNS group: USER1 USER2 When I login with USER1 to console I can normaly use database (connect, select ...). If I...
0
by: fred64 | last post by:
Hello , I fought very hard and succeed to do a remote debug from a client with VS2003 on XP HOME to a Server with XP PRO. This is on a Workgroup : I created same user/pwd with admin rights...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.