Mysql Query Failed With Error 1142
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings
Select Command Denied To User ''@'localhost' For Table 'user' Mysql
and policies of this site About Us Learn more about Stack Overflow mysql error 1142 create command denied to user the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags
Mysql Trigger Command Denied To User
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 mysql error 1142 42000 takes a minute: Sign up MySQL Error: #1142 - SELECT command denied to user up vote 13 down vote favorite 3 I'm having troubles with a certain query on one of my servers. On all other places I've tested it it works completely fine but on the server i want to use it it isn't working. It's about the following select command denied to user 'root'@'localhost' for table 'user' SQL: SELECT facturen.id AS fid, projecten.id AS pid, titel, facturen.totaal_bedrag AS totaal, betaald, datum FROM facturen, projecten WHERE facturen.project_id = projecten.id AND projecten.eigenaar = '1' ORDER BY datum DESC This is the error code I get from it: SELECT command denied to user 'marco'@'localhost' for table 'projecten' The tables: facturen: CREATE TABLE IF NOT EXISTS `facturen` ( `id` int(11) NOT NULL auto_increment, `project_id` int(11) NOT NULL, `datum` int(11) NOT NULL, `lever_datum` int(11) NOT NULL, `totaal_bedrag` decimal(9,2) NOT NULL, `btw` decimal(9,2) NOT NULL, `bedrijf` varchar(40) NOT NULL, `contactpersoon` varchar(60) NOT NULL, `adres` varchar(60) NOT NULL, `postcode` varchar(7) NOT NULL, `plaats` varchar(30) NOT NULL, `betaald` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=201200006 ; projecten: CREATE TABLE IF NOT EXISTS `projecten` ( `id` int(11) NOT NULL auto_increment, `titel` varchar(80) NOT NULL, `eigenaar` int(11) NOT NULL, `creatie_datum` int(11) NOT NULL, `eind_datum` int(11) NOT NULL, `totaal_bedrag` decimal(9,2) NOT NULL, `btw` decimal(9,2) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=201200004 ; The strange part is that every other query on both the 'projecten' table and the 'facturen' table works complete
here for a quick overview of the site Help Center Detailed answers to any questions
Select Command Denied To User For Table 'proc'
you might have Meta Discuss the workings and policies of this mysql error 1142 insert command denied to user site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers
Error 1142 Junos Pulse
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 http://stackoverflow.com/questions/10956195/mysql-error-1142-select-command-denied-to-user community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up CREATE command denied for user that has GRANT ALL PRIVILEGES up vote 9 down vote favorite I am trying to set up a MySQL replication slave, and am having a very difficult time running http://stackoverflow.com/questions/5254537/create-command-denied-for-user-that-has-grant-all-privileges LOAD DATA FROM MASTER;. Yes, I know it is deprecated, but I am running MySQL 5.1, and that isn't my problem at the moment. For some reason MySQL keeps telling me the CREATE command is denied, but a check of SHOW GRANTS says otherwise. Check this out: mysql> SHOW GRANTS; +--------------------------------------------------------------------------------------------------------------------+ | Grants for replicator@% | +--------------------------------------------------------------------------------------------------------------------+ | GRANT ALL PRIVILEGES ON *.* TO 'replicator'@'%' IDENTIFIED BY PASSWORD '*ABCDEFABCDEFABCDEFABCDEFBLAHBLAHBLAHBLAH' | +--------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.00 sec) mysql> LOAD DATA FROM MASTER; ERROR 1142 (42000): CREATE command denied to user 'replicator'@'localhost' for table 'aggregate' mysql> What I thought was odd here is that when calling LOAD DATA FROM MASTER, it thinks I am 'replicator'@'localhost', yet SHOW GRANTS says 'replicator'@'%'. Just to be safe, I gave the same privs to 'replicator'@'localhost' as well. mysql> SHOW GRANTS FOR 'replicator'@'localhost'; +----------------------------------------------------------------------------------------------------------------------------+ | Grants for replicator@localhost | +----------------------------------------------------------------------------------------------------------------------------+ | GRANT ALL PRIVILEGES ON *.* TO 'replicator'@'localhost' IDENTIFIED BY PASSWORD '*ABCDEFABCDEFABCDEFABCDEFBLAHBLAHBLAHBLAH' | +---------
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 http://stackoverflow.com/questions/18424797/1142-select-command-denied-to-user-localhost-for-table-pma-table-uipref 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 https://bugs.mysql.com/bug.php?id=13477 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up #1142 - SELECT command denied to user ''@'localhost' for table 'pma_table_uiprefs' up vote 11 down vote favorite 4 command denied Hopefully someone can help me, for I have queried the web with no success or concrete answer to this error. I’m using Windows and Xampp. Here is the error I am getting after I have recently imported the database into phpmyadmin… #1142 - SELECT command denied to user ''@'localhost' for table 'pma_table_uiprefs' After I import the database, everything is fine in phpmyadmin until I log out and then log back in, this command denied to is where the problem lies. When I click on any of the tables from the imported database, I get the following errors… SELECT 'prefs' FROM 'phpmyadmin'.'pma_table_uiprefs' WEHRE 'username' = 'root' AND 'db_name' = 'afdb' AND 'table_name' = 'role' #1142 - SELECT command denied to user ''@'localhost' for table 'pma_table_uiprefs' Thank you again for taking time to read my post and hopefully someone can help me with this error. mysql phpmyadmin share|improve this question asked Aug 25 '13 at 1:30 user1558832 65115 My guess is that the user has privileges to at least the SELECT command is denied and needs to be modified by logging in with admin access to modify user privileges to allow SELECT command –Class Aug 25 '13 at 1:51 add a comment| 8 Answers 8 active oldest votes up vote 26 down vote The pma_table_uiprefs table contains user preferences. In phpMyAdmin's config.inc.php, access to this table (and other tables in the configuration storage) is done via the control user. In your case, the controluser parameter is empty, therefore the query fails. For a short-term fix, put the "//" characters in config.inc.php at the start of this line: $cfg['Servers'][$i]['pmadb'] = 'phpmyadmin'; then log out and log back in. For a long-term fix, correctly set up the configuration storage, see http://docs.phpmyadmin
Status: Can't repeat Impact on me: None Category:MySQL Server Severity:S2 (Serious) Version:5.0.15 OS:Linux (Linux) Assigned to: Sergey Glukhov View Add Comment Files Developer Edit Submission View Progress Log Contributions [26 Sep 2005 8:59] Andrejs Dubovskis Description: While executing SQL command got an error: "INSERT command denied to user ...." At the same time required grants was asigned to user and the same SQL statement has multiply successfull pases before the error was generated. How to repeat: We found how to repeat this error in simple manner. Very important to asign grants to two remote users (on host1 & host2). I am not able to repeat this problem, if access was granted to single remote user only. 1) prepare schema create database sqltest; use sqltest; CREATE TABLE `whitelist` ( `example` int(11) default NULL ) ENGINE=MyISAM; grant select,insert,delete on sqltest.whitelist to sqltest@'any.remote.host1'; grant select,insert,delete on sqltest.whitelist to sqltest@'any.remote.host2'; 2) create test.pl on remote host1; for (1..100000) { print "INSERT INTO whitelist VALUES(1);\n" ; } 3) run commands on remote host1; perl test.pl | mysql -u sqltest -h db sqltest & perl test.pl | mysql -u sqltest -h db sqltest & Suggested fix: Only temporary fix, reducing SQL security: revoke all priveleges from tables and grant all priveleges on database; grant all on sqltest.* to sqltest@'any.remote.host'; [26 Sep 2005 13:00] Andrejs Dubovskis Possibly, this thing may be important: we using --skip-name-resolve on server [1 Oct 2005 10:56] Valerii Kravchuk Just curious, what values are used instead of 'any.remote.host1' and 'any.remote.host2'. IP addresses, I hope? Host names are ignored when --skip-name-resolution is provided... Why do you need this --skip-name-resolution option? I've just tested with 4.1.14 on Linux and host names instead of addresses - everything works OK, as expected. Can you try to run without it and use host names? If you can't, the other questi