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)...........................
View Complete Forum Thread with Replies
Related Forum Messages:
How To Access A MySQL DB Remotely
There are some interactions with a MySQL DB that is stored remotely on a web server. I know I have to change the connect function to reflect the fact that the DB is not local, thereby replacing "localhost" in the connect function with something else.. Question is, what is that something else? IP? IP+Port? How do I get this config info?
View Replies !
Can Only Connect Remotely, But Not Locally
The issue I'm having is that I can only connect to my database as the root user when I'm connecting remotely. In other words, only the user 'root'@'%' is able to connect. I believe this because I'm able to query databases using MySQL Query Browser (which would use the 'root'@'%' user to connect, as it's being run from a computer that is not the same computer that the database is running on). However, when I use any connection that connects as 'root'@'localhost' (for instance, a Python script run on the server), it gives me the following error: 2002, "Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)" I was able to connect earlier. However, after losing ssh connection in the middle of having a script running on the server, I started having this issue. I've restarted the server twice now, with no results. Oddly enough, the script works if I connect as '(the server's name)' instead of 'localhost'. Additionally, I can't run /bin/mysql anymore either. I assume that it's trying to connect through 'root'@'localhost' as well, because I get the same error.
View Replies !
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.)
View Replies !
Cpanel Can Access But For Others Access Denied
I can access my database through Cpanel's GUI with no prob, but when I tried using MySQL-front in my comp, it always give me an error access denied. I supplied correct username and pass but still no luck. and How do I configure MySQL-front to connect to my webserver's mysql db?
View Replies !
Order Backwards
I have a table with the column blogid. When I use this query Code: SELECT * FROM blog ORDER BY date LIMIT 0,3 It gives 1 2 3 But I need it to give 3 2 1 Anyone know how to do this? Thanks.
View Replies !
Importing Difficulty >Backwards Compatibility?
I exported my DB with phpMyAdmin 2.6.0-pl3 running MySQL 4.1.7 I'm trying to import it with phpMyAdmin 2.5.7-pl1 running MySQL 4.0.20 Is this possible? I seem to be getting this error: MySQL said: SQL-query : CREATE DATABASE `win2ksh_aspsupport` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci MySQL said: #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 'DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci' at line Is it an issue with versions of MySQL and backwards compatibility?
View Replies !
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.
View Replies !
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:
View Replies !
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.
View Replies !
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...
View Replies !
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.
View Replies !
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.
View Replies !
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?
View Replies !
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?
View Replies !
Access Log?
I know you can make a general query log by adding something like 'log=/var/lib/mysql/mysqld.log' to /etc/my.cnf. But such a file gets humongous extremely quickly, and also I don't think it records user IPs. Is there any way to make an access log? For instance one that only records login IPs, usernames, and database names? What I want to check is whether anyone from an IP I don't recognize is logging into MySQL. Alternatively, is there any way to, for instance, have an email sent to me if a user logs into MySQL from an IP that isn't in a list of IPs I specify?
View Replies !
MS Access Equivalent
I am new to Linux and am migrating a SQL Server DB with an Access front end to MySQL and ? What options are available under Linux for development of a client front end without copious amounts of programming. Without knowledge of PHP can a front end be developed using plugin components with minimal fuss ?
View Replies !
Mysql->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.
View Replies !
Access And MySQL
I can link MS Access (front) with MySQL (back end). However, when I add a new record, the previous added record is signed as Deleted record (view in Access) even I can view this record in MySQL....
View Replies !
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).
View Replies !
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?
View Replies !
User Access
I have added a user, this user can attach to mysql i.e. mysql -Uusername -P database, but they can't access the database I want via use database; What permissions do I need to check?
View Replies !
Access From Behind A Firewall
I have a yahoo web-php-mysql account and they place their mysql database behind a firewall that can only be accessed via PHP code running on their machine. Does anyone know of a proxy package that can allow you to access mysql from a PHP script running on another machine, for example? This scenario is becoming very common in today's webhosts so I imagine others may have already gone down this path.
View Replies !
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) ......
View Replies !
MySQL, Access
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 field). I tried to create a local replica of the ODBC database, but the local replica still requires an ODBC connection to the running mysql server. I do not know why. What is teh best way to realize synchronization between a local and an odbc database using MS Access ?
View Replies !
CMS Access Rights How To?
I have a Content Management System (CMS) which will be used by clients to update their site. The CMS has multiple users. What I'd like to implement is access rights. Some users are not allowed to update or can only view and not update certain sections of their site etc. I've read a lot about access rights and found out role based and page based methods of dealing with this. I am not planning to use role based rights since the amount of users is not large and its one of our requirements :( I will use role based management later when I implement website user management. Anyway how would you recommend me to design this for use with MYSQL database? I'm using ASP.NET 3.5. (but I'm interested in the MYSQL Part)
View Replies !
Converting Access From .CSV
I am trying converting a query in MSACCESS 2007 into *.csv File to upload them on the web server MYSQL database using PHPMYADMIN Actually I am a little bit confused because there are many types of *.csv file (common delimited, Macintosh, Dos ) Is *.csv file type is the best file format for MYSQL to be imported ?
View Replies !
Access Violation
Access violation at address 0035CE63 in module 'libmysqlx.dll', Read of address 00000 I am getting this error whenever I am editing records in my database. The error pops up when I click Apply Changes. I am executing the query: SELECT CompName, ScoreAvail, RecAvail FROM Compositions; If I enter SELECT * FROM Compositions the error does not happen, and I can edit records just fine. There are 15 columns in the table, so it takes forever to tab to the next one to be edited. Specs: MySQL Query Browser 1.1.5 Windows - MySQL 4.1.9-standard on a seperate Linux server running Fedora Core 3. I have even tried the same thing using the Linux Query Browser 1.1.5, but when I click Apply Changes, the program just dies with no error messages.
View Replies !
Access Mysql
I've been having weird issues with one of my tables - some records are disappearing - how can I check if my db has been violated or accessed by someone else
View Replies !
Access Database On Web
I have a database on a webserver and now would like to write a small windows application to access this database, read and write to it. As I understand it correctly, I have to code in the username and password of the database. So, the question is, if I deploy this little application to other users, can they not get hold of my username/password by just decompiling the application? Is this not a big security risk? Or are there other ways to read and write to the database without me coding in my password?
View Replies !
MS Access Db To MySQL Db
I tried converting a MS Access table (made from an Excel spreadsheet) to a MySQL table in the built-in 'mysql' database, but when I look at the table in MySQL, it only shows the first 1000 rows of my table. There are supposed to be 2800+ rows. I can't believe I'm exceeding any memory issues here - is there a better way to turn my Excel spreadsheet into a MySQL table without losing rows? Or is there an easy way to just add the rows to the table in mysql? I tried the 'insert' button, but it places the new row at the top and I need to tack it all at the bottom.
View Replies !
Ft_min_word_len=3 With No Access
I'm doing a personal project, so I'm using a freebie 1and1 hosting setup I had spare, only problem is I don't have easy access to the MYSQL server config files, and I need to make full text search go down to 3 letters (if not 2). Does anyone know if I can do this through telent (which I just used to set up phpmyadmin) or if it can be dones through phpMyAdmin?
View Replies !
Gaining Sql Access
i've recently joined a company using windows hosting, though im used to unix hosting. i've been left no reference for anything by the last employer, and im attempting to gain access to mysql on a dedicated server. i have access to the server, but no password for mysql. the interface used is mysql administrator, but i obviously cant get passed the login screen. im assuming if im ontop of the server, there must be a way to find the password for mysql's "root" user, or hack in somewhow. there may be more users than just root, but i simply dont know. php 4.2.something is also installed if any of its functions would help.
View Replies !
Restrict Access
I have a mysql server running on the same computer as users run database applications. The OS is Win2k. One of them could easily tamper the database by replacing mysql files. I spent last two week trying to limit access to mysql files. I have tried to deny all users, but Administrator, access to the files. The result is that not even the Administrator can access files even if he has full access (????). I've also tried to let mysql service logon as Administrator, but as long as Users don't have access to the mysql files, mysql won't start.
View Replies !
Access Database
I am having trouble getting started. I have an Access database with multiple tables in it, and I want to post it on a website so that people can search it and edit it. I dont konw really where to begin. I have a domain with MySQL capabilities, but I really dont know what to do next. I would really love some hand holding, and it wouldnt take that much time to teach me how to do it. IM me at RND328 if you are willing or just respond to this post.
View Replies !
Limiting Access
I'm currently making a Visual Basic application that, when run, presents the user with a username and password field. Their account corresponds to one that is from a forum, the database of which is in a remote location to where the application is running from. If I create a new user to access MySQL, how do I allow any IP address to connect to one specific database, while still only allowing all other users to connect from "localhost"?
View Replies !
MS Access Integration
We have an Access database we are going to stop using as soon as I am done setting up a new MySQL system. However, the Access DB has reached it's space limitation of 2GB (??). Is it possible to have new data be placed into MySQL and have Access find it there?
View Replies !
MS Access SQL To MYSQL
here's the situation... i used to use access but now i use php with mysql... i need to 'convert' this to php... its too difficult for me... here it is: SELECT Emissor, Base, Sum base*retorno+kms*0,3 as total, Sum base as total_base, Sum kms as total_kms, Sum kms*0,3 as value_kms, count NGuia as number, sum Tespera as Total_espera FROM baterist_guias GROUP BY Emissor, Tservico; and by the way can you tell me how to retrieve the values that are calculated in this command? like total_kms or total_base...
View Replies !
Mysql Access
My computer crashed yesterday (of course I backed my data) So I'm in the process of getting things back up and running. The problem I'm having is with mysql. My site is currently offline. When I try to access phpmyadmin I get wrong username/password. When I access a survey program that I wrap in mambo I get: Error Error connecting to database: Client does not support authentication protocol requested by server; consider upgrading MySQL client How do I get access to change my username and passwd in mysql?
View Replies !
Password Access
I built a new MySQL DB, 5.x, been using 4.x. I moved DB's and user over and have not been having troubles. But now when I try to create a new user for a new DB I keep getting this error: access denied for user@localhost (using password: YES) I have read all the stickies, tried all the set to old password examples, deleted and recreated the user and DB, and still no success.Do all user have to use Old password technique if one uses it? Or can new users use the newer hash?Any other ideas of what I can check to fix this problem? I am going a bit nutty trying to figure it out.
View Replies !
Root Access
I got a somewhat wierd issue I was working on my databases when all of a sudden I get disconnected from the server. When I try to reconnect it tells me that root@MyIP is denied. I tried rebooting MySQL with --skip-grant-tables and then reissue the grant command for root which seemed to have worked, then I rebooted mySql again with the grant command turned on and I no longer have access to my sql server.
View Replies !
Slow Db Access
I have worked with a few mysql dbs on different servers but i have recently been asked to work with one on nicnames. It seems horribly slow. Working in phpMyAdmin (which i had to install myself) it takes ages when i want to do anything. View the table structure, view the data..etc. Any way i can test the speed so that i can compare it against another server i work with and proove there is a speed issue and take it to nicnames cus it is crazy and is going to affect the speed of the website!!
View Replies !
Denied Access
Just having a go at creating an SQL database and I get this error: ERROR 1044 (42000): Access denied for user ''@'localhost' to database When I connected to MYSQL it asked for my password... and I am the administrator... Looking forward to hearing from those in the know!
View Replies !
MyODBC And DB Access
I setup Apache, PHP, and Mysql on our internal server probably 5 years ago. It works so good I NEVER have to do anything so I've gotten really rusty. The problem is we use UPS through MyODBC to add shipping data to our DB. We recently got a new computer to run the UPS stuff. I can't get MyODBC to connect from the new computer to save my life. I joined our domain restarted a bunch of time and still when I setup the system I get an error to the effect of "Matt@MASTER" password =yes access denied. Now here is the kicker. the computer name isn't master its been renamed. I removed the 3.5 MyODBC driver and installed the 2.5 like the old computer had just to be sure. It is doing the same thing. So I found a way thanks to google to grant access to that username in a range of IP addresses. here it is: "GRANT ALL PRIVILEGES ON db.* TO matt@'192.168.0.0/255.255.255.0'; which has a result of 0 rows effected!? I have tried a different user when using the mysql program on the server machine and been able to login with it and the matt user mentioned above. However still nothing at the MyODBC end with the UPS system.
View Replies !
Remote Access Through TCP/IP
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.
View Replies !
Access Connection
I am a true newbie to MySql.I have created an ODBC connection with XP to my MySQL database (for osCommerce). It reports a successful connection (woo hoo!). However, when I try to create a linked table in MS Access 2003 to the database I get the following message: Odbc call failed [MySql] [ODBC 3.51 Sql Driver] User Cancelled. (#0) Clicking help gives this info: ODBC – call failed. (Error 3146) Using an ODBC connection, you tried to perform an operation on data in an ODBC data source. This error may occur when the ODBC data source is on a network drive and you are not connected to the network. Make sure the network is available, and then try the operation again.I need this connection to access customer info for use in Access. Please don't tell me I don't need Access.
View Replies !
Client Access
I need to run client programs which access a database over the internet (or . Has anyone any experience with this. In particular I'm interested in the performance as compared with access within the local network.
View Replies !
|
TRACKER
