Hi, i installed MySQL in my linux.
I want to access this Database from Internet Or from local LAN.
So can u pls help, how to do this..?
In my linux machine, i use 'mysql -u root -p' to get into MySQL DB.
But through nternet or LAN, how to do this..?
3 1856
I have found a handy utility called Navicat
You can get it here http://www.navicat.com/download.html
ak1dnar 1,584
Recognized Expert Top Contributor PhpMyAdmin also a good one. and open source too.
Hi, i installed MySQL in my linux.
I want to access this Database from Internet Or from local LAN.
So can u pls help, how to do this..?
In my linux machine, i use 'mysql -u root -p' to get into MySQL DB.
But through nternet or LAN, how to do this..?
hi, sorry for my english .......blah,bla h,blah
in a lan server
you must create or modify user to able it to connect from a remote client
sintax: grant <privileges(a ll for all)> on <dbname.*(*-* for all) to '<user>'@'<ip of remote machine (%=all ips)' identified by '<password>'
ex
grant all on *.* to 'master'@'%' identified by 'mypwd'' client
you must have mysql.exe(windo ws) on the client (or what you use in linux). Do not install it !
type
mysql -umaster -pmypwd -h<ip address of the remote server> -P<port> (if not standard port 3306)
add 'with grant options ' to ability grants to remote client to create/modify/delete other users
also you can use the MySqlAb's utility from
http://dev.mysql.com/downloads/gui-tools/5.0.html
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: Otto Krüse |
last post by:
Hello,
I've made a small GUI program that connects with a MySQL database to
collect information which is put on the screen. The database and the
program are used for testing purposes so I installed them locally and
only use them locally (so on my own computer).
When I run the script from a system (WinXP) shell through the python
interpreter all goes well. However when I make an executable program of
it through py2exe there's a...
|
by: Chuck |
last post by:
Here is my setup.
Netgear Router with a webserver and database server NAT'd behind the
firewall.
Microsoft Windows 2000, IIS 5 - Web Server
Microsoft Windows 2000, MySQL - Database Server
What I would like to have is a web application served up off my WS
(web server) and that application access my DS (db server) without
|
by: MLH |
last post by:
I have a friend with a database application on a web server.
He has invited me to attach to it so I can extract data from
it periodically. I have a few questions...
1) I have a DSL connection to my ISP and I think my buddy
has one too. Can I establish an ODBC connection to his data-
base? What information would I need to gather that would
allow us to do this?
2) Can I "turn the connection on & off" at will? Are there any
|
by: Daven Thrice |
last post by:
If I have a fairly big Access MDB, that is relational, and has, say, 100
objects (forms, reports, modules, etc.), what is the path to get this
database "online".
Is there a way to put the tables online and then distribute the front end to
each user?
What if I want to have all the forms and stuff online? How do you approach
something like that? Is it a total rewrite with another tool?
|
by: Beda Christoph Hammerschmidt |
last post by:
MySQL, Access, ODBC, Replication
Hello,
i have a central mysql database that is accesed by multiple clients
running MS Access with ODBC.
This works fine if Access has a permanent connection to mysql.
But now, i want MS Access to operate offline (e.g. on notebook in the
| |
by: areejan2000 |
last post by:
Experts/Programmers please advice on these questions.
1. Is Mysql secure than MsAccess (there are softwares avilable to
retrieve Ms Office Password)
2. Which 3rd Party tool Would You recommend for Administration,Query
creation.... Etc
3.Any tools for setup Mysql database to ship with ApplicationProgram
(Access need not be installed in a Windows machine)
|
by: roychong |
last post by:
Hi everyone,
I'm keen to use Access as a client application to access data from a MySQL database. The reasons are Access for its strength in reports creation and MySQL for its stability and scalability. I also intend to site the MySQL database with a web hosting service provider. This means I'll be trying to access the database over the Internet using MS Access.
I have managed to access MySQL using MS Access through MyODBC driver and get...
|
by: Cheryl Langdon |
last post by:
Hello everyone,
This is my first attempt at getting help in this manner. Please
forgive me if this is an inappropriate request.
I suddenly find myself in urgent need of instruction on how to
communicate with a MySQL database table on a web server, from inside
of my company's Access-VBA application. I know VBA pretty well but
have never before needed to do this HTTP/XML/MySQL type functions.
|
by: Mell via AccessMonster.com |
last post by:
I created databases on Access 2003 and I want to deploy them to users. My
code was also done using 2003.
If they have Ms Access 2000 or higher, will they be able to use these dbs
with all code, etc?
Please explain
--
Message posted via http://www.accessmonster.com
|
by: Kevin Killion |
last post by:
I've recently features to a system by making use of some simple MySQL
access routines. It works fine at most test locations, correctkly
accessing a MySQL database on an internet server.
However, at certain test sites, I cannot access the database. We're
online, and I can access web files, for example. But when trying to say
hello to that MySQL database, the program fails at the
"mysql_real_connect" call. The message is "Can't connect...
|
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| |
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |