MYSQL :: Cant Access Table

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

Importing Table From Access
I've got a problem when I try and import a table into a MySQl database using MyPHP Admin and the Import CSV using LOAD DATA option.

For some reason only the last record gets imported, although there are almost 700 records in the table. I regular import data into two other tables using the same method without problems, so I'm pretty sure I've got all the right parameters set up when exporting the original MS Access table as a CSV .txt file.

Transfer Access Table
I am working on a client's site that is on a server hosted in Germany. Communicating with the hosting company is not possible, but I have been given access to phpMyAdmin and can access the database for the client. I have an Access database that has one table in particular with Data that I would like to transfer over to the mySQL database. Is this possible? I am now downloading a program that will convert the databases, but what about getting table a from DB A to DB B?

Backing Up A Table ... But Being Able To Access The Backup
I am making a database that has ordering information on it. When someone places in order it gets approved or not. When a order is placed, I want to backup the data(where it still can be accessed) and the orgainl database cleared so more orders can be placed(new ones)That way the old orders and the new orders do not get mixed up. So what I want to do is back up the orginal database and still beable to access it. Does anyone know if that is possble?

Access Denied On Individual Table
Trying to insert records into 2 tables of the same DB, using
Coldfusion query. It works on the first table, but on the second table
I get 'access denied', although I'm providing the same
username/password. When removing the username/password from the query
for the second table, it works! I'm confused, because the table should
have inherited the DB privileges (no table privileges set).

OLE Object From MS Access To A MySQL Table
I don't know which forum (MySQL or MS Access) that can help me, so I decided to put my thread on both. Sorry for the inconvenience.

I want to copy a table from MS Access to a MySQL table.

1.
The problem is, one of the fields in the Access table has data type of OLE Object. What would be the equivalent of OLE Object data type in MySQL?

2.
Quite often that I lost connection to mySQL Server when I'm trying to acess tables in my MS Access that are connected (through) ODBC) to MySQL (Error #2013). Is there a way to fix this?

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.

Trouble With Export Of Access Table Into Mysql
I exported some tables out of access into mysql and I cant edit and records under mysql root account through mysql's query browser. I can edit from mysql command line using same credentials while working localy on the mysql server. Wondering why Query broswers Edit button is greyed out.

Configure 2 Sites To Access One User Table
I have two databases on the same server with different domains. I would like both sites to access the same user database table. They have the same fields.

I thought that it might just be done with an mysql command, which will point one table to the other.

Upload .mdb Access Data Into MySQL Table
I'm new to mySQL, but used to SQL Server.....which I'd be using DTS for this whole process. I'm glad to have to learn to do it with mySQL though.

I have an Access .mdb file, that I need to upload from my local machine to our hosted mySQL site via BlueHost.

I'll be using phpMyAdmin. It looks like the only way is to import into an existing table is from a text file.

Are there any other ways to take the .mdb file and copy it up, and into the mySQL table?

I got a converter tool, Access2MySQLPro 5, which has 10 trial conversions. Didn't know if anyone else has better ideas?

Basically, I want to take this .mdb file data and put it on the mySQL table.

Slow Table Access On Local Machine
I'm running MySQL 4.1.7-nt on my laptop, and I'm accessing it through ODBC
(MyODBC-3.51.10-x86-win-32bit).

I'm developing a .NET web application, but I don't think that's relevant.

I already had the application running OK on my desktop, and when I created the
same environment on the laptop, retrieving trivial amounts of data (5 rows) from
a table is taking 6 seconds. Updates the same. IN otherwords any table access
takes 5 or six seconds. (Table only has about twenty rows in it).

I can connect to the database on the laptop from the desktop (i.e - application
runs on desktop, retrieves data from laptop - works fine, not noticeably slower
than local on desktop.

If I connect the other way - application on laptop, database on desktop, it runs
just as slowly as locally.

The effect is the same whether I connect to 127.0.0.1 or via the machine name. Code:

Access > Odbc > Mysql | Locked Table?
i have a mysql db and an odbc connection setup to it under user root. i need the odbc connection so i can have connectivity in access 2000. select queries work fine. i can view the tables in access etc.

however update queries won't work for me. i know last week it worked, and this evening after it not working i opened up another copy of the database and it worked on that one... but only once, i went back and it didn't work in that one either.

and for the life of me i cannot figure out what would be different with the database now.
the error i'm getting is just the generic: "can not update 3 records due to lock violations"

however, what is locking odbc/access out of the mysql db? is it mysql? is it odbc? or is access locking the records? im sure it isn't mysql, and i think it is odbc but i don't know where. i downloded new drivers for odbc. i thought about updating the access jet engine but couldn't find updates... Code:

Database Access Speed: More Tables Or More Fields In A Table?
I have a question: it is better to create a database where there are more tables or more fields in few tables? What I want is: high speed accessing, indexing and searching. So what do you suggest me?

Error Accessing MS Access Table Linked To MySQL
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. Code:

The Problem Is About Access Denied For User...how Can I Access The Mysql??
you can find some problems below. the problem is about access denied for user...
how can I access the mysql? ......

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!

Table Design Question? House Table, Owner Table, Code Violations Table - Best Way?
Given the tables:

HOUSE
house_ID
address

OWNER
owner_ID
name
telephone...

HOUSE_OWNER_JOIN
?

CODE_VIOLATION_HISTORY
house_ID
violation_ID
violationStatement
...

My goal is to be able to track code violations of the house PER owner.

For example, I need to display a page that shows the current house with it's coe violations and a link to show the HOUSE's history of violation regardless of owner, Like:

House 1009283
Address
Past history (link to the following)

House History
2001-01-04 Owner: John Smith Code Violation: Gutter issue
1999-06-01 Owner: John Smith Code Violation: Faulty Steps
1998-03-02 Owner: Sam Spade Code Violation: Driveway carcks
1990-01-12 Owner: Keith Sledge Code Violation: Grass untidy

For the design of the HOUSE_OWNER_JOIN table, I thought of two ways I could go on this and this is where I need your help.

Option 1:
Have the HOUSE_OWNER_JOIN table keep dates so I can track the ownership changes that way:

HOUSE_OWNER_JOIN
houseID
ownerID
dateOwnershipBegan
dateOwnershipEnded

then I could look up all code violations by date and associate them with their rightful owner.

==================================================
Option 2:
Have the HOUSE_OWNER_JOIN table be the primary keeper of identity data by adding a new primary key and changing the CODE_VIOLATION_HISTORY table to reference that table by chaning the referencing key from house_ID to house_owner_ID:

HOUSE_OWNER_JOIN
house_owner_ID
houseID
ownerID
dateOwnershipBegan
dateOwnershipEnded

CODE_VIOLATION_HISTORY
house_owner_ID
violationStatement
...

Two Table Query: Grab Rows From One Table Even If No Related Row In Other Table
PHP

$gettray = mysql_query("SELECT trailers.title,
trailers.link,
trailers.movie,
movie.title AS mtitle
FROM trailers,movie
WHERE trailers.movie=movie.word
ORDER BY trailerid
DESC LIMIT 6",$connm);

It works great, but there is one problem. It will not grab any rows from the 'trailers' table if a corresponding movie row does not exist in the 'movies' table.

I want it to pull ALL rows from the 'trailers' table, even if the corresponding row in the 'movies' table does not exist yet.

If the row does not exist in 'movies', the program than uses the entire trailer title like so

PHP

if($ttray['mtitle']) {
$newttitle = explode("-",$ttray['title']);
$newttitle = array_reverse($newttitle);
$ttitle = $newttitle[0];
$ttitle = $ttray['mtitle'] ."- ". $ttitle;
} else {
$ttitle = $ttray['title'];
}

Thanks
Ryan

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?

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?

Access Issues
I just got mySQL today on my fasthosts hosting account.

I want to use the administrator and migration tools which seem very good. I can connect fine to the Fasthosts server, but when I try to view users or add a table I get 'access denied for user xx'@'%' to database 'mysql' 1044.

I was only given one username/pass by my hosting company which I assumed would be the root?

p.s. the migration tools seems great. I managed to migrate my access db to my local machine in 1min!

External Access
This may seem like a stupid question, but I haven't been able to track down
an answer yet. We're going to try to access a remote MySQL server that is
protected behind a firewall. I know that we need to open a port, such as
3306, to access the server. My question is whether that port requires TCP,
UDP or both to be open.

Access Conversion
we are looking to convert our pages from Access to MYSQL (required for our host) and also our ASP pages. I am pretty familiar with Access and ASP but not MYSQL. What is involved in converting the database and then will it be necessary to change the ASP page connections to the database. the connections were made using a DSN-less connection. Here is an example:
_____________________________________________________
'Create an ADO connection object
Set adoCon = Server.CreateObject("ADODB.Connection")

'Set an active connection to the Connection object using a DSN-less connection
adoCon.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("database.mdb")

'Create an ADO recordset object
Set rsRec = Server.CreateObject("ADODB.Recordset")
_____________________________________________________