Mysql Error Could Not Fetch User Names
Reporter: Wayne Fuller Email Updates: Status: Won't fix Impact on me: None Category:MySQL Administrator Severity:S1 (Critical) Version:1.2.17 OS:Other (Windows XP sp3) Assigned to: Tags: CHECKED, Server Connections, user administration Triage: Triaged: D1 (Critical) / R3 (Medium) / E4 (High) View Add Comment Files Developer Edit Submission View Progress Log Contributions [9 Apr 2009 3:28] Wayne Fuller Description: Administrator comes up ok, however once there I get the following errors: 1. User Administration menu selection - Could not fetch user names - SELECT command denied to "@'localhost' for table 'user' (1142). Clicking on "Add new user" button gives me a "Access violation" error and the "add new user" button goes gray, and stays that way. No other actions are possible. 2.Server Connections menu selection - get "Could not fetch Process list" (Access dinied, you need the PROCESS privilege for this operation (1227)). Another "Access violation" and I have to abort the Administrator. How to repeat: Not sure, every time I open "Administrator", I get these errors. [9 Apr 2009 6:15] Valerii Kravchuk Thank you for the bug report. Verified just as described if connected as non-privileged user, like this one: C:\Program Files\MySQL\MySQL Server 5.1\bin>mysql -uuser1 -P3308 test Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 42 Server version: 5.0.79-enterprise-gpl-nt MySQL Enterprise Server - Pro Edition ( GPL) Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> show grants; +-------------------------------------------------------------+ | Grants for user1@% | +-------------------------------------------------------------+ | GRANT USAGE ON *.* TO 'user1'@'%' | | GRANT SELECT, INSERT ON `data_base`.* TO 'user1'@'%' | | GRANT ALL PRIVILEGES ON `test`.`nonexistant` TO 'user1'@'%' | +-------------------------------------------------------------+ 3 rows in set (0.01 sec) This crash does NOT happen if you connect as root, for example. [11 Apr 2009 15:19] Wayne Fuller I'm sure you understand everything you said, but
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Error “mysql could not fetch schema table status” up vote 0 down vote favorite The error mysql could not fetch schema table status occurs when I try backup or list database tables using MySql Administrator. I did http://bugs.mysql.com/44175 some research on MySql Bugs (id=28140) and also MySql Forums (http://forums.mysql.com/read.php?34,169966,170024#msg-170024). Their solution talks about McFee. Actually I rent a Windows 2003 VPS host and I don't have any anti-virus installed. Do you know exactly what is it? mysql host share|improve this question asked Jun 3 '09 at 0:47 Eduardo Xavier 9311526 add a comment| 1 Answer 1 active oldest votes up vote 1 down vote accepted The mysql bug 28140 has two solutions, actually; one of them deals with McAffee, http://stackoverflow.com/questions/942609/error-mysql-could-not-fetch-schema-table-status but the other says that it can occur if your TEMP or TMP environment variables point to a non-existent directory, or one that mysql does not have access to write to. Have you tried that? share|improve this answer answered Jun 3 '09 at 1:56 Todd Gardner 10.2k2142 Thanks Todd, I tried a non-existent directory such as c:\Temp\mysql2 and the server couldn't be started. I denied permission for SYSTEm on c:\Temp\mysql and the server couldn't be started. –Eduardo Xavier Jun 3 '09 at 2:15 My host provider did install McAfee on the hardware node. It caused the problem and I'm asking them to make an exception scan on the folder c:\Temp\mysql. Thanks anyway! –Eduardo Xavier Jun 5 '09 at 13:17 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign up using Facebook Sign up using Email and Password Post as a guest Name Email Post as a guest Name Email discard By posting your answer, you agree to the privacy policy and terms of service. Not the answer you're looking for? Browse other questions tagged mysql host or ask your own question. asked 7 years ago viewed 2572 times active 7 years ago Related 335MySQL Error 1093 - Can't specify target table for update in FROM clause593How do I quickly rename a MySQL database (change schema name)?319MySQL Error 1153 - Got a packet bigger than 'max_allowed_packet' bytes268Duplicating a MyS
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and http://stackoverflow.com/questions/13127538/mysql-workbench-fetching-cannot-browse-db policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes mysql error a minute: Sign up MySQL Workbench “fetching…” — cannot browse DB up vote 7 down vote favorite I've been having a lot of issues lately, basically since the last time I upgraded XAMPP for OSX (v1.7.3) and/or my MySQL GUI tools. Using MySQL Workbench (v5.2.44), I can connect to the DB running in XAMPP just fine, but trying to browse any mysql error could database, under tables/views/etc it only shows "Fetching..." and never shows anything else. I can actually query tables, which is interesting, but I can't actually manage the databases in any meaningful way. Googling, others reported having luck running mysql_upgrade on the command line, which ran fine but did not fix my issue. mysql osx xampp share|improve this question asked Oct 29 '12 at 18:28 bmoeskau 16.6k55465 add a comment| 4 Answers 4 active oldest votes up vote 9 down vote The following command worked for me on windows: C:\Program Files\MySQL\MySQL Server 5.5\bin>mysql_upgrade.exe -u root -p --force If the root password is not set, you might need to do this before you run the command above: mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('something'); share|improve this answer answered Jan 4 '13 at 18:41 Sachin Maharjan 11613 I am getting tons of "file not found error" when I try this? –Koray Tugay Apr 6 '13 at 17:48 You don't have to set root password to run mysql_upgrade, simply omit "-u" switch. –matt Apr 10 '13 at 19:03 worked