Mysql 1142 Error
Contents |
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 mysql error 1142 create command denied to user Learn more about Stack Overflow the company Business Learn more about hiring developers
Mysql Trigger Command Denied To User
or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack select command denied to user 'root'@'localhost' for table 'user' 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 MySQL Error: #1142 - SELECT command denied
Error 1142 (42000)
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 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 mysql error 1142 insert command denied to user = 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 completely fine, also this query works fine on two other servers of mine. mysql select command denied share|improve this question edited Jun 8 '12 at 21:30 asked Jun 8 '12 at 21:22 Seph 1371111 what i
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
Select Command Denied To User For Table 'proc'
company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions
Error 1142 Junos Pulse
Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million drop command denied to user mysql 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 Hopefully someone http://stackoverflow.com/questions/10956195/mysql-error-1142-select-command-denied-to-user 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 is where the problem http://stackoverflow.com/questions/18424797/1142-select-command-denied-to-user-localhost-for-table-pma-table-uipref 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.net/en/latest/setup.html#phpmyadmin-configuration-storage share|improve this answer answered Aug 25 '13 at
Start 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 http://serverfault.com/questions/597922/mysql-grant-command-denied-to-user-rootdhcp-x-x-x-x-company-for-table-t more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Server Fault Questions Tags Users Badges Unanswered Ask Question _ Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to command denied the top Mysql: GRANT command denied to user 'root'@'dhcp-x-x-x-x.