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 Complete Forum Thread with Replies
Related Forum Messages:
PHPMyAdmin Import From Access
I'm using PHPMyAdmin on an Apache2Triad install (latest version; 5.x.x, which installs PHP5 and PHPMyAdmin 2.8 as well). In Access, I exported a table to a text file, tab-delimited, text qualifyer of "none" (this is how I read to do it from newsgroups). When I use the Query window in phpmyadmin to import the text file, it waits a while, then returns an 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... And then is followed by a text string of my field names separated by tabs. In addition, in the big colored Error box, it shows the text value of a couple fields, and I notice that a lot of SQL syntax words that happen to be in the Access Memo field are highlighted (for example, if the sentence that's in one of Access's memo fields is "This field requires that peaches and cream should join in milk", the "AND" and "IN" and "JOIN" are highlighted in green, which I assume means PHPMyAdmin (or MySQL) are trying to parse and run the strings in my fields, instead of just importing them as text data values to be put IN a field. So, is it really true that text qualifyers cannot be used when exporting in Access? It seems I need to somehow tell either MyAdmin or MySQL that this is a table, not a SQL string. I notice that in MyAdmin's control panel, in the part where you browse to import a text file, there is a "Format of imported file" at the bottom left, with only a SQL radio button checked (ie. I can't change the format; it's only SQL available as a choice). Is this the problem? Don't I need to tell MyAdmin (or MySQL) that this is a text file, not a SQL command? Do I need to make the table in PHPMyAdmin first, and THEN use PHPMyAdmin to make and name the fields and set their field data types, and THEN try to import? I was under the impression I could just import a whole text file as a table, without a whole bunch of preparation. Can someone help me figure out exactly what needs to be done to import Access tables into MySQL using PHPMyAdmin? Also, assuming I somehow get this figured out, I also have HTML in some of my Access tables' memo fields. This mdb was the back end for an ASP site, and there is an option in Access and/or the FrontPage Data Results tool to check YES for some fields containing html (which enables html code to be written out of data in the table's fields). So, for instance, I can have the value in a field be: '<a href="blah.com">Click Here</a> to see further news on <more asp code here to write the current record data>' Will I run into problems with this down the road, like can MySQL not store text and html code in fields?
View Replies !
PhpMyAdmin Access Denied
i'm putting together a typical LAMP server & it was going well up to phpMyAdmin. I unpacked the tarball moved it over to localhost/myadmin. Opened it up in a browser & it says Code: #1045 - Access denied for user 'root'@'localhost' (using password: NO) Natch.So i use the setup script, save it and get the same notice. This seems odd because I definatly did provide a password. Then I configure it to use the user 'pma'. The error code still says denied for 'root'@'localhost'. Now I'm thinking that phpMyAdmin isn't using the config file. As far as I can tell the right config file has been created in the right place (myadmin/config/config.inc.php). And config.inc.php looks right. It makes me suspect something beyond phpMyAdmin. I double checked that mysqld was indeed running and that the password I gave for root in the config file works. Are there some permissions that need to be reset or something?
View Replies !
PhpMyAdmin :: Access Denied
I have given root a password in MySQL, but now phpMyAdmin says "access denied". I've put the following line in config.sample.inc.php: $cfg['Servers'][$i]['password'] = 'password_goes_here'; but it doesn't seem to make any difference. How do I get phpMyAdmin to recognise my root password?
View Replies !
PHPmyAdmin :: Access Denied For User
I login to my cPanel and click PhpMyAdmin and try to create the table "x_referrers" and it spits on the error message: #1044 - Access denied for user: 'x@localhost' to database 'x_referrers' It's never done this before, nor have I changed anything, what should I do?
View Replies !
Phpmyadmin :: Import Access Database
i have a access database that wich i want to convert to mysql. first, using Access i export it to .txt after that i try to import it using phpmyadmin and it keeps saying "file could not be read" i did the same with an excel file converting it first to CSV (comma separeted value) and then when importing it to phpmyadmin i get the same error.
View Replies !
You Don't Have Permission To Access /phpMyAdmin/ On This Server
when I go to http//localhost/phpMyAdmin/ using my browser, I get the following error. You don't have permission to access /phpMyAdmin/ on this server I have installed and configured php 5.0.2 and apache 1.3 and MySQL 4.1.7 and phpMyAdmin .6.0. Does anyone know what exact changes do I have to make to my httpd.conf file?
View Replies !
1045 Access Denies / PhpMyAdmin
Hope someone can help with this - it was working yesterday, so I know it's mostly all set up and working, but have just managed to screw some permissions somewhere. Basically I have (or had) a working database / website all working - it's on a local network rather than external hosting, using phpMyAdmin. I started setting up a new site yesterday, and - having not done it for a while - was having to rummage around checking the set up etc. ie the : $hostname_connDevelopments = "localhost"; $database_connDevelopments = "developments"; $username_connDevelopments = "root"; $password_connDevelopments = "password"; Where I created the password in phpMyAdmin. When I finished yesterday I had managed to get a new website set up in Dreamweaver, a new database set up in phpMyAdmin, and the connection to database from DW. Database connects successfully in DW, pages uploaded can be browsed to correctly, so it all looks all present and correct. However, when I tried to browse to the old site this morning, I'm getting the following error in my browser : Warning: mysql_pconnect() [function.mysql-pconnect]: Access denied for user 'root'@'localhost' (using password: YES) in C:wampwwwPhotolibraryConnectionsPhotolibrary.php on line 9 Fatal error: Access denied for user 'root'@'localhost' (using password: YES) in C:wampwwwPhotolibraryConnectionsPhotolibrary.php on line 9 I've managed to fix this, by changing the password in the Photolibrary.php to the same as the one I created in the connDevelopments.php. (I originally thought they needed to be different.) However, the other problem is that I can no longer access phpMyAdmin, as I get the following error : phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in config.inc.php and make sure that they correspond to the information given by the administrator of the MySQL server. #1045 - Access denied for user 'root'@'localhost' (using password: YES) I'm presuming I changed a setting for access to phpMyAdmin yesterday when I thought I was creating a password for DW to connect to the database, rather than for me to log in to phpMyAdmin. Unhelpfully it just goes straight to that, so I don't have any opportunity to enter a password. Presumably I need to change something in my config.inc.php file - I've looked for anything to do with passwords, ie changing 'using password' from yes back to no, but with no joy.
View Replies !
PhpMyAdmin Unable To Access New Database After Creation
I am a bit confused about something in phpMyAdmin. By default, there are two databases: test & mysql. I am able to access these via a php script w/o any problems. However, when I create a new database I am unable to connect to it and more disturbing is the fact that the newly created dB does not appear in the drop-down menu (LH side) along with the two default databases. I know the new db exists because if I try to create a new db with the same name, it says it already exists. Any idea what is going on here?
View Replies !
PhpMyAdmin - #1044 - Access Denied For User
I am attempting to setup my database with my host, Turtle Hosting. I'm using phpMyAdmin, but it is giving me the error: SQL query: CREATE DATABASE IF NOT EXISTS `crmpicco_mini` ; MySQL said: Documentation #1044 - Access denied for user 'ayrshire'@'localhost' to database 'crmpicco_mini' I logged into my MySQL Client on my local machine, and entered: "GRANT ALL PRIVILEGES on crmpicco_mini.* TO 'ayrshire' IDENTIFIED BY 'mypassword';" I log into my control panel with Turtle Hosting with the username 'ayrshire', so i presume that is why it has defaulted to 'ayrshire' as the db username.
View Replies !
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 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 !
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 !
|
TRACKER
