MYSQL :: TCP/IP Access

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!

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.

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?

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

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")
_____________________________________________________

'Access LIMIT'
Is there a way to specifiy a password with mysqldump? I would like to add a few mysqldump commands to a cron but can't seem to figure out a way to schedual them without direct user input of the password

mysqldump -h mysql.yourdomain.com -u user -p dbname > /home/user/mybackup.sql

Access To Mysql Db
I've just installed Mysql and PHP on IIS 6.0

On IIS I've created a website, where I have imported a php based website which include a folder with a mysql table.
I can't figure how to establish connection between the installed Mysql and the table on the we website.

When I try to access the index.php on the website I get an HTTP-error 403

How do I set the rights in order to establish mysql connection?

Blob Access In C/c++
I wonder if anyone would be kind enough to post a minimal snippet of c/c++
code that demonstrates how to store a blob into a table / extract it again?
(Or any pointers to tutorials covering this'd be great, too).

Access Denied
I've created a user by a grant statement, but when I try to login as the new user I get
"ERROR 1045 (28000): Access denied for user "

Any ideas what I might have forgoten?

MS Access Or VB With Mysql?
Currently my organization is undergoing restructuring of existing databases. Previously, certain applications were made using FoxPro and other applications were using MS Access. What i am planning to do is migrate everything to mysql, using it as backend. Now my problem is regarding the Front End? Which application to use? Visual Basic or MS Access? What would be more advantageous in terms of performance and future support and consume less time for modifications?

I tried to search online but really could not find anything to justify any particular choice. Can anybody plz suggest some idea here or give some reference, which will help me finalize the decision regarding the appropriate front end. Any sort of comparision between MS Access and VB as a front end would help tremendously.

Access Denied
I'm new to Mysql and have just installed it for the first time. But everytime I invoke the mysql from the command window, my access is denied, and I
recieve this error "Error 1045 Access denied for user 'walter@localhost'
using passwork yes.

Also, when I attemp to use the mysql administrator, I get the same
message.

Access Rights
After installing mysql under WindowsXP, (logged in as Administrator) I obtained the following results.

C:mysqlin>mysqlshow mysql

mysqlshow: Access denied for user: '@localhost' to database 'mysql'

C:mysqlin> mysqladmin proc
mysqladmin: process list failed; error: 'Access denied. You need the PROCESS privilege for this operation'

How can I get access the mysql database and how can I get the PROCESS privilege?

External Access
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 Denied
On a php page I put mysql_connect() and it says "Access denied for user 'ODBC'@'localhost' (using password: NO)"

(Note: "password" means my actual password.)

Then I went to the mysql console and typed "use mysql" and typed "update user set password=password("password") where User="Root""

Then, on the php page, I put "mysql_connect("localhost", "root", "password");"

And then on the page it said "Access denied for user 'root'@'localhost' (using password: YES)" How do I fix this?

Can't Access Database
I have just installed MySQL version 5.0.18 on a VMWare session running Suse 10. I was able to start the server, create a database, and create a user with permissions to said database.

I am able to connect to the database and run queries on it remotely from the host OS (keeping in mind that the database is on a virtual machine, so this is technically remote access). However, if I run the admin.php file for PHPNuke or the vb_test.php file from vBulletin, I'm unable to access the database. Do these forums not support the newer versions of MySQL?

MS Access And MySql
IÂ´m working in an application using Access as FE and MySql as BE.

When I add some registers to the linked table, OK.

Problem: When I try to add a lot of registers (700.000!) it doesÂ´nt work and the msg is that the computer doesÂ´nt have memory resources to do the job.

Cant Access Table
i have managed to set up a login system using mysql with no trouble. now i want to insert data from the mySQL table to a webpage, i have made the following PHP code (passwords and so on ive left out :) but there right):

<?php
mysql_connect("host", "user", "pass")or die("cannot connect");
echo "Connected to MySQL<br /><hr />";
mysql_select_db("members") or die (mysql_error());
echo "Connected to Database<br /><hr />";
?>

i tested the first part and it connects to the database, however when i connect to the table it comes up with:

Access denied for user 'user'@'%' to database 'members'

i dont know whats wrong? the only thing ive seen is in my mySQL database it says No Privileges on the main screen could this be it? its a college created account so they could be blocking me.

MS Access To MySQL
I am upgrading a websites database from Access to MySQL. the tables work and so do many of the sql statements all be it with a bit of tweaking but I can't find what is wrong with this one:

SELECT First(B.ID) AS FirstOfID, I.Title, Count(*) AS qty FROM B LEFT JOIN I ON B.IID = I.ID WHERE B.UID=1 GROUP BY I.Title ORDER BY I.Title;

Mysql And Access
Is there any type of free or cheap database tool out there that will allow me to create forms/applications, that are stand alone and does not need a browers. Sort of like Oracle/Access.

Remote Access
I have a MySQL server running on my iMAC and am able to access my databases locally. What steps do I have to do to allow access from a remote PC thru TCP/IP ? The manuals say it can be done but don't specify what is involved.