"Only Registered Developers Are Allowed To See The View The Progress Log."
I have had an account at mysql for years, but when I try to view the progress log for
a bug report, I get a "Only registered developers are allowed to see the view the progress log." message even if I am logged in.
Searching MySQL's site for that string brought up no hits. Does anyone know how to get past this?
View Complete Forum Thread with Replies
Related Forum Messages:
Registered Users
I have a simple bit of mysql to display the number of users on my service, by simply selecting the highest userid from the database. "SELECT MAX(id) FROM users"; It would appear that i have not thought this through correctly, as when a user is deleted from the database, it still shows the number of registered users as being the same. Is there an easy way to cound the number of registered users, without affecting performance too much?
View Replies !
There Is No 'root'@'%' Registered
Moving a cleanly running web application from a desktop machine to a laptop in order to make a presentation to a client in a remote location. Both machines Windows XP Pro. I use MySQLAdministrator (etc) for the interface. I've never used the command line. Connection string on desktop: "server=SVR2003;Database=tnhorse;Data Source=SVR2003;user id=root;password=XXX;" Connection string on laptop: "server=localhost;Database=tnhorse;Data Source=localhost;user id=root;password=XXX;" I tried using the actual computer name with the laptop (like the desktop) but I kept getting the message the "Host 'DellLT' is not allowed to connect to this MySQL server". I read online somebody tried "localhost" in place of the server name and it worked. It did so for me and at least got me into MySQLAdministrator! In the web.config file, however, I get "There is no 'root'@'%' registered". I hoped to show the application to my client tomorrow (12/10) but I'm completely stumped. I know there is a simple solution to this but being a relative newbie to MySQL (which I really like) I need somebody to give me step by step instructions. MySQL 5.0 ASP.NET 2.0 running in XP Pro.
View Replies !
MYSQL To / From Progress
Our main system runs a Progress db, that's where our billing, contract and order information resides. For this, we thought that it would be easy on the sales people to design a web form fill out all the required information and send it to Progress db. Our challenge has been that our web form will sit on a windows server (win 2k3 server) and progress is on a SUN solaris server and we can't find an ODBC from windows to solaris and viceversa for progress without installing a full copy of the db to the windows server. The ideal situation is to write directly to our progress db, easy hum? For the lack of a odbc like that, we thought that we could have mysql in between and be the medium between our web interface and progress db but again we can't find odbc drivers or don't know how to have these 2 beasts talk between them. MySQL is running under RH. Has anybody done something similar? Our other alternative is to ftp a text file back and forth with all the updates but we would like to avoid that, just a preference thing.
View Replies !
Progress Indication
I am using the mysql C API. I would like to know if there is any way that mysql can indicate how long it takes to complete a certain task that it is performing. For example, I have to load data from very large text files into my mysql tables and some text files takes longer than other, so using standard C++ win32API progress bar isnt much use for specific tables. Does it have a function similar to that of a progress indicator?
View Replies !
Retrieving Progress Information
I am trying to implement a progress bar in my application and provide the end user the information of how long the task (retrieving db info) will take. I wonder if there is no way to get back progress information from the database server. Does mySQL have such mechanisms for retrieving progress information?
View Replies !
Server Shutdown In Progress
I have a database with following tables (with records): HTML Code: AVAILABILITY (has 12,926 Rows) PRICES (has 12,926 Rows) VENDORS (has 347 Rows) here is my query Code: select * from AVAILABILITY A, PRICES P, VENDORS V where P.Pvendor = V.Vvendor and A.Oorder = P.Porder But I am getting this error Server shutdown in progress
View Replies !
#1053 - Server Shutdown In Progress???
Using this query: Quote: SELECT p.first, p.last, p.city, p.state, p.member_id, m.corr_type, m.member_corr_id FROM members p LEFT OUTER JOIN member_corrections m ON p.member_id = m.member_id AND m.processed=Ɔ' WHERE p.club_id = ð' AND p.memLevel=Ƈ' ORDER BY p.last i get this error: Quote: #1053 - Server shutdown in progress Any ideas why this might happen. It should produce roughly 250 results. Running MySql 5.0.27
View Replies !
Join On A View Without The View
I was wondering what the syntax would be to have a left join from one table to a resulting query without the view. Currently I use a view and it works fine but I was wondering how to achieve this without creating the view. Here is the current view's SQL statement ( without the create view etc)...
View Replies !
Host Not Allowed
So, my problem is: Host >compname< is not allowed to connect to this MYSQL server It comes when Im trying to connect to the server. Do any1 know how I fix it?
View Replies !
Is This Between Statement Allowed?
The following code was part of a larger query which I stripped down to try and work out why it doesn't work; select amount from creditor_amount where dd_date between 2008-08-31 and 2008-10-01; It returns; Empty set, 2 warnings (0.00 sec)
View Replies !
Operation Is Not Allowed
Hi I tried writing but problems crop up. I am not sure what this message means. I am using labSQL for labview. Problem: Exception occured in ADODB.Recordset, Operation is not allowed when the object is closed.. Help Path is C:WINDOWSHELPADO270.CHM and context 1240653 in ADO Recordset.
View Replies !
Host Is Not Allowed To Connect
I have mysql working. I have change my hostname name(until now i used localhost) and i cannot connect. # mysql -u mail -p -h server.domain.com Enter password: ERROR 1130: Host '196.26.0.3' is not allowed to connect to this MySQL server # mysqladmin -u root -h server.domain.com -p password 'pass' Enter password: mysqladmin: connect to server at 'server.domain.com' failed error: 'Host '196.26.0.3' is not allowed to connect to this MySQL server'
View Replies !
Host 'localhost' Is Not Allowed
I'm setting up a server for a client and I get this error "Host 'localhost' is not allowed to connect to this MySQL server" whenever I try running a script that talks to MySQL. I used PHPadmin to access the mysql.user table and change the passwords for both root accounts (localhost and any host). I don't know what exactly caused this but I need to fix it.
View Replies !
Not Allowed To Connect To This MySQL Server
Trying to connect from 1 linux box to another. A to B. The B.user table has a host IP entry and a host name entry for mach A. "mysql -h machB.com -u chuck" returns: ERROR 1130: Host 'machA.com' is not allowed to connect to this MySQL server My search turns up zero.
View Replies !
Host Is Not Allowed To Connect (MS Access)
I am trying to use MS-Access to connect to a MySQL database on our web site. The web site is hosted off-site by a hosting company. I am using Windows XP. I created a User Data Source, using MS ODBC with the following info: Host/Server Name[IP]: mydomain.com Database Name: db_name User: mydomain Password: whatever (using a PHP file, I can the same user id and password as parameters to mysql_conect(). Of course, I use "localhost" as hostname, whereas in setting up the DSN, I used the domain name.) In Access, I created a database, selected File/Get External Data/Import and selected the the DSN, but I get: ODBC -- call failed [MySQL][ODBC 3.51 Driver] Host ['123.456.789.123'] is not allowed to connect to this MySQL server (#1003) Using the IP address for the Host Name does not help. I read in some of the threads that a user needs to be created and GRANTed access. But who would be the user? Why doesn't the userid/password that works through PHP failes to authenticate here?
View Replies !
The Used Command Is Not Allowed With This MySQL Version
I am trying to insert values into a mysql database from a csv or text file using the LOAD DATA LOCAL command and I get the following error message: The used command is not allowed with this MySQL version I read 4.2.4 Security issues with LOAD DATA LOCAL in mysql.com and understand that I have to configure mysql with --local-infile=1 Thatīs what I donīt understand...where do I do this exactly. I typed in the following at the prompt: C:mysqlin: mysqld --local-infile=1 and I get no response (normally another prompt would appear after which I type mysql.exe and I enter into mysql land) I also have phpmyadmin and winmysqladmin...but cannot find with either of these to configure mysql.
View Replies !
Command Is Not Allowed With This MySQL Version
My host just upgraded to PHP5 and one of my scripts is failing. The error is a MySQL error so I am posting here. This is the PHP mysql_query("LOAD DATA LOCAL INFILE '$listingFile1' REPLACE INTO TABLE `Listings_Residential` FIELDS TERMINATED BY ' ' LINES TERMINATED BY ' ' ") or print("Couldn't open database: ".mysql_error()); The error I get from MySQL is "The used command is not allowed with this MySQL version" I don't know if the MySQL version has changed. It is currently 4.1.20. Looking through the MYSQL documentation, I don't see anything in the query that would be affected by the version. The variable $listingFile1 is printing out a file location like /var/www/vhosts/domain.com/httpdocs/deposit/listings-residential.txt which is a valid path.
View Replies !
ERROR 1410 (42000): You Are Not Allowed To Create A User
I have created a user with grant option for e.g. Logged in as root grant select on patient.d_user_info to test1 identified by 'test1' with grant option; // User is created Successfully Logged in as test1 grant select on patient.d_user_info to test2. // I get the you are not allowed error. Also on a related note the command grant select on patient.d_user_info to test1 identified by 'test1' with grant option // when changed to grant select on patient.d_user_info to test1 identified by password 'test1' with grant option produces the following error ERROR 1372 (HY000): Password hash should be a 41-digit hexadecimal number.
View Replies !
Host 'localhost' Is Not Allowed To Connect To This MySQL Server
My instance of mysql was having an issue with too many people connecting to it at once, so I ran the configuration utility. Now all of a sudden, I cannot connect from anywhere including localhost. I keep getting the message Host 'localhost' is not allowed to connect to this MySQL server no matter what method I try of connecting. What I initially did was edit the user table and replaced the root/localhost with root/% and I'm guessing this was overwritten by the utility somehow. Can someone tell me if there's a way I can edit the user database?
View Replies !
Load Data Infile - Is Not Allowed In This MySQL Version
Using my ISP's set up running on their host. created a database, and a table now can't get the data into the table. I'm using their myPHPAdmin and I choose this option: "Insert data from a textfile into table" I have successfully entered data manually and I can retrieve and view it. So the table and the db do function. Since I didn't compile or set any parameters when I created the db I think the permissions should be set up correctly. AssUme-ing the ISP set the scripts up properly--have a trouble ticket into them to check. I BROWSE (my harddisk on my client) to my file and select REPLACE and change the delimiter to "," and I get the following error: (Note: I've also uploaded the file and tried it with the complete path on the host. I've tried .txt instead of .csv and varied all of the options till I'm blue in the face. I'm missing something basic but don't know what.) Code:
View Replies !
Telnet :: Their IP Address' Is Not Allowed To Connect To This MySQL Server
Alright, I have installed MySQL and have got it working from my own computer. But I wanna be able to access my MySQL Server from another computer/server the problem is.. Everytime I try to I get this error "Can't connect to MySQL server on 'My IP Address' (13)" and when I try to telnet to my server I get "Host 'Their IP Address' is not allowed to connect to this MySQL Server" how could I make it so anyone could connect to it and use it if they knew the username/password information?
View Replies !
"Host Not Allowed To Connect To This MySQL Server"
I just recently installed Fedora Core 4 and was just messing around with the MySQL server, I tried using mysql-administrator to connect to the server and i get this strange error "#HY000Host '192.168.1.104' is not allowed to connect to this MySQL server", I saw mysqlaccess and tried granting myself access to this server but i still get the same error while trying to connect!? Any thoughts?
View Replies !
Incorrect Integer Value: 'NULL' For Column Even If NULL Is Allowed
mysql> desc my_table; +------------+---------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------+---------------------+------+-----+---------+-------+ | id | varchar(19) | NO | PRI | | | | value1 | int(11) | YES | | NULL | | | value2 | int(11) | YES | | NULL | | +------------+---------------------+------+-----+---------+-------+ I want to import data from a file that looks like this: 9bcd6f7b47a30fb8_01;NULL;NULL With following command: mysql> load data infile 'filename' into table my_table fields terminated by ';'; And get following error: ERROR 1366 (HY000): Incorrect integer value: 'NULL' for column value1'' at row 1 So the system denies me importing NULL values into a field where NULL is allowed.
View Replies !
Using A View
I want to use a view but I'm unsure how exactly MySQL handles a view and I can't seem to find anything about it in the docs. I guess my question is: Is a view stored as a physical table or is it stored in memory or what? I'm asking because I want to make sure that if it is stored in memory that the amount of ram on my db server doesn't become an issue.
View Replies !
What Is A VIEW?
What is a VIEW? Why when I go to chapter 23 does it tell me how to create, alter, and drop a view, but it doesn't say what it is or what they're used for? Maybe I missed it, but is there any place in the reference where a sentence starts, "A VIEW is...". The closest I've come (looking outside of MySQL site) is a view is 'a predefined join of specified tables'. I take that to mean it is essentially a shortcut to a specific data set relationship and based on that I can see how it is useful, but why isn't this concept defined in the manual? Is it really so obvious that it doesn't require any explanation, or god forbid a demonstration of how it is used? Even more evidence that this is a stupid question is that when I google 'what is a mysql view' I get bounced back to the reference.
View Replies !
Is This Possible With A View?
I'm trying to cut down on the size of my database so I've changed it so that rather than implicitly setting every value in one table, I've split the data into two tables: one table (iData) contains data for the start of evey week: iData ----------------------------- 2000-01-01 Volume: 20000000 2000-01-06 Volume: 30000000 2000-01-11 Volume: 40000000 Another table (jData) contains the delta (difference) from the previous iData entry: jData ----------------------------- 2000-01-02 Volume: 1 2000-01-03 Volume: -2 2000-01-04 Volume: 1 2000-01-05 Volume: 3 2000-01-07 Volume: 2 2000-01-08 Volume: -5 2000-01-09 Volume: 6 2000-01-10 Volume: 1 2000-01-12 Volume: 2 2000-01-13 Volume: -4 2000-01-14 Volume: 4 2000-01-15 Volume: 3 Obviously this will save a lot of space as the delta is much smaller than storing the exact value (standard compression technique). So what I would like to do is create a view to automatically display all of the data as if it were all stored in one table: All Data: --------- 2000-01-01 Volume: 20000000 2000-01-02 Volume: 20000001 2000-01-03 Volume: 19999999 2000-01-04 Volume: 20000000 2000-01-05 Volume: 20000003 2000-01-06 Volume: 30000000 2000-01-07 Volume: 30000002 2000-01-08 Volume: 29999997 2000-01-09 Volume: 30000003 2000-01-10 Volume: 30000004 2000-01-11 Volume: 40000000 2000-01-12 Volume: 40000002 2000-01-13 Volume: 39999998 2000-01-14 Volume: 40000002 2000-01-15 Volume: 40000005 I know I can do this programatically, but is it possible to do this with a view? Any pointers would be much appreciated.
View Replies !
View Schema
is there a tool to view a schematic of a MySQL DB I don't mean the .sql file I mean a pretty chart type schematic.
View Replies !
VIEW In MySQL
select NO_RESPONSABLE, NOM + PRENOM as NAME from RESPONSABLE Gives me the number of the ID, but also "0" as the result of the concatenated NAME.
View Replies !
Mysqldump View
I try to dump the view definition and records using the following command. mysqldump -uroot -psecret! --databases test --tables proxy_view > mytest.txt What all I get is the view definition without records. What is the correct method of dumping a view?
View Replies !
|
TRACKER
