MYSQL :: Accessing Remote DB

Accessing Remote Data Folder
I have MySql 4.0.17 server on my machine. My data

folder is on a network drive. Recently I installed

MySql 4.0.17 on a different machine, changed the my.ini

file to point to the same remote data folder and

restarted the MySql. I get the following error-

"Could not start the MySql Server on local computer.

Error 1067: The process terminated unexpectedly".

So I copied the remote data folder onto my local

machine and changed the my.ini accordingly, it is

working perfectly fine. The storage engine is Innodb. Am I missing something here.

I am pasting the contents of my my.ini file below. Code:

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?

Accessing MySQL From VB6
Does anyone know how to access a MySQL server from vb6?

ACCESSING A FILE
I have installed MySQL version 5.0.41-community-nt on my machine using a windows installer. The tut was done using version 4.1. I was able to follow everything in it up until the last two steps of the tut. I was trying to create a table called "createnamestable.sql" within the "test" database by creating it in notepad, pasting the following code in it:

CREATE TABLE Names (
ID INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
FirstName TINYTEXT NOT NULL,
LastName TINYTEXT NOT NULL
);

Then place it in any folder and then try to open it with the following syntax:
C:Program FilesMySQLMySQL Server 5.0data estcreatenamestable.sql;

To my surprise it did not work. I thought that putting the "createnamestable.sql" file in the same folder as the "test" database would help but it didn't
The errors I get are:

Error:
Unknown command 'D' .

Error:
Unknown command 'M'

Error:
Unknown command 'M'

I don't know what else to do. is the syntax that I used wrong for my version of MySQL? I would really be grateful if someone can help me out with this.

Accessing MS-SQL Server
I need to integrate some data of a system that uses MySQL 5.0 with one system that uses MS-SQL Serve Express Edition.

How can I do this? Is it possible call a SP in the SQL Server database from a SP/Trigger in the MySQL database?

Accessing Dev.mysql.com
I'm trying to download MySQL4.1 from the MySQL site and when I try and
go to the download section on the site it either fails or, if it loads,
the "pick a mirror site" links always fail.

By "fail" I mean that it doesn't manage to retrieve the requested page,
either sticking on "waiting for dev.mysql.com" or "connecting to
dev.mysql.com" in the status line of the browser, eventually giving up
with an "operation timed out" error message.

Is anyone else having this problem or is it just me? - this has been
ongoing for the past couple of days now.

Incidentally, I need a version of MySQL that can handle subqueries yet
I'm still using glibc-2.2.5-40 and Redhat 7.3 (upgrading simply isn't an
option right now) - can anyone suggest a stable sub-version of 4.1 that
fits this criteria?

Accessing Data With In It
I have a problem selecting records with in any values.

For example:

SELECT * FROM ADDRESS WHERE STREET = "A"

will give an error:

If I replace with then it works. Eg.

SELECT * FROM ADDRESS WHERE STREET = "A"

Is there any setting in MySQL that can overcome this?

Accessing MySQL
We currently have several web servers and mail servers that access either a local or remote MySQL server. Remote access is "accross" the internet, but all of these machines are physically in one place. We have decided to build a machine dedicated to MySQL and have all other servers use remote access. What is the best practice for the connection. Should the MySQL server reside on the internet and be accessed there or should we create an internal network using non-routable IPs and only access the MySQL server from there?

Database Accessing
I am created a database in one pc and i copied the database to another pc.when i try to execute on any tables in that database i am getting a error that table doesn't exists.how to solve this problem?

Accessing Phpmyadmin
ive been trying to figure this out for a while and heres my problem...I go to security and change my password, and then i go to config.inc.php file and change my controlluser and user to root well its like that already, but then i change my passwords to match... and it still wont let me in. please someone help. And am i suppose to change both controll user and controllpassword .and user and pasword?

Accessing Tables
I am writing a php ui for admin of Jabber2 user information. Looks like most user info is stored in a MySQL db. However the table names have some '-' in them. For example, I am trying to run the following command:
desc roster-groups;
and I get:

ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '-groups' at line 1

Accessing All Databases
I have a problem everybody who has a username and password can access to all databases even mysql database (the one which user details are in it) and able to delete or edit any data.

I thought mysql is on skip grant tables mode but I did reload or flush-privileges nothing changes.I manualy go there any set all privileges to that user N but that user still able to access only mysql database and this is very dangerous because they can edit or delete any user. I tried to delete user and any user can delete any user yes.
In that case I need your help what command I need to write to fix this problem.

Accessing MySql
i've a machine (win 2000) that has MySql (at work)
how can i access mysql in that machine from my machine at home (winXp Pro)?

Accessing MySQL
how to access mySQL using visual basic? i tried to make connection with ODBC but it seems couldn't find the driver.

Accessing MySQL
I am developing an IVR application and will host it in-house. The application will need to access MySQL database which is hosted remotely in a web server. How could I access remote MySQL database using ODBC?
Does the web server have to support SSH?

Accessing A Databse
I am new to programming, I am working on HTML forms in which i am using checkboxes now, when the user clicks on the checkbox, then i have to call a function which does some math for which i have to access the database. For which i thought i will use PHP. Can i use onclick event in PHP or I wonder if i can access a database through Javascript.

Accessing DBMS
Some of our customers have remote offices. I was wondering if it'd be
safe to have a DBMS running at their central office, and have our
client application running on hosts in the branches connect to it
through a VPN via the Net?
What happens if the connection goes south while a branch office was
making changes? Does the DBMS just rollbacks changes automatically
after a time-out?
Should we set up some kind of replication instead?
Also, are there compeling reasons to go for Firebird instead of MySQL?
I don't know enough about the capabilities of each DBMS today to make
an educated choice.

Accessing A Table
I've been using a simple table within a database for a year or so now without any problems. It has an index called 'id' (int(11)) which increments every time a new record is added, 10 columns of various types and probably around 3 million records. Recently this table has stopped responding.
I can:
describe the table
see the table using 'show tables'
perform all normal operations on all other tables in the database

I can't:
update the table
check the table (I think - it has been running for an hour with no response)
select any data from the table, even something simple like max(id)

Does anyone know what the problem could be?

Accessing Only Part Of A Database Value
I'm currently writing a form where a user will input the first three characters of a postcode.

In my database I have registered users full postcodes, but when I run my query I only want to match the from the form to the first three letters of the database value.

Accessing MySQL With OpenOffice
This question is about MySQL and how it can be accessed with OpenOffice
(presumably the same issue would arise with MS Office, but I'm not sure
about that). The problem I'm having is with the setup in OpenOffice.

The database currently consists of a single table, located in
c:MySQLdata. The database is CD_Collection; the table name is Album.
There is no password associated with the database/table. (I'm just
getting started, and wanted to keep it as simple as possible; I'll add
the controls later.)

OpenOffice is version 1.1.2

I'd like to be able to open a text file, and import or link the document
to the database.

In the Data Source Administration window:

- At the General tab, I've changed the Database type to MYSQL.

- at the MYSQL tab, I'm not sure which Type of Connection to check, so
I've tried both "Use existing MyODBC data source" and "Use connector /J3
MYSQL JDBC driver class"

- Under General (still at the MYSQL tab), the Data Source URL shows up
as either "sdbc:mysql:odbc" or "sdbc:mysql:jdbc" depending on which Type
of Connection I check, but I'm not sure what else should appear on the
line (that I should type). I have typed in <localhost>:<3306> and a path
to the database, but I still get the same error as follows when I move
to the Tables tab

- when I click on the Tables tab, I get the following error:

"No connection could be established for the URL
sdbc:mysql:jdbc:<localhost>:<3306>" then the path I've typed.

I'm quite sure the information I've typed in the Data Source URL line is
the problem, but none of the examples in OpenOffice Help lead me to a
solution.

Accessing Comments For Each Field
I have my mysql database setup and for each column/field I have added a comment. How would I access these specific values?

Accessing Mysql From Another Host
New install of mysql on Solaris 10 x86.

I cannot connect from any other host, lots of traffic on google with people with the same error. Talk of the grant command fixing this, but no details. So simple question.

What "exactly" do I type to allow connections to port 3306 from another host to avoid messages such as

ERROR 1130 (00000): Host 'am-ms-t.foo.baa' is not allowed to connect to this MySQL server

Accessing MySQL Database.
I have recently installed MySQL 5.0.27 / PHP 5.2.0 / Apache 2.2.3 on an XP os.

I created an empty database via the MySQL command line which is visible when I type SHOW DATABASES at the mysql prompt.

I have changed my root password which works OK.

I set up the password to the empty db by:

GRANT ALL ON database name.*
TO username@localhost IDENTIFIED BY 'password'

To access the db, when I type :

mysql -D dbname -u username -p

I do not get a prompt to enter the password.

Accessing Existing DB From Files Off A CD
I inherited a project from another developer who was fired. There is no database documentation. There is both an SQL backup file and the original database files on a CD. I have recreated the db from the backup file and that worked perfectly. However, I don't have full confidence in the accuracy of the backup file. I was wondering if I can somehow access the db from the files on the CD.

I copied the files to a folder on my machine and then changed the MySQL data folder setting to that folder. Unfortunately MySQL wouldn't start. What would I need to do to be able to have MySQL use the files copied from the CD as the data files?

Accessing Mysql Server On LAN
I have a problem accessing mysql server on my LAN: i can access it locally but not from other machine.

The error is: Lost connection to mysql server during query.

I've disabled the firewall but it's still not working. What i don't know is if i set the users correctly...

Accessing A Mysql DB Remotely
I am building a kiosk which uses a lockdown browser. The browser uses a php page to access a MySQL DB on a web server. It will not allow me to connect to the DB because I am using the following connection string:

mysql_connect("localhost","*****","*****");
mysql_select_db("******") or die ('I cannot connect to the

database because: ' . mysql_error());

I know that the problem here is that I'm trying to connect to 'localhost' when the actual DB resides elsewhere. The question I'm asking is how to find out how to connect to my DB. Is it just mysql.mydomain.com instead of localhost or what?

Accessing A Table Line
I have a table in my databasee called tablebob. tablebob has three fields (idnumber, address, other). the table is organized by the idnumber. The problem is I don't know the idnumber.

Please Note: because of responce time problems, I can NOT have the php page search through the entire table, and check the contents of each row one by one. I need to submit a quary saying something to the affect of "select from tablebob a row where address = www.google.com"

Accessing MySQL Data
This morning when I tried to access my MySQL installation through MySQL Query Browser, all schemas have a message stating "Fecthing Data..." when I expand the schema. If I access MySQL through the command line, I get the following message when I execute a "use" command:
"Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A"
If I execute mysql using "-A", then it appears I can access the data, but it's very slow. Has anyone experienced this and if so, do you know how to resolve it?

Accessing MySql On Yahoo
I have never used MySql before.I program in C# and Visual FoxPro against
MS SQL on a corporate network.
I have a Yahoo web page, and I'm going to use their MySQL DB.
I want to run queries, Inserts, Updates and Deletes.
I have no idea how to connect to MySql on Yahoo from a client like
C# or VFP.

Accessing Mysql/bin Directory Problem
This may be very basic question, that I hope some of you can answer very quickly for me. I'm running mysql 4.1 on windows xp just to learn the database, and I'm in a need to run .exe in the bin directory. The problem I'm having is accessing this directory. The path is C:/Program Files/Mysql/Mysql server 4.1/bin but when I get to C:/cd "Program Files/..." I get an error message saying (parameter format not correct - "program) i have tried several things, as well as following a user guide for changing directories that states that if the folder name has spaces use " to access that subfolder...maybe there is a simple tip ...

Trouble With Accessing Database -- Too Many Rows?
The database is used for an online game. One of the tables keeps track of all the lands in the game. There are 7 continents, each with a different set number of regions (239 in total). Each region has 625 sectors, and each sector contains 25 lands. The total number of rows in the database is 3,734,375. I recently populated the table with the necessary rows. The table comes out to over 93MB. I've already modified the structure of the table to maximize the space usage. I had no problems accesses my database before populating the world. However, now that I have, I can't access the database as a whole. I can send queries to select certain tables (such as the user table), and even check out the individual table structures in phpMyAdmin. But it locks up every time I try to connect to the database directly (ie selecting the database using phpMyAdmin or connecting through the game). I suspect it's because of the huge amount of data in the database. I tried to send a query to delete all the records in the land table, but it doesn't go through and just locks up.

Accessing Mysql Database From Php File
I can access mysql in dos with the command of c:mysqlinmysql -u root mysql but when i write the command of mysql_connect ("localhost", "username", "password") i don't know what my username or password is.

I have installed Apache to run the mysql database and php on my computer although I don't know where to find out the username and password so if someone could help that would be great.

Accessing Mysql Programs Remotely
Is there any method you can use to access the mysql programs (mysqld, mysqladmin etc) from a remote computer? Or do they need to be ran on the server itself?

Error 1130 When Accessing MySQL From Another IP??
I am trying to run the MySQL DB on a Linux machine that is part of a home
LAN (IP=192.168.0.3), while trying to access it from another WinXP machine
(IP=192.168.0.5). I keep getting the following error:

MySQL Error Number 1130
#HY000Host '192.168.0.5' is not allowed to this MySQL server

Ping works fine.

On searching the internet, I find reference to "allow list" hidden somewhere
in the guts of MySQL. Can anyone provide me hints on how to add to this
list?

Accessing Mysql After Fresh Installation
I have recently installes mysql -4.0.0.1 on my redhat 7.1 machine . After
installing when enter into mysql it gives me message " Access denied for
user root@local host .......using password yes"

i have tried all the options like

#mysql -u root -h localhost
#mysql -u root -h localhost -p
#mysql -u root -h localhost -p mysql
#mysql -u root -h localhost test -p
#mysql -u root -h localhost test
#mysql -u root
#mysql -u root mysql

but none of the option is working at all.

Please any idea how i can change the root password or enter the mysql after
fresh installation.

Accessing Multiple Databases Thorough My Website
I am building a website at the moment, to try and run from multiple databases.I want to use two separate Mysql Datbases or one mysql and the other oracle. I want to be able to (link, relational) these togther in my website. Is this possible?

Accessing Mysql From Command Prompt
The path to my mysql installation is "C:Program Filesxamppmysqlin".

I want to run myisamchk - to do this I think I have to access it via the command prompt.

A stupid question - I kmow - but how do I get to the directory in a DOS window??

Accessing MySQL On Linux From Window
Is it possible to have a visual basic application running under windows and
access MySQL database on a Linux box?

Any extra drivers required for this?

Accessing MySQL Data Via ODBC
I keep going back and forth on this as to whether it's an Oracle issue or a MySQL.

Not sure if this is allowed, but I've cross-posted this question in the Oracle: Oracle release - 8 and 8i forum, with a similar message there that it is cross-posted here.

Scenario: I am successfully accessing MySQL data via ODBC through Oracle's Heterogeneous Services. There is a problem, however. Hence, this post. Suppose my query looks something like this:CODEselect "f1","f2","f3" from MySQLTable@MySQLDB

Error Accessing MS Access Table
In order to perform a hetrogeneous join (I think that's what they're called)
between MySQL and another database, I've created an Access database
containing linked tables from each datasource.

I create the linked tables without any problems, clicking on "save password"
before selecting the desired tables. I can then access both tables fine from
within the Access GUI.

The problem starts when I then try to access this data from my ASP.NET web
application - classic ASP works fine but .NET gives me...

ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver] ODBC--connection to
'MyDSN' failed.

From then on, the Access database remains locked (.LDB file in the same
directory) and I get a similar error when I run my ASP page, which
previously worked.

Users Accessing MysSQL Database
How can my clients access a web MySQl database using client tools lke Access, OpenOffice base, etc?

Problem Accessing Floating Point Values...!Plz Help.
I have a table and from a column in the table i'm accessing values. I found that only floating point data is not accessible. For example if i issue this below query it gives empty set.

select * from audio where audio_sr=44.1;

whereas when given as below,

select * from audio;

i can see rows having 44.1 as data value in audio_sr column.

Whats the problem please help.. I'm using mysql version 5.0.18 software.

Accessing MySql Thru Coldfusion - Password Problem
I have downloaded MySql 5.0 for Windows (XP) and MySqlCC so I can interact with it. When I installed MySQl I created a username and password which I can see in "my ini" file. I don't remember creating any passwords through mysqlcc.

I am building a database driven website using "macromedia studio MX" and am experiencing problems accessing my Mysql database through that software - I keep getting asked for a login ID and password, and for the life of me, have no idea what they are.

1. When I originally added my database as a 'data source' in Cold Fusion (MX 6.1 administrator) it would not let me create a password. I kept getting error messages like "The root cause was that: java.sql.SQLException: Invalid authorization specification: Access denied for user: 'martin'@'localhost' (Using password: YES)" etc etc etc variations on that theme. (adding the database without a password wasn't a problem)

2. Now I am trying to create a dynamic page in Dreamweaver (using Coldfusion) to display my data â€“ there is a 6 point process in the â€˜server behaviorsâ€™ tab and Iâ€™m up to the last one â€œpress the (+) plus button and choose â€˜Recordset (Query).

WHEN I SELECT MY DATABASE AS A DATA SOURCE IT ASKS ME FOR A "LOGIN ID" AND "PASSWORD."

I've tried all the passwords I can think of that I used and nothing works, the error message I get is:
"-1:Syntax error or access violation: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'wine like '%' at line 1. this is then followed by about 27 lines of commands like "at org.gjt.mm.mysql..".bladedblahdeblah "
(I am creating a database of wine tasting notes)

Accessing Mysql On Win2003 Server From A Station
I have installed Mysql on a Win2003 server and it is running as a service. I created a database and it works ok on the server logged on as root.

I then tried to access the database from a station on the network using PHP code and I get the error - Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in G:InetpubWWWrootIntranetookingacc.php on line 10.

Do I need Mysql Client on the station or does it run on the Server by default?

Accessing Floating Point Data From Table...
I have a table and from a column in the table i'm accessing values. I found that only floating point data is not accessible. For example if i issue this below query it gives empty set.

select * from audio where audio_sr=44.1;

whereas when given as below,

select * from audio;

i can see rows having 44.1 as data value in audio_sr column.

Whats the problem please help.. I'm using mysql version 5.0.18 software.